Chun Chang created DRILL-1796:
---------------------------------
Summary: display a map as value caused ExecutionSetupException
Key: DRILL-1796
URL: https://issues.apache.org/jira/browse/DRILL-1796
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Reporter: Chun Chang
#Mon Dec 01 11:15:02 PST 2014
git.commit.id.abbrev=a60e1db
Have a parquet data contains the following:
0: jdbc:drill:schema=dfs.drillTestDir> select t.fields.map[0] from
`data.parquet` as t limit 2;
+------------+
| EXPR$0 |
+------------+
| {"key":"ho_wf2gp","value":{"member2":0}} |
| {"key":"ho_wf2gp","value":{"member2":0}} |
+------------+
The following query displaying 'key' works:
0: jdbc:drill:schema=dfs.drillTestDir> select t.fields.map[0].`key` from
`data.parquet` as t limit 2;
+------------+
| EXPR$0 |
+------------+
| ho_wf2gp |
| ho_wf2gp |
+------------+
But if the field to display is a map, then I get the exception:
0: jdbc:drill:schema=dfs.drillTestDir> select t.fields.map[0].`value` from
`data.parquet` as t limit 2;
Query failed: Query failed: Failure while running fragment., You tried to write
a VarChar type when you are using a ValueWriter of type
NullableVarCharWriterImpl. [ 5494307b-7c11-421e-be49-d0bf043a4ee1 on
qa-node120.qa.lab:31010 ]
[ 5494307b-7c11-421e-be49-d0bf043a4ee1 on qa-node120.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query.
(state=,code=0)
Here is the stack:
12:23:09.249 [2b8331d1-db0c-1150-f58e-7884c00ea314:frag:0:0] WARN
o.a.d.e.w.fragment.FragmentExecutor - Error while initializing or executing
fragment
org.apache.drill.common.exceptions.ExecutionSetupException:
java.lang.IllegalArgumentException: You tried to write a VarChar type when you
are using a ValueWriter of type NullableVarCharWriterImpl.
at
org.apache.drill.exec.store.parquet2.DrillParquetReader.setup(DrillParquetReader.java:252)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ScanBatch.<init>(ScanBatch.java:97)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.store.parquet.ParquetScanBatchCreator.getBatch(ParquetScanBatchCreator.java:147)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.store.parquet.ParquetScanBatchCreator.getBatch(ParquetScanBatchCreator.java:53)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSubScan(AbstractPhysicalVisitor.java:125)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.store.parquet.ParquetRowGroupScan.accept(ParquetRowGroupScan.java:107)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39)
~[drill-java-exec-0.7.0-incubating-SNAPSHOT-rebuffed.jar:0.7.0-incubating-SNAPSHOT]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
