Re: not able to create multi column partition keys

[Mattias Jonsson]

What you can try is to either split the DATETIME column into two columns, DATE and TIME.
CREATE TABLE t (id INT, d DATE, t TIME)
PARTITION BY LIST COLUMNS(id, d)
...

Or you can try to do RANGE COLUMNS (d, id).

One other suggestion is to use subpartitioning:
PARTITION BY RANGE COLUMNS(d)
SUBPARTITION BY HASH (id) SUBPARTITIONS 3
(PARTTION p1 VALUES LESS THAN ('2010-01-01'),
...);

This way it is even easier to manage the partitions.