confluentinc/ksql

Array size function / Rank

Open

#2,579 创建于 2019年3月19日

在 GitHub 查看
 (3 评论) (0 反应) (0 负责人)Java (1,048 fork)batch import
help wanteduser-defined-functions

仓库指标

Star
 (5,739 star)
PR 合并指标
 (平均合并 4天 20小时) (30 天内合并 6 个 PR)

描述

Hi, I've noticed that there is no RANK() or DENSE_RANK() function in KSQL. I tried to work around this by calling TOPKDISTINCT(col, static_int) and then returning the size of the array given by TOPKDISTINCT(), all within my relevant group by. Is there any workaround for this? I am not well versed in Java/Scala, so I could try writing this as a UDF, but I would prefer is there was a native solution for this. Cheers!

贡献者指南