Partitioning - default partition ?

 Hi Kamil, 

What you can do is make use of a derived default value for your partition_key column.

See example:

CREATE TABLE
 abc
 (
 data INT,
 potential_id_key INT,
 partition_key VARCHAR(10) NOT NULL DEFAULT
 CASE
 WHEN (abc.potential_id_key = 9)
 THEN 9
 WHEN (abc.potential_id_key = 8)
 THEN 8
 WHEN (abc.potential_id_key = 7)
 THEN 7
 ELSE 1
 END
 )
 PARTITION BY
 (
 abc.partition_key
 );

  - let`s say that your table has 2 columns and the third one "partition_key" is created just for the sole purpose of marking the partition location for that row of data based on the value of potential_id_key column.

 - every time you do an insert in the table the partition_key will be populated.

Hope this helped ! 

Hi,

Thanks for a quick reply...

It sounds ok. It can be somekind of workaroud. I will have to check if this will have some influence on the performance...

One more question.

Do I need to change all projections order definitions? Im just wondering, because i remember (from official docs) that the order in projection should contains partition_key column if first place.