Partitioning a table in HANA using Range Partitioning using multiple values from Partitioning column

[shuvendu]

Hello Experts,

I am planning to perform a single level Range Partitioning of a table in HANA.

As per the example given in SAP documentation (https://help.sap.com/docs/HANA_SERVICE_CF/6a504812672d48ba865f4f4b268a881e/c338627bbb571014ae7d95338...) I can create a single partition using only one VALUE from the partitioning column.

Example: PARTITION BY RANGE("TESTRESULT") ((PARTITION VALUES = 0), (PARTITION VALUES = -1), (PARTITION VALUES = -10), (PARTITION OTHERS));

Is it possible to create a single partition by using more than one values from the partitioning column? 

To explain my question further using the same example above, can I create one partition using VALUES '0' and '-1' from the column TESTRESULT?

Thanks,

Shuvendu

[simon25]

Hi Shuvendu,

If you mean like this, then yes :
PARTITION 2016031400 <= VALUES < 2016031500, PARTITION OTHERS

"For heterogeneous range partitioning the numeric data types support negative and positive numbers"

PARTITION BY RANGE("TESTRESULT") ((PARTITION VALUES = 0), (PARTITION VALUES = -1), (PARTITION VALUES = -10), (PARTITION OTHERS));

Kind Regards
Simon