4paradigm / 4paradigm/OpenMLDB
insert statement: codegen insert rows
- 主要言語
- C++
- スター
- 1.7k
- フォーク
- 331
- 平均マージ
- 12日 12時間
- マージ済み PR(30日)
- 1
説明
we only support insert stmt with base type expressions, so
```sql
# 1.
insert into t1 values (1, 2);
# 2
insert to t1 values (1, map(1,"12"), inc(3), [3, 4, 5]);
```
`1` works with legacy solution, but not `2`. Codegen rows support both.
Big work since the complexity for insert statements, as well as the SDK in java and python.
- [ ] native codegen insert rows: consider table default value and parameters
- [ ] Java & Python SDK
- [ ] offline batch
#3723 initiate codegen rows for values that contains map data type only, more work required
コントリビューションガイド
調査の方向性
The issue references #3723 which initiated codegen for map data types. Start by examining the existing codegen infrastructure for INSERT statements, likely in the SQL compiler or execution engine. Review the Java and Python SDKs to understand how they currently handle INSERT. The goal is to extend support to complex expressions like map(), inc(), and arrays in row values, ensuring default values and parameters are considered.
索引モデルが issue の本文から書いたものです。
評価
- 技術スタック
- java, python, sql
- 領域
- backend-api-design, database, machine-learning
- issue の種類
- 機能追加
- 難易度
- 5/5
- 見積もり時間
- 1週間以上
- 活発さ
- 停滞
- 明瞭さ
- おおむね明確
- 初心者へのやさしさ
- 25/100