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

Add APPROX_COUNT_DISTINCT aggregate function

          Details

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

            Description

            Add APPROX_COUNT_DISTINCT aggregate function. The effect of APPROX_COUNT_DISTINCT(args) is the same as COUNT(DISTINCT args) but the planner may generate approximate results (e.g. by using HyperLogLog).

            Note "may" not "must", above: the planner may choose a plan that returns exact results.

            This is a step towards CALCITE-1588, which would allow an APPROXIMATE clause and specify in more detail the degree of approximation allowed.

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. CALCITE-1588 Add SQL syntax to allow approximate LIMIT and distinct-COUNT

                • Major - Major loss of function.
                • Open

                  Activity

                    People

                    • Assignee:
                      julianhyde Julian Hyde
                      Reporter:
                      julianhyde Julian Hyde
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: