Frantisek Mantlik created HIVE-14185:
----------------------------------------
Summary: Join query fails if the left table is empty and where
condition searches in a list containing null
Key: HIVE-14185
URL: https://issues.apache.org/jira/browse/HIVE-14185
Project: Hive
Issue Type: Bug
Affects Versions: 1.2.1
Reporter: Frantisek Mantlik
If the table on the left hand side of the join is empty and the right hand side
table contains data, the following query fails:
{{SELECT * FROM left JOIN right ON left.col1=right.col1 WHERE left.col2 IN
(null, 'A')}}
while the following query runs without problems:
{{SELECT * FROM left JOIN right ON left.col1=right.col1 WHERE (left.col2 IS
NULL or left.col2 IN ('A'))}}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
