4paradigm / 4paradigm/OpenMLDB

support function: current_timestamp, current_date, now

未关闭
#3,198 0 条评论 0 个 reaction 已指派 1 人 已被 @aceforeverd 认领 在 GitHub 查看
enhancement execute-engine udf
主要语言
C++
星标
1.7k
派生
331
平均合并
12 天 12 小时
30 天内合并 PR
1

描述

same functions in Spark SQL.

1. There is `unix_timestamp("")` as a temp solution, not convenient though. unix_timestamp returns unix epouch time in seconds as int64, one must write `timestamp (unix_timestamp("") * 1000)` to archive current_timestamp.
2. all `current_*` function should executed at begining of one SQL, means all `current_*` functions calls in same SQL should guarantee return the same value, no matter where the `current_*` call is.

贡献指南

打开贡献指南

调研方向

Look for existing timestamp functions like `unix_timestamp` in the SQL function implementation. The new functions `current_timestamp`, `current_date`, and `now` need to be added, ensuring they return the same value for all calls within a single SQL statement. Check how query execution context is managed to guarantee consistency. Test by writing SQL queries that call these functions multiple times.

由索引模型根据 Issue 内容生成。

评估

技术栈
cpp, sql
领域
backend, database
Issue 类型
功能
难度
3/5
预计耗时
1-2 天
活跃度
停滞
描述清晰度
基本清楚
新手友好度
45/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。