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.

        Issue Links

          Activity

          Show
          zhumayun Zain Humayun added a comment - PR: https://github.com/apache/calcite/pull/478
          Show
          jcamachorodriguez Jesus Camacho Rodriguez added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/898c2d6 . Thanks Zain Humayun !
          Hide
          zhumayun Zain Humayun added a comment -

          Thanks Jesus Camacho Rodriguez for the quick turnaround!

          Show
          zhumayun Zain Humayun added a comment - Thanks Jesus Camacho Rodriguez for the quick turnaround!
          Hide
          jcamachorodriguez Jesus Camacho Rodriguez added a comment -

          Resolved in release 1.13.0 (2017-06-26).

          Show
          jcamachorodriguez Jesus Camacho Rodriguez added a comment - Resolved in release 1.13.0 (2017-06-26).

            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:

                Development