Skip to Content
0

HANA TEXT MINING ERROR

May 23, 2017 at 12:06 PM

79

avatar image

Hi,

I have loaded a pdf file into HANA table with python script.

Table structure:

Create Full Text Index SQL

CREATE FULLTEXT INDEX "TXT"."PDF_PARA_FTI" ON "TXT"."T_TA_PDF_PARA" ("FILE_CONTENT")
    FAST PREPROCESS OFF
    SEARCH ONLY OFF
    TEXT ANALYSIS ON
    MIME TYPE 'application/pdf'
    CONFIGURATION 'LINGANALYSIS_FULL'
    ASYNC
    FUZZY SEARCH INDEX ON
    TEXT MINING ON
    TEXT MINING CONFIGURATION 'sap.hana.ta.tm.config::DEFAULT.textminingconfig'
    LANGUAGE DETECTION ('EN') ;

Text Mining SQL:

Error:

Any Idea why the text mining SQL is not working ?

Thanks,

Arijit

c2nkr.png (3.2 kB)
3ksqv.png (9.2 kB)
xvzqq.png (6.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Arijit Das May 25, 2017 at 12:57 PM
0

Following code worked

SELECT 
    RANK,
    TERM,
    TERM_FREQUENCY,
    SCORE 
FROM TM_GET_RELEVANT_TERMS(
                            DOCUMENT IN FULLTEXT INDEX 
                            WHERE PARA_ID >= 0
                            SEARCH "FILE_CONTENT" 
                            FROM "TXT"."T_TA_PDF_PARA"
                            RETURN TOP 20 
                        ) AS T
Share
10 |10000 characters needed characters left characters exceeded