Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Jun 28, 2018 at 06:49 AM

    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/8ac4029795e94aa0afbc8df98f93de75.html

    Best Regards,
    Eason Chen

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 28, 2018 at 02:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 23, 2018 at 02:57 PM

    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>

    Add comment
    10|10000 characters needed characters exceeded