[
https://issues.apache.org/jira/browse/DRILL-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rahul Challapalli reopened DRILL-3376:
--------------------------------------
I am still hitting this issue
{code}
create table lineitem_delme1 partition by (l_shipdate) as select * from
cp.`tpch/lineitem.parquet`;
+-----------+----------------------------+
| Fragment | Number of records written |
+-----------+----------------------------+
| 0_0 | 60175 |
+-----------+----------------------------+
1 row selected (13.913 seconds)
0: jdbc:drill:zk=10.10.103.60:5181> select
. . . . . . . . . . . . . . . . . > l_returnflag
. . . . . . . . . . . . . . . . . > from
. . . . . . . . . . . . . . . . . >
dfs.`/drill/testdata/lineitem_delme1/0_0_1.parquet`
. . . . . . . . . . . . . . . . . > where
. . . . . . . . . . . . . . . . . > l_shipdate <= date '1998-12-01';
Error: SYSTEM ERROR: StringIndexOutOfBoundsException: String index out of
range: -6
[Error Id: 3f84bb2b-e110-44e7-bdcd-07c4605cabdd on pssc-61.qa.lab:31010]
(state=,code=0)
{code}
> 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)
