[CALCITE-2123] Bug in the Druid Filter Translation when Comparing String Ref to a Constant Number

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: druid-adapter
• Assignee: Unassigned
• Reporter: Slim Bouguerra
• Created: 06/Jan/18 02:13
• Updated: 22/Feb/19 01:20

Description

The following query

 SELECT COUNT(*) FROM  \"foodmart\"  WHERE \"product_id\" = 16.0

Translates to a Druid Table Scan with a String to String Selector comparison filter.
instead we need to have a Bound filter that cast the String to number.
This is what we should expect.

 
{"type":"bound","dimension":"product_id","lower":"16.0","lowerStrict":false,"upper":"16.0","upperStrict":false,"ordering":"numeric"}