[jira] [Commented] (HIVE-2594) UDF LIKE can't handle literal '\' before '%'

["Carl Steinbach (Commented) (JIRA)" <ji...@apache.org>]

    [ 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