Skip to content

Native distinct counts in ClickHouse dialect #2334

@igorlukanin

Description

@igorlukanin

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    driver:clickhouseIssues related to the ClickHouse drivergood first issueGood for newcomershelp wantedCommunity contributions are welcome.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions