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

Vineet Garg updated HIVE-18872:
-------------------------------
    Fix Version/s:     (was: 3.0.0)
                   3.1.0

Deferring this to 3.1.0 since the branch for 3.0.0 has been cut off. Please 
update the JIRA if you would like to get your patch in 3.0.0.

> Projection is not pushed properly when query involves multiple tables
> ---------------------------------------------------------------------
>
>                 Key: HIVE-18872
>                 URL: https://issues.apache.org/jira/browse/HIVE-18872
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.0.0
>            Reporter: Ankit Singhal
>            Assignee: Ankit Singhal
>            Priority: Major
>             Fix For: 3.1.0
>
>         Attachments: HIVE-18872.patch
>
>
> Projections are not pushed down properly during getSplit() when the query 
> involves multiple tables although they are getting properly pushed during 
> getRecordReader when the task is working on the split. Due to this, storage 
> handler relying on projections for building query while generating input 
> splits are not working.
> here, in below case, due to bug we will be pushing ID2 for both the aliases 
> "A" and "B"  during addSplitsForGroup instead of pushing DB for alias "A" and 
> ID2 only for alias "B".
> SELECT A.ID, a.db, B.ID2 from joinTable3 A join joinTable4 B on A.ID = B.ID 
> WHERE A.ID=10;



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to