[ 
https://issues.apache.org/jira/browse/HIVE-11459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ashutosh Chauhan resolved HIVE-11459.
-------------------------------------
       Resolution: Fixed
         Assignee: Jesus Camacho Rodriguez  (was: Matt McCline)
    Fix Version/s: 2.2.0

Thanks Jesus for verifying.

> 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
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Critical
>             Fix For: 2.2.0
>
>
> {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)

Reply via email to