SAP Knowledge Base Article - Public

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


The CONTAINS predicate cannot be used for virtual tables, and say there’s no way to translate the CONTAINS predicate in HANA-remote systems.  

As the error message indicates there is no scenario in which it can be used.


Unfortunately, in case of virtual tables we have no option for CONTAINS to be used, it is not supported.

At every other tables you can use the CONTAINS, it is working like generally.

You can check it how it works on the following:

SAP Help Portal - The CONTAINS() Predicate

SAP Help Portal - CONTAINS Predicate

See Also

SAP Help Portal - Search Queries with CONTAINS


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


SAP Datasphere all versions