You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Yuming Wang (Jira)" <ji...@apache.org> on 2020/02/06 12:36:00 UTC

[jira] [Created] (HIVE-22838) like any is incorrect if contains null

Yuming Wang created HIVE-22838:
----------------------------------

             Summary: like any is incorrect if contains null
                 Key: HIVE-22838
                 URL: https://issues.apache.org/jira/browse/HIVE-22838
             Project: Hive
          Issue Type: Bug
          Components: Query Planning
    Affects Versions: 3.1.2
            Reporter: Yuming Wang


How to reproduce:

{code:sql}
CREATE TABLE like_any_table
STORED AS TEXTFILE
AS
SELECT "google" as company,"%oo%" as pat
UNION ALL
SELECT "facebook" as company,"%oo%" as pat
UNION ALL
SELECT "linkedin" as company,"%in" as pat
;
{code}


{noformat}
hive> select company from like_any_table where company like any ('%oo%',null);
OK
Time taken: 0.064 seconds
hive> select company from like_any_table where company like '%oo%'  or company like null;
OK
google
facebook
{noformat}





--
This message was sent by Atlassian Jira
(v8.3.4#803005)