hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-17955) Issue with the 'like' function in Hive
Date Wed, 01 Nov 2017 04:20:03 GMT

     [ 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)

Mime
View raw message