Can't view system tables due to Unsupported ArrowType Utf8View
- 主要语言
- Java
- 星标
- 94
- 派生
- 152
- 平均合并
- 3 天 16 小时
- 30 天内合并 PR
- 11
描述
### Describe the bug, including details regarding any error messages, version, and platform.
I'm using the latest JDBC 18.3 and I can't open some tables and retrieve column names due to the exception:
```
java.sql.SQLException: Error while executing SQL "SELECT t.*
FROM "system"."distinct_caches" t": Unsupported ArrowType Utf8View
at org.apache.arrow.driver.jdbc.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.arrow.driver.jdbc.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at org.apache.arrow.driver.jdbc.shaded.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164)
at org.apache.arrow.driver.jdbc.shaded.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:218)
in RemoteStatementImpl.execute(RemoteStatementImpl.java:79)
Caused by: java.lang.IllegalArgumentException: Unsupported ArrowType Utf8View
at org.apache.arrow.driver.jdbc.utils.SqlTypes.getSqlTypeIdFromArrowType(SqlTypes.java:163)
at org.apache.arrow.driver.jdbc.utils.ConvertUtils.lambda$convertArrowFieldsToColumnMetaDataList$0(ConvertUtils.java:83)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at java.base/java.util.stream.SliceOps$1$1.accept(SliceOps.java:200)
at java.base/java.util.stream.Stream$1.tryAdvance(Stream.java:1469)
at java.base/java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:129)
at java.base/java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:527)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:513)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682)
at org.apache.arrow.driver.jdbc.utils.ConvertUtils.convertArrowFieldsToColumnMetaDataList(ConvertUtils.java:89)
at org.apache.arrow.driver.jdbc.ArrowFlightMetaImpl.newSignature(ArrowFlightMetaImpl.java:60)
at org.apache.arrow.driver.jdbc.ArrowFlightMetaImpl.prepareForHandle(ArrowFlightMetaImpl.java:175)
at org.apache.arrow.driver.jdbc.ArrowFlightMetaImpl.prepareAndExecute(ArrowFlightMetaImpl.java:209)
at org.apache.arrow.driver.jdbc.shaded.org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677)
at org.apache.arrow.driver.jdbc.shaded.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157)
at org.apache.arrow.driver.jdbc.shaded.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:218)
in RemoteStatementImpl.execute(RemoteStatementImpl.java:79)
... 3 more
```
贡献指南
调研方向
从 stack trace 所示的 SqlTypes.java 中的 getSqlTypeIdFromArrowType() 开始,跟踪 ConvertUtils 如何构建 JDBC 列元数据。针对受影响的系统表重现该查询,然后验证 Utf8View 在没有 SQLException 的情况下能够被处理,并且可以获取列名。
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- java
- 领域
- databases
- Issue 类型
- 缺陷
- 难度
- 3/5
- 预计耗时
- 1-2 天
- 活跃度
- 停滞
- 描述清晰度
- 基本清楚
- 新手友好度
- 35/100