[ 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)