You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/04/16 19:27:58 UTC
[jira] [Updated] (DRILL-2802) Projecting dir[n] by itself results
in projecting of all columns
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Barclay (Drill) updated DRILL-2802:
------------------------------------------
Summary: Projecting dir[n] by itself results in projecting of all columns (was: Projecting dir[n] by itself, results in projecting of all columns)
> Projecting dir[n] by itself results in projecting of all columns
> ----------------------------------------------------------------
>
> Key: DRILL-2802
> URL: https://issues.apache.org/jira/browse/DRILL-2802
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 0.9.0
> Reporter: Victoria Markman
> Assignee: Jinfeng Ni
>
> {code}
> 0: jdbc:drill:schema=dfs> select dir1 from bigtable limit 1;
> +------------+------------+------------+------------+
> | a1 | b1 | c1 | dir1 |
> +------------+------------+------------+------------+
> | 1 | aaaaa | 2015-01-01 | 01 |
> +------------+------------+------------+------------+
> 1 row selected (0.189 seconds)
> 0: jdbc:drill:schema=dfs> select dir0 from bigtable limit 1;
> +------------+------------+------------+------------+
> | a1 | b1 | c1 | dir0 |
> +------------+------------+------------+------------+
> | 1 | aaaaa | 2015-01-01 | 2015 |
> +------------+------------+------------+------------+
> 1 row selected (0.193 seconds)
> {code}
> In explain plan, I don't see project:
> {code}
> 0: jdbc:drill:schema=dfs> explain plan for select dir0 from bigtable;
> +------------+------------+
> | text | json |
> +------------+------------+
> | 00-00 Screen
> 00-01 Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=maprfs:/test/bigtable/2015/01/4_0_0.parquet], ReadEntryWithPath [path=maprfs:/test/bigtable/2015/01/3_0_0.parquet], ReadEntryWithPath [path=maprfs:/test/bigtable/2015/01/5_0_0.parquet], ReadEntryWithPath [path=maprfs:/test/bigtable/2015/01/1_0_0.parquet], ReadEntryWithPath [path=maprfs:/test/bigtable/2015/01/2_0_0.parquet], ReadEntryWithPath [path=maprfs:/test/bigtable/2015/01/0_0_0.parquet], ReadEntryWithPath [path=maprfs:/test/bigtable/2015/02/0_0_0.parquet], ReadEntryWithPath [path=maprfs:/test/bigtable/2015/03/0_0_0.parquet], ReadEntryWithPath [path=maprfs:/test/bigtable/2015/04/0_0_0.parquet], ReadEntryWithPath [path=maprfs:/test/bigtable/2016/01/parquet.file], ReadEntryWithPath [path=maprfs:/test/bigtable/2016/parquet.file]], selectionRoot=/test/bigtable, numFiles=11, columns=[`dir0`]]])
> {code}
> If you project both dir0 and dir1, both columns are projected with the correct result:
> {code}
> 0: jdbc:drill:schema=dfs> select dir0, dir1 from bigtable;
> +------------+------------+
> | dir0 | dir1 |
> +------------+------------+
> | 2015 | 01 |
> | 2015 | 01 |
> | 2015 | 01 |
> | 2015 | 01 |
> | 2015 | 01 |
> | 2015 | 01 |
> | 2015 | 01 |
> | 2015 | 01 |
> | 2015 | 01 |
> {code}
> {code}
> [Wed Apr 15 14:09:47 root@/mapr/vmarkman.cluster.com/test/bigtable ] # ls -R
> .:
> 2015 2016
> ./2015:
> 01 02 03 04
> ./2015/01:
> 0_0_0.parquet 1_0_0.parquet 2_0_0.parquet 3_0_0.parquet 4_0_0.parquet 5_0_0.parquet
> ./2015/02:
> 0_0_0.parquet
> ./2015/03:
> 0_0_0.parquet
> ./2015/04:
> 0_0_0.parquet
> ./2016:
> 01 parquet.file
> ./2016/01:
> parquet.file
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)