[
https://issues.apache.org/jira/browse/DRILL-726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14011821#comment-14011821
]
Suresh Ollala commented on DRILL-726:
-------------------------------------
Verify after merge for DRILL-847
> order by fails when a column has null value
> -------------------------------------------
>
> Key: DRILL-726
> URL: https://issues.apache.org/jira/browse/DRILL-726
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Chun Chang
> Priority: Blocker
>
> postgres:
> foodmart=# select c_row, c_groupby from data order by c_row;
> c_row | c_groupby
> -------+-----------
> 1 | a
> 2 | ab
> 3 | abc
> 4 |
> 5 |
> 6 | abc
> 7 | ab
> 8 | a
> 9 | a
> 10 | ab
> 11 | abc
> 12 |
> 13 |
> 14 | abc
> 15 | ab
> 16 | a
> 17 | a
> 18 | ab
> 19 | abc
> 20 |
> 21 |
> 22 | abc
> 23 | ab
> (23 rows)
> drill:
> 0: jdbc:drill:schema=dfs> select c_row, c_groupby from data order by c_row;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "8dcb47ec-9c27-4a04-8b48-61e2aad2ad19"
> endpoint {
> address: "qa-node120.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < ClassCastException:[
> org.apache.drill.exec.vector.NullableIntVector cannot be cast to
> org.apache.drill.exec.vector.NullableVarBinaryVector ]"
> ]
> Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
