[jira] [Created] (DRILL-726) order by fails when a column has null value

["Chun Chang (JIRA)" <ji...@apache.org>]

Chun Chang created DRILL-726:
--------------------------------

             Summary: 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


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)