[
https://issues.apache.org/jira/browse/DRILL-653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13997060#comment-13997060
]
George Chow commented on DRILL-653:
-----------------------------------
I've attached a CSV file and a HQL script.
The HQL script runs against the larger data set (emp.csv) instead of this
shortened version (emp2.csv) so you will need to change the filename inside the
script to use it.
> Group By Query hangs
> ---------------------
>
> Key: DRILL-653
> URL: https://issues.apache.org/jira/browse/DRILL-653
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Affects Versions: 1.0.0-milestone-1
> Reporter: Bhallamudi Venkata Siva Kamesh
> Assignee: Jacques Nadeau
> Attachments: EMP2_Table.csv, load_emp.hql
>
>
> The following query (using hive schema)
> {noformat}
> select c5, max(c3) from drill.table group by c5;
> {noformat}
> hangs and the at the drill bit side, getting the following exception
> {noformat}
> 10:54:47.740 [BitServer-1] ERROR o.a.d.e.w.f.AbstractStatusReporter - Error
> d03a795f-a881-4c90-9d76-ec6a0abb33e6: Failure while parsing fragment
> execution plan.
> com.fasterxml.jackson.databind.JsonMappingException: Can not find a (Map) Key
> deserializer for type [collection type; class java.util.List, contains
> [simple type, class java.lang.String]]
> at
> com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.java:830)
> ~[jackson-databind-2.2.0.jar:2.2.0]
> at
> org.apache.drill.exec.planner.PhysicalPlanReader.readFragmentOperator(PhysicalPlanReader.java:96)
>
> ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.work.batch.ControlHandlerImpl.startNewRemoteFragment(ControlHandlerImpl.java:107)
>
> [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.work.batch.ControlHandlerImpl.handle(ControlHandlerImpl.java:80)
>
> [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.rpc.control.ControlServer.handle(ControlServer.java:56)
> [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.rpc.control.ControlServer.handle(ControlServer.java:34)
> [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:154)
> [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:139)
> [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
