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

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

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.12.0
    • 1.13.0
    • druid-adapter
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment