Topic 2 Question 9
How would you query specific partitions in a BigQuery table?
Use the DAY column in the WHERE clause
Use the EXTRACT(DAY) clause
Use the __PARTITIONTIME pseudo-column in the WHERE clause
Use DATE BETWEEN in the WHERE clause
解説
Partitioned tables include a pseudo column named _PARTITIONTIME that contains a date-based timestamp for data loaded into the table. To limit a query to particular partitions (such as Jan 1st and 2nd of 2017), use a clause similar to this: WHERE _PARTITIONTIME BETWEEN TIMESTAMP('2017-01-01') AND TIMESTAMP('2017-01-02') Reference: https://cloud.google.com/bigquery/docs/partitioned-tables#the_partitiontime_pseudo_column
コメント(5)
Answer C
👍 9[Removed]2020/03/21Question assumes that partitioned table is created based on ingestion timestamp. Hence [C] is correct. But A & D are also very close options. Wonder why A & D are wrong
👍 8dambilwa2020/06/24Answer: C Description: Logical partition column is queried using _partitiontime
👍 5[Removed]2020/03/28
シャッフルモード