You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "George Chow (JIRA)" <ji...@apache.org> on 2014/05/12 23:38:15 UTC
[jira] [Commented] (DRILL-653) Group By Query hangs
[ https://issues.apache.org/jira/browse/DRILL-653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13995667#comment-13995667 ]
George Chow commented on DRILL-653:
-----------------------------------
The latest build has changed something. The query now hangs instead of returning an error.
(I took the GROUP BY out to show that the query runs and then added it back.)
{code}
0: jdbc:drill:zk=local> select `emp2`.`date_hire` as `none_date_hire_nk` from `hivestg`.`default`.`emp2` `emp2`;
+-------------------+
| none_date_hire_nk |
+-------------------+
| 13/02/1990 |
| 03/09/1992 |
+-------------------+
2 rows selected (1.004 seconds)
0: jdbc:drill:zk=local> select `emp2`.`date_hire` as `none_date_hire_nk` from `hivestg`.`default`.`emp2` `emp2` group by `emp2`.`date_hire`;
<hangs here>
{code}
> Group By Query hangs
> ---------------------
>
> Key: DRILL-653
> URL: https://issues.apache.org/jira/browse/DRILL-653
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.0.0-milestone-1
> Reporter: Bhallamudi Venkata Siva Kamesh
>
> 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)