Zain Humayun created CALCITE-1819: ------------------------------------- Summary: Druid Adapter does not push the boolean "<>" as a filter correctly Key: CALCITE-1819 URL: https://issues.apache.org/jira/browse/CALCITE-1819 Project: Calcite Issue Type: Bug Components: druid Affects Versions: 1.12.0 Reporter: Zain Humayun Assignee: Zain Humayun
The query {code:sql} SELECT COUNT(DISTINCT "the_month") FROM "foodmart" WHERE "the_month" <> 'October'; {code} Will produce a Druid query with the following filter: {code:javascript} "filter":{ "type":"not", "fields":[ { "type":"selector", "dimension":"the_month", "value":"October" } ] } {code} But the expected filter should look like: {code:javascript} "filter":{ "type":"not", "field":{ "type":"selector", "dimension":"the_month", "value":"October" } } {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)