Topic 2 Question 13
Which of these is not a supported method of putting data into a partitioned table?
If you have existing data in a separate file for each day, then create a partitioned table and upload each file into the appropriate partition.
Run a query to get the records for a specific day from an existing table and for the destination table, specify a partitioned table ending with the day in the format "$YYYYMMDD".
Create a partitioned table and stream new records to it every day.
Use ORDER BY to put a table's rows into chronological order and then change the table's type to "Partitioned".
解説
You cannot change an existing table into a partitioned table. You must create a partitioned table from scratch. Then you can either stream data into it every day and the data will automatically be put in the right partition, or you can load data into a specific partition by using "$YYYYMMDD" at the end of the table name. Reference: https://cloud.google.com/bigquery/docs/partitioned-tables
ユーザの投票
コメント(4)
answer : D
👍 8[Removed]2020/03/21Answer: D Description: Once table is created, you cannot change it partitioned
👍 7[Removed]2020/03/28D
A: would work but doesn't make sense B: possible but unusual C: works D: wrong, cannot change partitioning after creating
👍 3retep0072021/09/29
シャッフルモード