[ https://issues.apache.org/jira/browse/PHOENIX-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16064282#comment-16064282 ]
Ethan Wang commented on PHOENIX-3390: ------------------------------------- +1 for keeping syntax of PHOENIX-3390 and CALCITE-1588 similar. Thanks [~julianhyde] for the info. It's very reasonable to have {quote}COUNT(DISTINCT customerId) APPROXIMATE (WITHIN 10 PERCENT) {quote} rather than a dedicated {quote}APPROX_COUNT(){quote} Since the approximation argument should be per query, rather than per projection. Currently, it seems to me CALCITE-1588 has not started yet, it will be reasonable for both PHOENIX-3390 and CALCITE-1588 to follow this purposed design going forward. > Custom UDAF for HyperLogLogPlus > ------------------------------- > > Key: PHOENIX-3390 > URL: https://issues.apache.org/jira/browse/PHOENIX-3390 > Project: Phoenix > Issue Type: New Feature > Reporter: Swapna Kasula > Assignee: Ethan Wang > Priority: Minor > > With ref # PHOENIX-2069 > Custome UDAF to aggregate/union of Hyperloglog's of a column and returns a > Hyperloglog. > select hllUnion(col1) from table; //returns a Hyperloglog, which is the > union of all hyperloglog's from all rows for column 'col1' -- This message was sent by Atlassian JIRA (v6.4.14#64029)