[ https://issues.apache.org/jira/browse/HIVE-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13152509#comment-13152509 ]
Carl Steinbach commented on HIVE-2594: -------------------------------------- UDFLike does not correctly handle patterns where an escaped '\' precedes '%': {noformat} % cat /home/carl/Work/repos/hive-test/data/files/pattern/* aaaaaa aaa\bbb aaa\\ccc aaa\\\ddd aaa%aaa % hive hive> CREATE TABLE test (a STRING) STORED AS TEXTFILE LOCATION '/home/carl/Work/repos/hive-test/data/files/pattern'; OK hive> SELECT * FROM test; OK aaaaaa aaa\bbb aaa\\ccc aaa\\\ddd aaa%aaa hive> SELECT * FROM test WHERE a LIKE 'aaa%'; -- Should match everything. WORKS! OK aaaaaa aaa\bbb aaa\\ccc aaa\\\ddd aaa%aaa hive> SELECT * from test WHERE a LIKE 'aaa\%%'; -- Should match 'aaa%aaa'. WORKS! OK aaa%aaa hive> SELECT * FROM test WHERE a LIKE 'aaa\\%'; -- Should match 'aaa\bbb', 'aaa\\ccc', and 'aaa\\\ddd'. FAILURE! OK hive> SELECT * FROM test WHERE a LIKE 'aaa\\b%'; -- Should match 'aaa\bbb'. Works! OK aaa\bbb hive> quit; {noformat} > UDF LIKE can't handle literal '\' before '%' > -------------------------------------------- > > Key: HIVE-2594 > URL: https://issues.apache.org/jira/browse/HIVE-2594 > Project: Hive > Issue Type: Bug > Components: UDF > Affects Versions: 0.8.0 > Reporter: Carl Steinbach > -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira