-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.15.0
-
Component/s: None
-
Labels:None
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.
- relates to
-
CALCITE-1588 Add SQL syntax to allow approximate LIMIT and distinct-COUNT
-
- Open
-