Can we define partitioned table in .hdbtable script?

[former_member215819]

Hi All,

Can we define partitioned (eg.hash) table in .hdbtable script?

When we create table using sql statement - eg: CREATE COLUMN TABLE mytab (a INT, b INT, c INT, PRIMARY KEY (a,b)) PARTITION BY HASH (a, b) PARTITIONS 4

Thanks!

Regards

Vidya Nair

[former_member182302 · Accepted solution]

Hi Vidya,

As Thomas mentions we do not have support for the syntax.

But i tried adding a partition to a hdbtable i created as shown below:

DemoTable.hdbtable

Adding partition through sql syntax:

Table showing partition now:

Regards,

Krishna Tangudu

[thomas_jung · Accepted solution]

Sure you can add it manually with SQL after the fact. Just know that this change doesn't transport and would have to be repeated in any subsequent system imports.

[former_member182302 · Accepted solution]

Yes, thomas.. Thanks for mentioning the point.

Regards,

Krishna Tangudu

[former_member215819 · Accepted solution]

Thanks for your quick responses!

Krishna  -yes am aware that we can do it post table creation. But as Thomas highlighted this would be an activity to be done in individual systems. Hence was trying to find a way in .hdbtable script.

[former_member212487 · Accepted solution]

Hi Thomas et.al

I'm using  'SAP HANA Database 1.00 SP8 (Revision 80)   +  HANA SAP HANA studio Version: 1.80.3

1. Is there a hook to run a bunch of SQL-s statements after an import on target HANA without user in the loop ?

2. is HDBDD supported in my configuration ?

3. is HDBDD format different than HDBTABLE meaning I'll need to rewrite my schema from scratch (again) in another format ?

[Former Member · Accepted solution]

Hi Thomas/Krishna,

Regarding transporter issue for partitioning sql scripts. We can create a procedure as a content objects and execute all partitioning scripts as dynamic sql as part of that procedure. Procedure can be migrated using transporter and this will also help us to maintain version control for partitioning scripts.

let me know your feedback on this approach.

Thanks,

PB

[thomas_jung]

No. Many of the advanced SQL Syntax (Full Text Index, Partitions, etc) aren't supported yet by HDBTABLE or HDBDD. We have plans to fill those SQL gaps in the future in HDBDD objects.

[former_member182302]

Hi Thomas,

Can you help us know the what is the road map for HDBTABLE and HDBDD.

We are planning to develop the tables using HDBDD or HDBTABLE. So would like to know if the missing advanced SQL Features will be implemented only in HDBDD or both? And if there are any further limitations in using HDBDD?

Regards,

Krishna Tangudu

[thomas_jung]

These enhancements will only be done to HDBDD. No further enhancements are planned for HDBTABLE.