google-bigquery - BigQuery - 列出日期分区表的分区？

Question

查询 -- SELECT partition_id from Mydataset.Table$__PARTITIONS_SUMMARY__ ;
给出以下错误——表“Mydataset.Table$ PARTITIONS_SUMMARY ”不能包含装饰器`

Answer 1

在旧版 SQL 中尝试以下操作

SELECT project_id,
    dataset_id,
    table_id,
    partition_id,
    TIMESTAMP(creation_time/1000) AS creation_time
FROM [Mydataset.Table$__PARTITIONS_SUMMARY__]

及以下标准 SQL

SELECT _PARTITIONTIME as pt
FROM `Mydataset.Table`
GROUP BY 1

这也适用于旧版 SQL

SELECT _PARTITIONTIME as pt
FROM [Mydataset.Table]
GROUP BY 1