3261157 - SQL Error (column function) with virtual data access

While running an SQL on a virtual table you got the following error (Virtual tables represent the tables in the remote data source) :

SAP DBTech JDBC: [7]: feature not supported: CONTAINS predicates on non-column table/view "table_name"

This SQL was executed on the remote table via a View and a SQL Tool connected via ODBC:

SELECT * FROM <table_name>WHERE
CONTAINS(<column_name>, 'something', FUZZY(1))

SAP HANA , platform edition

SAP HANA, platform edition all versions

virtual table, CONTAINS, fuzzy, not supported, SQL, , KBA , HAN-DB-ENG-TXT , SAP HANA Text Engine , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Visit SAP Support Portal's SAP Notes and KBA Search.