calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "slim bouguerra (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-2123) Bug in the Druid Filter Translation when Comparing String Ref to a Constant Number
Date Sat, 06 Jan 2018 02:14:00 GMT
slim bouguerra created CALCITE-2123:
---------------------------------------

             Summary: Bug in the Druid Filter Translation when Comparing String Ref to a Constant
Number
                 Key: CALCITE-2123
                 URL: https://issues.apache.org/jira/browse/CALCITE-2123
             Project: Calcite
          Issue Type: Bug
          Components: druid
            Reporter: slim bouguerra
            Assignee: Julian Hyde


The following query {code} SELECT COUNT(*) FROM  \"foodmart\"  WHERE \"product_id\" = 16.0{code}
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.
{code} 
{"type":"bound","dimension":"product_id","lower":"16.0","lowerStrict":false,"upper":"16.0","upperStrict":false,"ordering":"numeric"}
{code}




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message