Can I have more than 1 column with partitioned attribute at HDB

Community Support
1

Hi all, can I have more than 1 column with partitioned attribute at HDB? I guess not?

2

yes, if your data can be ordered as such.

Any column can have an attribute if the data in the column supports the properties required by the attribute.

3

As Charlie says, you can provided that the sorting/partitioning of the first p# column also results in the required sorting/partitioning of a second column. One common example is having a p# on a ticker column (with exchange suffixes) and then also having a p# on a corresponding “root ticker” column (with suffixes stripped). The sorting of the first would imply the sorting of the second. 

But in most other scenarios it’s not likely that the sorting of one implies the sorting of another so using g# on the other columns is also common practice.

4

Thanks all