[DRILL-5086] ClassCastException when filter pushdown is used with a bigint or float column and metadata caching.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.10.0
• Component/s: Query Planning & Optimization
• Labels: ready-to-commit
• Assignee: Parth Chandra
• Reporter: Robert Hou
• Reviewer: Robert Hou
• Created: 30/Nov/16 20:01
• Updated: 22/Mar/17 00:52
• Resolved: 06/Dec/16 16:39

Description

This query results in a ClassCastException when filter pushdown is used with metadata caching. 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

To reproduce the problem, put the attached files into a directory. Then create the metadata:

refresh table metadata dfs.`path_to_directory`;

For example, if you put the files in /drill/testdata/filter/orders_parts_metadata, then run this sql command

refresh table metadata dfs.`/drill/testdata/filter/orders_parts_metadata`;

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

Issue Links

• links to: GitHub Pull Request #674