Hi Ratnesh,
Thanks for reporting the issue. Would you be able to create a JIRA ticket with
the same?
I did a quick search and found escape chars being added only in case of direct
SQL [1]
{code}
// The following syntax is required for using LIKE clause wildcards '_'
and '%' as literals.
if (node.operator == Operator.LIKE) {
nodeValue0 = nodeValue0 + " ESCAPE '\\' ";
}
{code}
Also, the syntax in the generated query seems valid [2].
We need to investigate further.
Thanks,
Denys
[1] https://issues.apache.org/jira/browse/HIVE-22900
[2] https://mariadb.com/docs/server/ref/mdb/operators/LIKE/
