Single-dimension range partitioning column type

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

Thanks,
Johny

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

Let us know how it goes.

Best,

Mark

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.

2 Likes