关于“在 BigQuery 中创建日期分区表”的评价

RAMA MANIKANTA P. · 已于 over 3 years前审核

Yaretzin A. · 已于 over 3 years前审核

Using CTE makes more readable query than using subquery ``` #standardSQL CREATE OR REPLACE TABLE ecommerce.days_with_rain2 PARTITION BY date OPTIONS ( partition_expiration_days=60, description="weather stations with precipitation, partitioned by day" ) AS WITH gsod AS ( SELECT DATE(CAST(year AS INT64), CAST(mo AS INT64), CAST(da AS INT64)) AS date, prcp, stn FROM `bigquery-public-data.noaa_gsod.gsod*` AS weather WHERE prcp < 99.9 -- Filter unknown values AND prcp > 0 -- Filter stations/days with no precipitation AND _TABLE_SUFFIX >= '2018' ), stations AS ( SELECT usaf, ANY_VALUE(name) AS name FROM `bigquery-public-data.noaa_gsod.stations` GROUP BY usaf ) SELECT gsod.date AS date, stations.name AS station_name, gsod.prcp AS prcp FROM gsod LEFT JOIN stations ON gsod.stn = stations.usaf ```

Hector T. · 已于 over 3 years前审核

Daring C. · 已于 over 3 years前审核

Jacob W. · 已于 over 3 years前审核

kalyani p. · 已于 over 3 years前审核

Rasid K. · 已于 over 3 years前审核

Hannah M. · 已于 over 3 years前审核

3030_Km Deep S. · 已于 over 3 years前审核

Dmytro S. · 已于 over 3 years前审核

Maria Alejandra M. · 已于 over 3 years前审核

Swaraj M. · 已于 over 3 years前审核

Juan Carlos O. · 已于 over 3 years前审核

Manasij H. · 已于 over 3 years前审核

Manas J. · 已于 over 3 years前审核

Matthaios S. · 已于 over 3 years前审核

Yu-An C. · 已于 over 3 years前审核

BENJAMIN IGNACIO M. · 已于 over 3 years前审核

Pankaj M. · 已于 over 3 years前审核

MANUEL ISAAM A. · 已于 over 3 years前审核

Shantanu G. · 已于 over 3 years前审核

Himanshi R. · 已于 over 3 years前审核

Suraj S. · 已于 over 3 years前审核

Mark Vincent D. · 已于 over 3 years前审核