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)