[GitHub] [pinot] dario-liberman commented on pull request #10867: FUNNEL_COUNT Aggregation Function

["dario-liberman (via GitHub)" <gi...@apache.org>]

dario-liberman commented on PR #10867:
URL: https://github.com/apache/pinot/pull/10867#issuecomment-1581538259

   I am happy to document the function and create a blog post, but I would recommend we first merge it in silently (as experimental lets say), have it there for a bit for folks to try out and then go full out if it looks good, we can probably make a deal out of it similar to how was done with gap fill support.
   
   In terms of other databases:
   - [Doris sequence_match](https://doris.apache.org/docs/dev/sql-manual/sql-functions/aggregate-functions/sequence_match)
   - [Clickhouse sequence_match](https://clickhouse.com/docs/en/sql-reference/aggregate-functions/parametric-functions#sequencematchpatterntimestamp-cond1-cond2-)
   
   Neither of the above however do correlation, the user of these functions has to group by the correlation column and aggregate the results in an outer query in order to get similar results to what is proposed here.


-- 
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-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org