Separation based on column data?

When creating a partitioned table using bq mk --time_partitioning_type=DAYare the sections created based on the load time of the data, and not the date key in the table data itself?

To create sections based on dates in a date, the current approach is used to manually create tables with closed tables and load them by date, as in this record since 2012?

+4
source share
2 answers

Yes, partitions created on the basis of data loading time, not based on the data itself.
You can use the section decorator ( mydataset.mytable1$20160810) if you want to load data into a specific section

- , - ,

+2

: BigQuery , , .

: 2000 .

+2

Source: https://habr.com/ru/post/1650817/


All Articles