Skip to Content

HANA TEXT MINING ERROR

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 25, 2017 at 12:57 PM

    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
    Add comment
    10|10000 characters needed characters exceeded