当使用BigQuery分区表时,可能会遇到一些问题,在查询成本时会出现错误的估算。通常,这是由于查询过于复杂或无法正确处理分区表而引起的。为了解决这个问题,我们可以尝试以下方法:
SELECT * FROM mydataset.mytable$20190101
SELECT * FROM mydataset.mytable
WHERE _PARTITIONTIME BETWEEN TIMESTAMP('2019-01-01')
AND TIMESTAMP('2019-01-31')
SELECT COUNT(*) FROM bigquery-public-data.samples.gsod
SELECT COUNT(*) FROM bigquery-public-data.samples.gsod
WHERE _PARTITIONTIME = TIMESTAMP("2017-01-01")
SELECT COUNT(*) FROM bigquery-public-data.samples.gsod
WHERE date='2017-01-01'