Article Outline
TOC
Collection Outline
[BIGQUERY] 分析入門
[BIGQUERY] SQL
■ 句（節）
■ 演算子
■ BigQuery特有
■ 関数
- approx_count_distinct() - 集計近似
- coalesce()
- countif()
- extract()
- greatest()
- ifnull()
- last_day()
- lead() / lag()
- left() / right()
- lower()
- nullif()
- parse_date()
- row_number() - 番号付
- safe_cast()
- split()
- st_distance()
- nth_value()
- first_value() / last_value()
- percentile_()
データ型
■ エラー
- error
- Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex
[BIGQUERY] ADVANCE
[BIGQUERY] ML
[BIGQUERY] DS
■ DS100ノック
■
[BIGQUERY] GA
|| BigQueryのエラー
|
Query exceeded resource limits. This query used 96791 CPU seconds but would charge only 170M Analysis bytes.
This exceeds the ratio supported by the on-demand pricing model.
Please consider moving this workload to the flat-rate reservation pricing model, which does not have this limit.
96791 CPU seconds were used, and this query must use less than 43500 CPU seconds.|
To copy a table, the destination and source datasets must be in the same region.
Copy an entire dataset to move data between regions.作成したクエリの抽出結果（300万レコード程）を一時的にテーブル化しようとしたら、以下のようなエラーが出て困った。。
似たような事象の人が相談していた。（*2）
|
|
|| REFERENCE
- データセットのコピーの設定 - GoogleCloud
- Location error on BigQuery - GoogleCloud(*2)
- -
