How to perform Text Analysis for a particular record in a table in HANA ??

[former_member462348]

Hi Experts,

I have the below requirement to perform the text analysis for a particular records in a table and not for the whole table as the table is really huge.

Example:

ID TEXT
1 Am living in India
2 SAP HANA is an In-Memory Technology
3 I love working in SAP

I want to perform the Sentiment analysis only for the 1st and 3rd record, or how to perform text analysis on a table based on certain condition.

Thanks
Rufus Samuel

[former_member462348 · Accepted solution]

HI All,

Its not possible to active the text analysis for the particular records of the table. When creating the Index for a table, the column which we are choosing is completely indexed based on the configuration which we define in the code and always the memory will be huge after the index operation.

Later we can use the Index table in table Function/Procedure based on our requirement.

Thanks
Rufus

[SergioG_TX]

Hi Rufus,

doing text analysis requires more than just a simple answer. there may be configurations you need to do on your table such as indexes, or even call functions to perform a desired output. instead of giving you a "here is the answer" because i do not think there will be one single answer for your question, let me point you into a better area that you may need to explore:

https://help.sap.com/viewer/62e301bb1872437cbb2a8c4209f74a65/2.0.01/en-US/31b772b1530349a5bf32ec345f...

hope this helps

[former_member462348]

Hi Sergio,

Thanks for your link. But the scenario which am actually looking i could not find it in this link.

if you are already come across same cases can you please share the code so that will do it in the same way.

Thanks
Rufus Samuel