You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Parth Chandra (JIRA)" <ji...@apache.org> on 2015/06/26 01:37:04 UTC

[jira] [Created] (DRILL-3376) Reading individual files created by CTAS with partition causes an exception

Parth Chandra created DRILL-3376:
------------------------------------

             Summary: Reading individual files created by CTAS with partition causes an exception
                 Key: DRILL-3376
                 URL: https://issues.apache.org/jira/browse/DRILL-3376
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Writer
    Affects Versions: 1.1.0
            Reporter: Parth Chandra
            Assignee: Steven Phillips
             Fix For: 1.1.0


Create a table using CTAS with partitioning:

{code}
create table `lineitem_part` partition by (l_moddate) as select l.*, l_shipdate - extract(day from l_shipdate) + 1 l_moddate from cp.`tpch/lineitem.parquet` l
{code}

Then the following query causes an exception
{code}
select distinct l_moddate from `lineitem_part/0_0_1.parquet` where l_moddate = date '1992-01-01';
{code}


Trace in the log file - 
{panel}
Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 0
    at java.lang.String.charAt(String.java:658) ~[na:1.7.0_65]
    at org.apache.drill.exec.planner.logical.partition.PruneScanRule$PathPartition.<init>(PruneScanRule.java:493) ~[drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
    at org.apache.drill.exec.planner.logical.partition.PruneScanRule.doOnMatch(PruneScanRule.java:385) ~[drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
    at org.apache.drill.exec.planner.logical.partition.PruneScanRule$4.onMatch(PruneScanRule.java:278) ~[drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
    at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:228) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
    ... 13 common frames omitted
{panel}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)