Range-Range Partitioning

[naveen_k1]

Hello,

I have table which is not partitioned right now. There are two date fields in the table. I want to use multi level range - range partitioning.

I tried to use the following logic but I got an error.

For date field 1,

The above statement executed successfully.

For date field 2,

when I executed the above statement I got the following error

Does HANA support Range-Range partitioning?  If so how should I write the partition spec for the second level?

[Former Member]

Hi Naveen,

Range-range partitioning is added in SPS09. Range-Range Partitioning - SAP HANA Administration Guide - SAP Library Which HANA revision did you use?

Best regards,

Wenjun