[jira] [Updated] (CALCITE-1819) Druid Adapter does not push the boolean operator "<>" as a filter correctly

["Zain Humayun (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-1819?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zain Humayun updated CALCITE-1819:
----------------------------------
    Summary: Druid Adapter does not push the boolean operator "<>" as a filter correctly   (was: Druid Adapter does not push the boolean "<>" as a filter correctly )

> Druid Adapter does not push the boolean operator "<>" 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)