关于“Partitioned Tables in Google BigQuery”的评价

Lucas S. · 已于 over 4 years前审核

There were two tables in the public dataset not following the pattern gsod*, which cause the query to fail. Even after I adapt the query to run and not get data from those two tables, I failed to insert data from the public dataset into my own table. I even tried using INSERT INTO mytable SELECT * FROM anotherTable and still nothing happened.

Nícholas C. · 已于 over 4 years前审核

Renaud S. · 已于 over 4 years前审核

Safouane B. · 已于 over 4 years前审核

Valerie D. · 已于 over 4 years前审核

Elodie P. · 已于 over 4 years前审核

AHMED K. · 已于 over 4 years前审核

Anandha B. · 已于 over 4 years前审核

Savitha S. · 已于 over 4 years前审核

Mark P. · 已于 over 4 years前审核

#standardSQL # avg monthly precipitation SELECT AVG(prcp) AS average, station_name, date, CURRENT_DATE() AS today, DATE_DIFF(CURRENT_DATE(), date, DAY) AS partition_age, EXTRACT(MONTH FROM date) AS month FROM ecommerce.days_with_rain WHERE station_name = 'WAKAYAMA' #Japan GROUP BY station_name, date, today, month, partition_age ORDER BY partition_age DESC

Anastasiia S. · 已于 over 4 years前审核

Husky / Takuya H. · 已于 over 4 years前审核

Michal L. · 已于 over 4 years前审核

Santosh B. · 已于 over 4 years前审核

Venkata A. · 已于 over 4 years前审核

Raven T. · 已于 over 4 years前审核

Murine L. · 已于 over 4 years前审核

EURY EDUARDO N. · 已于 over 4 years前审核

Javier I. · 已于 over 4 years前审核

Juhi P. · 已于 over 4 years前审核

Sherry H. · 已于 over 4 years前审核

Jose A. · 已于 over 4 years前审核

nice

Stefano C. · 已于 over 4 years前审核

Vaseemakram s. · 已于 over 4 years前审核

André P. · 已于 over 4 years前审核