[ https://issues.apache.org/jira/browse/CALCITE-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933704#comment-17933704 ]
Yu Xu commented on CALCITE-6879: -------------------------------- Hi [~asolimando] , I had addressed comments in PR, could you help to review again, thanks~ > Dialect support APPROX_DISTINCT_COUNT for more dialects > ------------------------------------------------------- > > Key: CALCITE-6879 > URL: https://issues.apache.org/jira/browse/CALCITE-6879 > Project: Calcite > Issue Type: Improvement > Components: core > Affects Versions: 1.38.0 > Reporter: Yu Xu > Priority: Major > Labels: pull-request-available > Fix For: 1.39.0 > > > Currently Phoenix/MSS support APPROX_DISTINCT_COUNT syntax and Clickhouse can > archive approx distinct count by UNIQ syntax, need to support it in Calcite > dialect. > Phoenix:[https://phoenix.apache.org/language/functions.html#approx_count_distinct] > MSS:[https://learn.microsoft.com/zh-cn/sql/t-sql/functions/approx-count-distinct-transact-sql] > ClickHouse({*}uniq{*}: Calculates the approximate number of different values > of the argument.): > [https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniq] > -- This message was sent by Atlassian Jira (v8.20.10#820010)