hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frantisek Mantlik (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-14185) Join query fails if the left table is empty and where condition searches in a list containing null
Date Thu, 07 Jul 2016 14:28:11 GMT
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)

Mime
View raw message