Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1819

Druid Adapter does not push the boolean operator "<>" as a filter correctly

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.12.0
    • Fix Version/s: 1.13.0
    • Component/s: druid
    • Labels:
      None

      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"
               }
         }
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                zhumayun Zain Humayun
                Reporter:
                zhumayun Zain Humayun
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: