Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
3.1.2
-
None
-
None
Description
How to reproduce:
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 ;
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