Limitations

maximum 8000 partitions possible on a single table and upto 4 columns can be used for clustering

Partition can be done on Date, DATETIME, TIMESTAMP OR INTERGER RANGE COLUMN.

when you use clustering and partitioning together, the data can be partitioned by a date, date time or timestamp column, and then clustered on a different set of columns.

can you create partition without clustering?

if you dont have partitioned column, and you want benefits of clustering, you can create a fake underscore date column of type date and have all the values be null.

Leave a Reply

Your email address will not be published. Required fields are marked *