[jira] [Created] (HIVE-20178) LIKE function usage not same as found in 'describe function LIKE;'

["Abhijit Das (JIRA)" <ji...@apache.org>]

Abhijit Das created HIVE-20178:
----------------------------------

             Summary: LIKE function usage not same as found in 'describe function LIKE;'
                 Key: HIVE-20178
                 URL: https://issues.apache.org/jira/browse/HIVE-20178
             Project: Hive
          Issue Type: Bug
          Components: Documentation
            Reporter: Abhijit Das


LIKE function usage is not correctly shown in 'describe function LIKE;'

hive (default)> describe function LIKE;
OK
LIKE(str, pattern) - Checks if str matches pattern
Time taken: 0.033 seconds, Fetched: 1 row(s)

AS PER DESCRIPTION, USAGE DOESN'T WORK:
hive (default)> select LIKE('Hope Jenny has solved the clustering problem by now', '%Jenny%');
FAILED: ParseException line 1:11 cannot recognize input near 'LIKE' '(' ''Hope Jenny has solved the clustering problem by now'' in expression specifica
tion

+CORRECT USAGE SHOULD BE:+
hive (default)> select 'Hope Jenny has solved the clustering problem by now' LIKE '%Jenny%';
OK
true
Time taken: 0.476 seconds, Fetched: 1 row(s)

+PLEASE MODIFY THE DESCRIPTION/DOC AS PER BELOW:+
(str LIKE pattern) - Checks if str matches pattern
Example:
select LIKE('Hope Jenny has solved the clustering problem by now', '%Jenny%');



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)