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

Push Count distinct into Druid when approximate results are acceptable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.13.0
    • Component/s: druid
    • 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
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: