dario-liberman opened a new pull request, #11092: URL: https://github.com/apache/pinot/pull/11092
PR for https://github.com/apache/pinot/issues/10866 This PR adds the remaining funnel count aggregation strategies documented in [docs](https://github.com/dario-liberman/pinot-docs/blob/7a23268ff0cc8f9636668b09cf85519fef8a4fd2/configuration-reference/functions/funnelcount.md). In particular, introduces strategies that do not require or make assumptions regarding partitioning configuration: - _theta-sketch_ - _bitmap_ - _set_ These have the same characteristics as the respective distinct count aggregation functions: - [DISTINCTCOUNTTHETASKETCH](https://docs.pinot.apache.org/configuration-reference/functions/distinctcountthetasketch) - [DISTINCTCOUNTBITMAP](https://docs.pinot.apache.org/configuration-reference/functions/distinctcountbitmap) - [DISTINCTCOUNT](https://docs.pinot.apache.org/configuration-reference/functions/distinctcount) These complement the already present aggregation strategies: - _partitioned_ - _partitioned, sorted_ The first corresponding to [SEGMENTPARTITIONEDDISTINCTCOUNT](https://docs.pinot.apache.org/configuration-reference/functions/segmentpartitioneddistinctcount). The latter has no equivalent (tho GAPFILL has a somewhat similar aggregation optimisation for sorted rows). In order to select the strategy, the user just needs to indicate the desired strategy as a setting parameter, as documented in the link above, for example: ``` select FUNNEL_COUNT( STEPS( url = '/cart/add', url = '/checkout/start', url = '/checkout/confirmation'), CORRELATE_BY(user_id), SETTINGS('theta_sketch', 'nominalEntries=4096') ) AS counts from user_log ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
