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)