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/