在 BigQuery 中使用分区表分析 Google Play 商店上的应用程序数据。
代码示例:
CREATE TABLE `project_id.dataset_id.table_name`
PARTITION BY DATE(date_column)
AS
SELECT *
FROM `project_id.dataset_id.source_table`
SELECT *
FROM `project_id.dataset_id.table_name`
WHERE date_column BETWEEN 'start_date' AND 'end_date'
上一篇:AnalyserNode.getFloatFrequencyData() 返回负值。
下一篇:Analysis Services Tabular Model - New Calculated Table (with DAX) 按周分组