I am looking how to perform LIKE on text type. I found a way by MATCH.
Is MATCH is Elasticsearch SQL unique function or native SQL? for example: MATCH(foo, 'bar')
Are there more options to perform LIKE on text type?
Is there a way to use MATCH AGAINST syntax?
MATCH (col1 ,
col2 ,...) AGAINST (
QUERY functions are ES SQL specific: Full-Text Search Functions | Elasticsearch Guide [7.16] | Elastic
LIKE only works on "exact" fields (doesn't work on
text). I suggest reading the link above about the two functions, they cover a lot of scenarios and I don't think you need
Will Like works on text when sending the query through ODBC\JDBC?
No. JDBC/ODBC is just an interface. The query engine is the same.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.