[DRILL-726] order by fails when a column has null value

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Chun Chang
• Reporter: Chun Chang
• Created: 13/May/14 23:31
• Updated: 31/Jul/14 06:32
• Resolved: 29/May/14 01:06

Description

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)