Skip to Content
0

INTERVAL in Range Partition- SPS12

Nov 30, 2016 at 04:09 AM

50

avatar image

Hello Experts,

In Teradata, we have one option named INTERVAL which helps to define the interval at which we want the range partition to work. In HANA, I see that we have to mention all the dates respectively for each partition. Do you know if there any option like INTERVAL in HANA? I do have similar re-quirement and we are currently on SPS12. Can we achive this now?

Thanks in advance,

Cheers,

Vidy

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Florian Pfeffer
Nov 30, 2016 at 05:44 AM
1

Hello Vidy,

have you checked already the Range Partitioning option? With that you can define a date range (interval) to steer which records are part of a partition. As this is a single level partitioning, the column which is used for partitioning must be part of the key. If your column is not part of the key, check if one of the multi-level partitioning range options are appropriate for you (on the second level of that multilevel partitioning options you can use non-key columns).

Regards,
Florian

Share
10 |10000 characters needed characters left characters exceeded
Vidann R Dec 01, 2016 at 07:20 AM
0

Hi Florian,

Thats grt, now i find some air to breathe :)

I have a table in my HANA system that receives close to 250 milions records per day and it could be either insert or Update. Hence, would like to partition my table based on date. Tried the below code but of little help:

ALTERTABLE "TABLE_NAME" PARTITIONBY RANGE (YEAR("someDate") (PARTITION'2015-01-01' <= VALUES < '2016-01-01', PARTITIONS 2',RANGE (DAY("someDate") (PARTITION' 01' <= VALUES < '02',PARTITION' 02' <= VALUES < '03',PARTITION, PARTITION '03' <= VALUES < '04',.......................PARTITION OTHERS);

I would like to add this as part of my HDD table definition!

Cheers,

Vidya

Share
10 |10000 characters needed characters left characters exceeded
Vidann R Dec 12, 2016 at 03:33 PM
0

any inputs :(

Share
10 |10000 characters needed characters left characters exceeded