apache / apache/arrow-java

Can't view system tables due to Unsupported ArrowType Utf8View

未關閉
#807 5 則留言 0 個 reaction 已指派 0 人 在 GitHub 檢視
Type: bug
主要語言
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

把新 issue 寄到你的電子郵件信箱

精選適合新手參與的 GitHub issue 摘要。