[ https://issues.apache.org/jira/browse/DRILL-1796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hanifi Gunes resolved DRILL-1796. --------------------------------- Resolution: Fixed Likely that this issue fixed by DRILL-1539 > 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: Execution - Data Types > Reporter: Chun Chang > Assignee: Hanifi Gunes > Fix For: 0.8.0 > > > #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)