SAP HANA: sql syntax error while executing text mining function

Question

I am trying to execute the Text Mining function TM_GET_RELEVANT_DOCUMENTS in SQL in SAP HANA. But getting an error:

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "crash": line 3 col 6 (at pos 164)

The SQL statement should be correct as I have used an example from official SAP HANA documentation. What could be the reason for this problem?

The SQL statement is:

select t.rank, t.total_term_count, t.score 
  from tm_get_relevant_documents (
  term 'crash'
  language 'english'
  search distinct "ta_token" 
  from "xxx"."xxx"
  return
  top 20 
  rank, term_count
) as t where t.score > 0.25 and t.total_term_count > 2;

Jota · Accepted Answer · 2016-10-26 04:50:53Z

1

It's possible that the reason is because you are using SPS09 or something earlier than that.

If you have anything less than SPS10, you can't access the SQL text mining functionality. It wasn't introduced until SPS10. In SPS09, you can access text mining functionality by way of the SAP HANA XS API.

answered Oct 26, 2016 at 4:50

Jota

17.6k7 gold badges67 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SAP HANA: sql syntax error while executing text mining function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related