We have created a base view to an Elasticsearch data source which has a field named "logmessage" with a datatype of "text".
where logmessage like 'something%'
When using the LIKE operator on this "text" field, we receive the error:
QUERY [VIRTUAL] [ERROR]
QUERY [JDBC WRAPPER] [ERROR]
QUERY [JDBC ROUTE] [ERROR] Received exception with message 'Found 1 problem(s)
line 1:362: [t0.logmessage like ?] cannot operate on field of data type [text]: No keyword/multi-field defined exact matches for [logmessage]; define one or use MATCH/QUERY instead'
However columns with datatype 'keyword', the LIKE operator works just fine.
It is my understanding that 'text' datatypes should be searchable, but maybe the JDBC connector or Denodo is treating the 'text' datatype differently.
Anyone have any insight or encountered this before?