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/

Reply via email to