[
https://issues.apache.org/jira/browse/HIVE-18872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis updated HIVE-18872:
---------------------------------------
Fix Version/s: (was: 3.2.0)
I cleared the fixVersion field since this ticket is not resolved. Please review
this ticket and if the fix is already committed to a specific version please
set the version accordingly and mark the ticket as RESOLVED.
According to the JIRA guidelines
(https://cwiki.apache.org/confluence/display/Hive/HowToContribute) the
fixVersion should be set only when the issue is resolved/closed.
> 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
> 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
(v8.20.10#820010)
