[jira] [Created] (HIVE-11459) LEFT SEMI JOIN with SELECT * should not include right-side non-key columns

["Matt McCline (JIRA)" <ji...@apache.org>]

Matt McCline created HIVE-11459:
-----------------------------------

             Summary: LEFT SEMI JOIN with SELECT * should not include right-side non-key columns
                 Key: HIVE-11459
                 URL: https://issues.apache.org/jira/browse/HIVE-11459
             Project: Hive
          Issue Type: Bug
          Components: Hive
            Reporter: Matt McCline
            Priority: Critical




{code}
select * from tmp2 left semi join tmp1 where c1 = id and c0 = q
tmp2.id	tmp2.d	tmp2.q	tmp1.c0	tmp1.d	tmp1.c1
1	^	20134	20134	^	1
3	^	20134	20134	^	3
1	^	20135	20135	^	1
1	^	20138	20138	^	1
2	^	20139	20139	^	2
{code}

tmp1 column "d" is a non-key and should not be included.

The LEFT SEMI JOIN clause is something Hive added.  We ought to define the semantics here

Also see https://issues.apache.org/jira/browse/HIVE-11431.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)