F-VSD-5

Message

For efficiency reasons virtual schemas support operators LIKE and NOT LIKE only for column SOURCE_REFERENCE.

Mitigation

Please change your query and wrap it in an outer SELECT statement that can use the operator LIKE for other columns as well. Add a high limit (e.g., LIMIT 1E15) to the outer SELECT to prevent the optimizer from pushing the filter down. See also: https://github.com/exasol/virtual-schemas/blob/main/doc/user_guide/faq.md

Source

src/main/java/com/exasol/adapter/document/querypredicate/QueryPredicateToBooleanExpressionConverter.java:86