How to append rules in a already existing .hdbtextrule file in SAP HANA?

[former_member346555]

Hi ,

I want to add more rules to an existing .hdbtextrule file. Can this be done dynamically through SQL Call ? If so what is the procedure.

[former_member375266]

@Tapishnu Sengupta: I have the same requirement. I need to automate the process of updating the configuration file. Where you able to achieve this using the Stored Procedure? How did you automate the process. Could you please throw some ideas.

[former_member593699]

At least for TEXT MINING purposes it is possible to change the config dynamically in your FULLTEXT INDEX with sql by the parameter

TEXT MINING CONFIGURATION OVERLAY <your parameter with overlaying config>

[former_member210482]

Hello Tapinshu,

SQL is meant for interacting with structured database. Its not possible to edit text files by queries. One possibility will be to exploit the power of nodeJS and XSA. You can create a xsa application that inserts text into the .hdbtextrule file. However, I am not sure about the security risks here.

Cheers,

Safiyu

[eason_chen]

Hi,

As far as I known, there is no sql to append rule into that file. You need to modify hdbtextrule file explained in following guide.

https://help.sap.com/viewer/62e301bb1872437cbb2a8c4209f74a65/2.0.03/en-US/8ac4029795e94aa0afbc8df98f...

Best Regards,
Eason Chen

[former_member346555]

Hi Eason,

Thanks for your reply.

I was wondering whether we can use TEXT_CONFIGURATION_CREATE this procedure call through SQL to update the file.

https://help.sap.com/viewer/62e301bb1872437cbb2a8c4209f74a65/2.0.02/en-US/5c759400d5ce41d2a8158da0db...

Is this possible?

Regards,

Tapishnu