Skip to Content

SAP HANA SAP HANA XSA: Need help for creating a collection with .hdbcollection

Hi,

tried to create a collection by the artifact .hdbcollection.

Is there somewhere a sample where I can look for the syntax?

This docu didn't help me.

https://help.sap.com/viewer/4505d0bdaf4948449b7f7379d24d0f0d/2.0.02/en-US/fe16b635277c4aea825c72973f159359.html

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 21 at 11:49 AM

    This works: COLLECTION TABLE "namespace.db::MP"

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 20 at 05:57 PM

    It uses the SQL DDL syntax which is documented here:

    https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/ff13273610a54708bc027c107f2aa49b.html

    But essentially the CREATE COLLECTION <name> is all there is to it. There is no structural definition as it takes on the key value properties of the JSON you insert into it.

    Add comment
    10|10000 characters needed characters exceeded