Article Outline
TOC
Collection Outline
[BIGQUERY] 分析入門
[BIGQUERY] SQL
■ 関数
- approx_count_distinct()
- coalesce()
- countif()
- extract()
- ifnull()
- lead() / lag()
- left() / right()
- lower()
- nullif()
- parse_date()
- percentile_()
- row_number()
- safe_cast()
- split()
- st_distance()
- struct()
- unnest()
■ 演算子
■ 句（節）
■ BigQuery特有
■ ERROR
- To copy a table, the destination and source datasets must be in the same region. Copy an entire dataset to move data between regions.
- Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex
[BIGQUERY] ML
[BIGQUERY] DS
■ DS100ノック
■
[BIGQUERY] GA
|| LIMIT句 OFFSET句
| LIMIT句
| OFFSET句
| コンビネーション
select
*
from
rawdata
order by
USERID
limit 1000000 -- 1~1000000迄
-- limit 1000000 offset 1000001 -- 1000001~2000000迄
-- limit 1000000 offset 2000001 -- 2000001~3000000迄
-- limit 3314884 offset 3000001 -- 3000001~3314884迄|| REFERENCE
- 取得するデータの数と開始位置を指定(LIMIT句, OFFSET句) - DBOnline
