Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
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
-
CALCITE-1588 Add SQL syntax to allow approximate LIMIT and distinct-COUNT
- Open