Consume COLUMN_DEF in JDBC Flight Driver
- 主要语言
- Java
- 星标
- 94
- 派生
- 152
- 平均合并
- 3 天 16 小时
- 30 天内合并 PR
- 11
描述
### Describe the enhancement requested
`ArrowDatabaseMetadata`'s schema currently defines a vector for `COLUMN_DEF`, yet never writes any value to it. `FlightSQLColumnMetadata` also does not have a constant/getter/setter for this value.
Due to this, database connections through java's arrow-flight cannot and will not show underlying default value metadata per column. DESCRIBE TABLE or similar calls (engine depending) can still be used to get a column's default value, but it can be at odds with what the client shows.
I confirmed this behavior using Dremio as the query engine, dBeaver as the client, and iceberg as the table containing a column with a default value.
DBeaver and other DB clients should accurately show column default values when calling DatabaseMetaData.getColumns() public method. Clients will need to send this information, and the arrow driver needs to consume this information.
贡献指南
调研方向
从 ArrowDatabaseMetadata 的 COLUMN_DEF 向量和 FlightSQLColumnMetadata 开始,然后跟踪列元数据如何传递到 DatabaseMetaData.getColumns()。确保列默认值被传递并对 DBeaver 等客户端可见,以确认完成。
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- java
- 领域
- api, database
- Issue 类型
- 功能
- 难度
- 4/5
- 预计耗时
- 3-5 天
- 活跃度
- 冷清
- 描述清晰度
- 基本清楚
- 新手友好度
- 52/100