我执行以下查询时收到 Resources exceeded during query execution 错误:
SELECT EXACT_COUNT_DISTINCT(id)FROM [bigquery-public-data:github_repos.contents]
我使用了EXACT_COUNT_DISTINCT聚合函数,因为COUNT([DISTINCT])函数只给出了统计近似值 .
试试下面
for BigQuery Legacy SQL
SELECT COUNT(1) AS cnt FROM ( SELECT id FROM [bigquery-public-data:github_repos.contents] GROUP BY id )
用于BigQuery标准SQL
SELECT COUNT(DISTINCT id) as cnt FROM `bigquery-public-data.github_repos.contents`
1 回答
试试下面
for BigQuery Legacy SQL
用于BigQuery标准SQL