Creating Date-Partitioned Tables in BigQuery

Go to Lab

1204 评论

"Why did the previous query return 0 records but still scan through 1.74GB of data?" First of all it's "returns" and also the structure of the question isn't totally correct! Like this phrase too "Update the ORDER BY clause to show the oldest partitions first. The date you see there Add this query and run it:"

Hazem A. · 评论大約 5 小時之前

篤 渡. · 评论大約 10 小時之前

Sofiane K. · 评论大約 11 小時之前

Ryan M. · 评论大約 20 小時之前

Lovely lab, creating new tables and mastering SQL!! Bonus !! Loving every moment!!

Alex T. · 评论大約 22 小時之前

Gina_Lady G_ M. · 评论一天之前

Salahuddin H. · 评论一天之前

Sezin E. · 评论一天之前

Gustavo D. · 评论2 天之前

Mehadi H. · 评论2 天之前

mehreenhushmand m. · 评论4 天之前

Christoph S. · 评论4 天之前

PPP P. · 评论4 天之前

Christos Z. · 评论4 天之前

Jonathan B. · 评论5 天之前

VINOTHKUMAR R. · 评论5 天之前

Radha G. · 评论5 天之前

Fahrettin A. · 评论5 天之前

sumit b. · 评论5 天之前

Jim v. · 评论6 天之前


Majd J. · 评论6 天之前

Toberosa P. · 评论6 天之前

山﨑祥嗣 山. · 评论6 天之前

Don't understand where the 'stn' comes from in the inner query when creating the partitioned table: (SELECT ANY_VALUE(name) FROM `bigquery-public-data.noaa_gsod.stations` AS stations WHERE stations.usaf = stn) AS station_name

Tiew Kee Hui -. · 评论6 天之前

Erdem A. · 评论6 天之前