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

Push Count distinct into Druid when approximate results are acceptable

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

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

      Description

      Currently queries such as

      select count(distinct "dimension") from "table";
      

      are not pushed into Druid using the cardinality aggregator because it produces an approximate result. There exists a JDBC string parameter called approximateDistinctCount introduced in CALCITE-1587 that lets the user specify whether approximate results are acceptable in count distinct queries, however this parameter is not currently utilized by the Druid adapter.

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              zhumayun Zain Humayun
              Reporter:
              zhumayun Zain Humayun

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment