You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@beam.apache.org by "Brachi Packter (Jira)" <ji...@apache.org> on 2022/01/12 10:22:00 UTC
[jira] [Commented] (BEAM-12393) Beam SQL support for HLL count
[ https://issues.apache.org/jira/browse/BEAM-12393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17474427#comment-17474427 ]
Brachi Packter commented on BEAM-12393:
---------------------------------------
[~kenn][~ibzib] yes, this is resolved, I'll update the ticket
> Beam SQL support for HLL count
> ------------------------------
>
> Key: BEAM-12393
> URL: https://issues.apache.org/jira/browse/BEAM-12393
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql, extensions-java-sketching
> Reporter: Brachi Packter
> Priority: P3
> Time Spent: 1h
> Remaining Estimate: 0h
>
> There is support for HLL sketch in Ptransform:
>
> {code:java}
> p.apply("Int", Create.of(ints)).apply("IntHLL", ApproximateCountDistinct.globally()
> .withPercision(PRECISION));{code}
>
> or
>
> {code:java}
> PCollection<KV<Integer, Long>> result =
> p.apply("Long", Create.of(longs)).apply("LongHLL", ApproximateCountDistinct.perKey());
>
> {code}
> But, no support for beam sql.
> We can't initiate it to be used in SqlTransform (even the combiner: HllCountMergePartialFn exists)
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)