Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 49A6E187F6 for ; Tue, 7 Jul 2015 17:55:05 +0000 (UTC) Received: (qmail 20011 invoked by uid 500); 7 Jul 2015 17:55:05 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 19910 invoked by uid 500); 7 Jul 2015 17:55:05 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 19738 invoked by uid 99); 7 Jul 2015 17:55:05 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Jul 2015 17:55:05 +0000 Date: Tue, 7 Jul 2015 17:55:05 +0000 (UTC) From: "Jinfeng Ni (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2802: ------------------------------ Attachment: 0002-DRILL-2802-Ensure-project-the-right-columns-in-the-f.patch > 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 > Priority: Critical > Fix For: 1.2.0 > > Attachments: 0002-DRILL-2802-Ensure-project-the-right-columns-in-the-f.patch > > > {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)