[ 
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)

Reply via email to