You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/06/26 03:23:04 UTC
[jira] [Created] (DRILL-3383) CTAS Auto Partitioning : We are
adding an additional project to the plan
Rahul Challapalli created DRILL-3383:
----------------------------------------
Summary: CTAS Auto Partitioning : We are adding an additional project to the plan
Key: DRILL-3383
URL: https://issues.apache.org/jira/browse/DRILL-3383
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Reporter: Rahul Challapalli
Assignee: Jinfeng Ni
Fix For: 1.1.0
git.commit.id.abbrev=5a34d81
I used the below query to create a paritioned data set
{code}
create table `lineitem` partition by (l_moddate) as select l.*, l_shipdate - extract(day from l_shipdate) + 1 l_moddate from cp.`tpch/lineitem.parquet` l;
{code}
The plan for the below query has 2 projects instead of 1
{code}
explain plan for select * from `lineitem` where l_moddate = date '1994-07-01';
00-00 Screen
00-01 Project(*=[$0])
00-02 Project(*=[$0])
00-03 Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=/drill/testdata/ctas_auto_partition/tpch_single_partition/lineitem/0_0_31.parquet]], selectionRoot=/drill/testdata/ctas_auto_partition/tpch_single_partition/lineitem, numFiles=1, columns=[`*`]]])
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)