How to specify a partioning command

[tobias_koebler]

Hi,

you have the need to partition you table that shoud replicated to HANA. No problem with SLT.

There is an additional field (PARTITION_CMD) in table IUUC_REPL_TABSTG (TX: IUUC_REPL_CONTENT) where a partitioning command can be defined for certain tables. The partition command will be added to the create statement of the table on the HANA System.

The partition command has to be entered in the same way as it would be defined in the SQL editor of the HANA studio, for example:

     PARTITION BY HASH (a, b) PARTITIONS 4

SLT will add the partition command when generating the SQL command to create the table. For example:

     CREATE COLUMN TABLE mytab  

          (a INT, b INT, c INT, PRIMARY KEY (a,b)) 

          PARTITION BY HASH (a, b) PARTITIONS 4

Example:

Setting within IUUC_REPL_TABSTG

Result in HANA

Note that instead of the partitioning command, each SQL parameter (e.g. for localization) is possible - but ensure that the syntax is correct - SLT is not checking this.

Best,

Tobias