[jira] [Commented] (PHOENIX-3390) Custom UDAF for HyperLogLogPlus

["James Taylor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15958147#comment-15958147 ] 

James Taylor commented on PHOENIX-3390:
---------------------------------------

Thanks, [~talktoswapna@gmail.com]! Let's finish this off so we can commit it.
bq. we'd want to make sure that you can include any expression in the arguments, for example, approx_sum(col1/col2 * col3)
When HLL sees it, the expression would have already been evaluated. It's just general SQL syntax that we'd need to support - just make sure you have a test for it - it likely already works. One common use of an expression inside of an aggregate function would be to have a COALESCE call that causes a null value to be treated differently, like this {{APPROX_SUM(COALESCE(col1, 0))}}

> 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
>            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.3.15#6346)