confluentinc/ksql

Add an array_positions function.

Open

#9,158 建立於 2022年6月1日

在 GitHub 查看
 (0 留言) (0 反應) (0 負責人)Java (5,739 star) (1,048 fork)batch import
enhancementfix-it-weekgood first issuestreaming-engineuser-defined-functions

描述

Is your feature request related to a problem? Please describe. The existing FIELD function works on a varags array of input strings. It does not work on an array of strings.

E.g.

+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|KSQL_COL_0                                                                                                                                                                 |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|0                                                                                                                                                                          |

Describe the solution you'd like In the above example, it'd be nice to return 1 or better an array of the positions where the element is present in the array.

See array_positions from https://www.postgresql.org/docs/current/functions-array.html.

Additional context See a short Slack discussion here: https://confluentcommunity.slack.com/archives/C6UJNMY67/p1654021013224899

貢獻者指南

技術棧
javasql
領域
database
議題類型
feature
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
3
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
half day
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
fresh
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
mostly clear
前置要求
Javaksql codebaseSQL array functions
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
60
研究方向
Examine the existing FIELD function implementation in ksql (likely in the function registry). Understand the current varargs approach and how to extend it to handle array inputs. Reference PostgreSQL's array positions documentation for expected behavior. Consider returning an array of positions instead of a single index. Look for similar array functions already implemented in the codebase to follow patterns.