Is your feature request related to a problem? Please describe.
ClickHouse supports a number of functions to count distinct values: uniq, uniqExact, uniqHLL12. However, they are not used in ClickHouseQuery adapter to support countDistinctApprox and other types of aggregations.
Describe the solution you'd like
With the guidance of the Cube.js team and taking other adapters as examples, these functions should be used in the adapter.
Describe alternatives you've considered
—
Additional context
Without this feature, countDistinctApprox is not supported at all, and — I think — countDistinct works slower than it could.
Is your feature request related to a problem? Please describe.
ClickHouse supports a number of functions to count distinct values: uniq, uniqExact, uniqHLL12. However, they are not used in ClickHouseQuery adapter to support
countDistinctApproxand other types of aggregations.Describe the solution you'd like
With the guidance of the Cube.js team and taking other adapters as examples, these functions should be used in the adapter.
Describe alternatives you've considered
—
Additional context
Without this feature,
countDistinctApproxis not supported at all, and — I think —countDistinctworks slower than it could.