Skip to Content
0

Partitions Merged after altering a table via hdbdd file

May 12, 2017 at 10:24 AM

99

avatar image
Former Member

Hi,

I have created a table using hana HDBDD file. Created HASH and Range Partitions on particular columns of the table. When I try to add any new column to the existing table via HDBDD file, the existing partitions are getting merged. Could you please tell me why it is happening and how to avoid partitions not getting merged.

Thank You,

RP

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

1 Answer

Florian Pfeffer
May 12, 2017 at 07:08 PM
0

During the reactivation of a CDS entity all changes applied to the created table with SQL are lost (aka all things which are not defined in the design-time object are lost). As you are using and HDBDD file in XS Classic, there is not syntax option which you can use to define partitioning information for a CDS entity. So you always have to apply the partitioning logic after you have done changes.

With XS Advanced for CDS entities the new "partition by" option is available as technical configuration. This can be applied in the new HDBCDS files which are the successor of XS Classic HDBDD files. With that option it is possible to define the partitioning rules directly in the CDS file or you are also able to say that an existing partition layout is kept (-> "partition by keeping existing layout"). For details please check the documentaton in the CDS Reference.

Regards,
Florian

Share
10 |10000 characters needed characters left characters exceeded