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

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

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)