drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-3376) Reading individual files created by CTAS with partition causes an exception
Date Tue, 15 Dec 2015 23:17:46 GMT

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

Rahul Challapalli closed DRILL-3376.
------------------------------------

Verified and added a testcase

> 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)

Mime
View raw message