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

CONFIGURATION ‘EXTRACTION_CORE’;

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).

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. rahul kumar Post author

    For inserting a record just use the below query I have just removed the “” and put the ”.


    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’)

    (0) 

Leave a Reply