This is with respect to partitions.
I have a table which is partitioned by period_key column ( period_key is a int column)
The partition expression is like this
Code: Select all
((xxxx.PERIOD_KEY / 7))::int
Code: Select all
select count(distinct(period_key / 7)) from xxxx.
This gives me 749
But if I check the number of partition_keys for this table in partitions table
Code: Select all
select count(distinct(partition_key)) from partitions where projection_name='xxxx' and table_schema='xxxx'
Am I making any mistake in calculating the period_keys.....They should be same right ?
Thanks