Robert Hou created DRILL-5086:
---------------------------------
Summary: ClassCastException when filter pushdown is used with a
bigint or float column.
Key: DRILL-5086
URL: https://issues.apache.org/jira/browse/DRILL-5086
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.9.0
Reporter: Robert Hou
Assignee: Aman Sinha
This query results in a ClassCastException when filter pushdown is used. The
bigint column is being compared with an integer value.
0: jdbc:drill:zk=10.10.100.186:5181/drill/rho> select count(\*) from
orders_parts_metadata where bigint_id < 1100;
Error: SYSTEM ERROR: ClassCastException: java.lang.Integer cannot be cast to
java.lang.Long
A similar problem occurs when a float column is being compared with a double
value.
0: jdbc:drill:zk=10.10.100.186:5181/drill/rho> select count(\*) from
orders_parts_metadata where float_id < 1100.0;
Error: SYSTEM ERROR: ClassCastException
Also when a timestamp column is being compared with a string.
0: jdbc:drill:zk=10.10.100.186:5181/drill/rho> select count(\*) from
orders_parts_metadata where timestamp_id < '2016-10-13';
Error: SYSTEM ERROR: ClassCastException: java.lang.Integer cannot be cast to
java.lang.Long
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
