hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-18872) Projection is not pushed properly when query involves multiple tables
Date Mon, 02 Apr 2018 12:27:00 GMT

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

Mime
View raw message