Text Analysis In SAP HANA
SAP HANA has introduced some new features like Text Analysis in SPS05 onwards.
With some few steps you can implement Text Analysis in SAP HANA environment.
Following are the steps to implement Text Analysis In SAP HANA.
1.Create a column table <Text Analysis only takes VARCHAR,NVARCHAR,NCLOB,CLOB,BLOB>
CREATE COLUMN TABLE “TEST”.”TEST” (ID NVARCHAR(50), TEXTANA NVARCHAR(5000), PRIMARY KEY(ID))
“TEST”.”TEST”— > SchemaName.TableName
2.Insert some records into Test table
insert into “TEST”.”TEST” values(“1″,”Barely hours after sitting on a hunger strike at the Jantar Mantar in Delhi”)
insert into “TEST”.”TEST” values(“2″,”off-spinner Ravichandran Ashwin admitted that India have been below par in the ODIs against New Zealand and they want to avoid another series defeat when they face the Black Caps in the fourth ODI here Tuesday.”)
insert into “TEST”.”TEST” values(“3″,”Ashwin said the tied match at the Eden Park in Auckland was disappointing.”)
insert into “TEST”.”TEST” values(“4″,”Pune weather is good”)
insert into “TEST”.”TEST” values(“5″,”Bangalore weather is also good”)
3. Create FullText Index “TEST”.”TEST_ANA” On “TEST”.”TEST”(“TEXTANA“)
TEXT ANALYSIS ON
4. Once you will execute the query which is mention in Step 3, SAP HANA will generate the Analysis table in the same schema where your source table reside.
5.You will find another table with the prefix $TA_TEST_ANA which will contain the results. Please check the attachment for result table.
6.This is very important point as you have created the index now If your are inserting some new values into your table that value will be updated into the result<$TA_TEST_ANA> table as well. By this you can apply the Text Analysis on real time data.
Note:For above example I have used SYSTEM as a user in HANA DB(HDB).