paimon catalog 查询出错

💬 StarRocks 用户问答 功能使用相关
#1

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
【背景】做过哪些操作？表结构.txt (2.8 KB)
【业务影响】无法查看表数据
【是否存算分离】是
【StarRocks版本】例如：3.3.9
【集群规模】例如：3fe+2cn
表结构和测试数据见附件，下述报错问题必现。

  • 外表查询报错
    org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [1064] [42000]: Failed to call the nextChunkOffHeap method of off-heap table scanner. java exception details: java.io.IOException: Failed to get the next off-heap table chunk of paimon.
    at com.starrocks.paimon.reader.PaimonSplitScanner.getNext(PaimonSplitScanner.java:163)
    at com.starrocks.jni.connector.ConnectorScanner.getNextOffHeapChunk(ConnectorScanner.java:101)
    Caused by: java.lang.NumberFormatException: For input string: “name”
    at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.base/java.lang.Long.parseLong(Long.java:692)
    at java.base/java.lang.Long.parseLong(Long.java:817)
    at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction$SequenceGenerator$SequenceGeneratorVisitor.lambda$stringGenerator$0(PartialUpdateMergeFunction.java:468)
    at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction$SequenceGenerator$Generator.generateNullable(PartialUpdateMergeFunction.java:451)
    at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction$SequenceGenerator.generate(PartialUpdateMergeFunction.java:440)
    at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction.updateWithSequenceGroup(PartialUpdateMergeFunction.java:158)
    at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction.add(PartialUpdateMergeFunction.java:132)
    at java.base/java.lang.Iterable.forEach(Iterable.java:75)
    at org.apache.paimon.mergetree.compact.LookupMergeFunction.getResult(LookupMergeFunction.java:78)
    at org.apache.paimon.mergetree.compact.LookupMergeFunction.getResult(LookupMergeFunction.java:36)
    at org.apache.paimon.mergetree.compact.ReducerMergeFunctionWrapper.getResult(ReducerMergeFunctionWrapper.java:72)
    at org.apache.paimon.mergetree.compact.ReducerMergeFunctionWrapper.getResult(ReducerMergeFunctionWrapper.java:32)
    at org.apache.paimon.mergetree.compact.SortMergeReaderWithLoserTree$SortMergeIterator.merge(SortMergeReaderWithLoserTree.java:111)
    at org.apache.paimon.mergetree.compact.SortMergeReaderWithLoserTree$SortMergeIterator.next(SortMergeReaderWithLoserTree.java:97)
    at org.apache.paimon.mergetree.DropDeleteReader$1.next(DropDeleteReader.java:54)
    at org.apache.paimon.mergetree.DropDeleteReader$1.next(DropDeleteReader.java:50)
    at org.apache.paimon.reader.RecordReader$RecordIterator$1.next(RecordReader.java:82)
    at org.apache.paimon.reader.RecordReader$RecordIterator$1.next(RecordReader.java:82)
    at org.apache.paimon.table.source.ResetRowKindRecordIterator.nextKeyValue(ResetRowKindRecordIterator.java:50)
    at org.apache.paimon.table.source.ValueContentRowDataRecordIterator.next(ValueContentRowDataRecordIterator.java:36)
    at org.apache.paimon.table.source.ValueContentRowDataRecordIterator.next(ValueContentRowDataRecordIterator.java:28)
    at org.apache.paimon.reader.RecordReaderIterator.advanceIfNeeded(RecordReaderIterator.java:74)
    at org.apache.paimon.reader.RecordReaderIterator.hasNext(RecordReaderIterator.java:53)
    at com.starrocks.paimon.reader.PaimonSplitScanner.getNext(PaimonSplitScanner.java:142)
    … 1 more
    : BE:10011

    at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:130)

    at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:654)

    at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$2(SQLQueryJob.java:545)

    at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:192)

    at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:564)

    at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:1039)

    at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:4301)

    at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:128)

    at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:192)

    at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:126)

    at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5026)

    at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:119)

    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

Caused by: java.sql.SQLSyntaxErrorException: Failed to call the nextChunkOffHeap method of off-heap table scanner. java exception details: java.io.IOException: Failed to get the next off-heap table chunk of paimon.
at com.starrocks.paimon.reader.PaimonSplitScanner.getNext(PaimonSplitScanner.java:163)
at com.starrocks.jni.connector.ConnectorScanner.getNextOffHeapChunk(ConnectorScanner.java:101)
Caused by: java.lang.NumberFormatException: For input string: “name”
at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.base/java.lang.Long.parseLong(Long.java:692)
at java.base/java.lang.Long.parseLong(Long.java:817)
at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction$SequenceGenerator$SequenceGeneratorVisitor.lambda$stringGenerator$0(PartialUpdateMergeFunction.java:468)
at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction$SequenceGenerator$Generator.generateNullable(PartialUpdateMergeFunction.java:451)
at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction$SequenceGenerator.generate(PartialUpdateMergeFunction.java:440)
at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction.updateWithSequenceGroup(PartialUpdateMergeFunction.java:158)
at org.apache.paimon.mergetree.compact.PartialUpdateMergeFunction.add(PartialUpdateMergeFunction.java:132)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at org.apache.paimon.mergetree.compact.LookupMergeFunction.getResult(LookupMergeFunction.java:78)
at org.apache.paimon.mergetree.compact.LookupMergeFunction.getResult(LookupMergeFunction.java:36)
at org.apache.paimon.mergetree.compact.ReducerMergeFunctionWrapper.getResult(ReducerMergeFunctionWrapper.java:72)
at org.apache.paimon.mergetree.compact.ReducerMergeFunctionWrapper.getResult(ReducerMergeFunctionWrapper.java:32)
at org.apache.paimon.mergetree.compact.SortMergeReaderWithLoserTree$SortMergeIterator.merge(SortMergeReaderWithLoserTree.java:111)
at org.apache.paimon.mergetree.compact.SortMergeReaderWithLoserTree$SortMergeIterator.next(SortMergeReaderWithLoserTree.java:97)
at org.apache.paimon.mergetree.DropDeleteReader$1.next(DropDeleteReader.java:54)
at org.apache.paimon.mergetree.DropDeleteReader$1.next(DropDeleteReader.java:50)
at org.apache.paimon.reader.RecordReader$RecordIterator$1.next(RecordReader.java:82)
at org.apache.paimon.reader.RecordReader$RecordIterator$1.next(RecordReader.java:82)
at org.apache.paimon.table.source.ResetRowKindRecordIterator.nextKeyValue(ResetRowKindRecordIterator.java:50)
at org.apache.paimon.table.source.ValueContentRowDataRecordIterator.next(ValueContentRowDataRecordIterator.java:36)
at org.apache.paimon.table.source.ValueContentRowDataRecordIterator.next(ValueContentRowDataRecordIterator.java:28)
at org.apache.paimon.reader.RecordReaderIterator.advanceIfNeeded(RecordReaderIterator.java:74)
at org.apache.paimon.reader.RecordReaderIterator.hasNext(RecordReaderIterator.java:53)
at com.starrocks.paimon.reader.PaimonSplitScanner.getNext(PaimonSplitScanner.java:142)
… 1 more
: BE:10011

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:767)

at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:652)

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:344)

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:128)

... 12 more

京ICP备2022026421号-1