[
https://issues.apache.org/jira/browse/HIVE-18872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ankit Singhal updated HIVE-18872:
---------------------------------
Description:
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, we will be pushing ID2 for both the aliases "A" and "B" to
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;
was: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.
> 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.0.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, we will be pushing ID2 for both the aliases "A" and "B"
> to 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)
