Single-dimension range partitioning column type

What should be the data type of single dimension partition column? Can it be long ?


Welcome @johny! It looks like the answer is yes.

Let us know how it goes.



Hi is there any tradeoff between using string or long column as single dimension partition column? Or do they work similar?

The partitioning process should be similar: calculate a distribution of values per time chunk to calculate partition boundaries and then split the data according to those boundaries and finally merge the data into final segment files.

An advantage of using string is that the column will have a bitmap index in the segment files, so that after the help of pruning from partitioning it can still take advantage of the bitmap index operations for fast processing of filter conditions within the segment files that it ends up reading.