最新 | 最热门 | 最高评价
---

+0  Some hints on Dataproc

Tag: bigdata | GCP | Hive | PySpark
ROBIN DONG 发于 2021年09月03日 11:54 | 点击: 1791 | 展开摘要
When running a job in the cluster of Dataproc, it reported:

java.util.concurrent.ExecutionException: java.lang.ClassNotFoundException: Failed to find data source: BIGQUERY.

The reason is I haven’t added the Jar file for BigQuery. Af

查看全文: http://www.udpwork.com/item/18151.html
---

+0  Recover truncated table in BigQuery

Tag: bigdata | BigQuery
ROBIN DONG 发于 2021年06月03日 14:39 | 点击: 525 | 展开摘要
If you accidentally truncate a table in BigQuery, you can try this article to recover the data. Furthermore, I found out that the "bq cp project:dataset.table@-36000 project:dataset.table” method could not work in my situation. The on

查看全文: http://www.udpwork.com/item/17903.html
---

+0  Change the schema of BigQuery tables

Tag: bigdata | BigQuery
ROBIN DONG 发于 2021年03月11日 11:27 | 点击: 534 | 展开摘要
We can easily add new column for a table in BigQuery:

ALTER TABLE mydataset.mytable
ADD COLUMN new_col STRING

But when you want to delete or rename an existed column, there is no SQL to implement it. The only way to delete or rename

查看全文: http://www.udpwork.com/item/17659.html
|<<<1>>>| 一共1页, 3条记录