drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hanifi Gunes (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1309) Projected columns are not pushed into scan
Date Fri, 29 Aug 2014 01:51:08 GMT

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

Hanifi Gunes updated DRILL-1309:
--------------------------------

    Assignee: DrillCommitter  (was: Hanifi Gunes)

> Projected columns are not pushed into scan 
> -------------------------------------------
>
>                 Key: DRILL-1309
>                 URL: https://issues.apache.org/jira/browse/DRILL-1309
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Mehant Baid
>            Assignee: DrillCommitter
>             Fix For: 0.5.0
>
>         Attachments: DRILL-1309.1.patch.txt
>
>
> While performing the following query on two text files, the projected column does not
get pushed into the scan.
> explain plan for select t1.columns[1] from dfs.`/tmp/t1.csv` t1, dfs.`/tmp/t2.csv` t2
where t1.columns[0] = t2.columns[0]; 
> 00-00    Screen
> 00-01      Project(EXPR$0=[ITEM($0, 1)])
> 00-02        HashJoin(condition=[=($1, $2)], joinType=[inner])
> 00-04          Project(columns=[$0], $f2=[ITEM($0, 0)])
> 00-06            Scan(groupscan=[EasyGroupScan [selectionRoot=/tmp/t1.csv, columns =
[SchemaPath [`columns`], SchemaPath [`columns`[0]]]]])
> 00-03          Project($f20=[$0])
> 00-05            Project($f2=[ITEM($0, 0)])
> 00-07              Scan(groupscan=[EasyGroupScan [selectionRoot=/tmp/t2.csv, columns
= [SchemaPath [`columns`[0]]]]])
> In the above plan (00-06) we see that the scan contains the following column projections
pushed into scan: 'columns' and 'columns[0]'. 
> We should not push 'columns' into the scan, instead push 'columns[1]' which is the projected
column into the scan. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message