[
https://issues.apache.org/jira/browse/HIVE-17955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gopal V resolved HIVE-17955.
----------------------------
Resolution: Not A Problem
LIKE isn't instr, it uses LIKE patterns.
https://www.w3schools.com/sql/sql_like.asp
> Issue with the 'like' function in Hive
> --------------------------------------
>
> Key: HIVE-17955
> URL: https://issues.apache.org/jira/browse/HIVE-17955
> Project: Hive
> Issue Type: Bug
> Reporter: Vishal Jaiswal
>
> The following command should not fail as per the documentation:
> select like("Vishal Jaiswal", "Jaiswal");
> Command: describe function like;
> Result: like(str, pattern) - Checks if str matches pattern
> Command: select like("Vishal Jaiswal", "Jaiswal");
> Result: Query fails in Hive.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
