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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Fix Version/s: 1.13.0
• Component/s: druid-adapter
• Assignee: Zain Humayun
• Reporter: Zain Humayun
• Created: 31/May/17 21:57
• Updated: 27/Feb/24 22:23
• Resolved: 19/Jun/17 16:10

Description

The query

SELECT COUNT(DISTINCT "the_month") FROM "foodmart" WHERE "the_month" <> 'October';

Will produce a Druid query with the following filter:

"filter":{
      "type":"not",
      "fields":[
         {
            "type":"selector",
            "dimension":"the_month",
            "value":"October"
         }
      ]
   }

But the expected filter should look like:

"filter":{
      "type":"not",
      "field":{
            "type":"selector",
            "dimension":"the_month",
            "value":"October"
         }
   }

Issue Links

• blocks: CALCITE-1837 Release Calcite 1.13.0