Create full text index with .hdbtable file.

[former_member557119]

I got the reference on the below link that it was not allowed in SPS07

https://archive.sap.com/discussions/thread/3505502.

We are on HANA 1.00.122.17 SPS12. Can we create the full text index with .hdbtable syntax in this version? How would we create it?

[former_member557119]

Hello,

Thank you for your reply.

Our requirement is to add it to normal hana table. we are able to create it using below syntax.

CREATE FULLTEXT INDEX <index-name> ON <table> (<column>) <options>

However, we want to create it using .hdbtable JSON syntax.

Any help is appreciated.

Regards,

Mamta

[pfefferf]

Again, as said, this is not possible with the hdbtable syntax. Options are already listed in the answers.

[pfefferf]

With XS Classic (which is what you use I think), it is not possible (check XS Classic .hdbtable). You have to create the persistency model by CDS or create the full-text index via pure SQL, which I would not recommend because of transport/deployment reasons (always a manual task).

In XS Advanced (check XS Advanced .hdbtable) it is also not possible directly. But you can define the full-text index via a .hdbfulltextindex object (or CDS if you create - as recommended - your persistency model via CDS).

Regards,
Florian

[thomas_jung]

If you are using HDI and the SAP Web IDE for SAP HANA (available since HANA 1.0 SPS 11), then there is an artifact called hdbfulltextindex: https://github.com/SAP/com.sap.openSAP.hana5.example/blob/hana2_sps03_2/core_db/src/data/MasterData/...