Unable to get value 'BigNumber(16)' from database resultset, index 0

Question

各位好，今天使用kettle连接hiveServer2成功后，表输入遇到了如下的报错，网上找了好久都没有好的解决方案，哪位朋友如果遇到过类似问题能不能指导在下一二，非常感谢!
kettle版本：9.2

报错信息如下：
2022/01/20 10:04:24 - 表输入.0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Unexpected error
2022/01/20 10:04:24 - 表输入.0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2022/01/20 10:04:24 - 表输入.0 - Couldn't get row from result set
2022/01/20 10:04:24 - 表输入.0 -
2022/01/20 10:04:24 - 表输入.0 - Unable to get value 'BigNumber(16)' from database resultset, index 0
2022/01/20 10:04:24 - 表输入.0 - Illegal conversion
2022/01/20 10:04:24 - 表输入.0 -
2022/01/20 10:04:24 - 表输入.0 -
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2764)
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2734)
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2712)
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:265)
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2022/01/20 10:04:24 - 表输入.0 - at java.lang.Thread.run(Thread.java:748)
2022/01/20 10:04:24 - 表输入.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2022/01/20 10:04:24 - 表输入.0 - Unable to get value 'BigNumber(16)' from database resultset, index 0
2022/01/20 10:04:24 - 表输入.0 - Illegal conversion
2022/01/20 10:04:24 - 表输入.0 -
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:5327)
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2138)
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:3030)
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2756)
2022/01/20 10:04:24 - 表输入.0 - ... 6 more
2022/01/20 10:04:24 - 表输入.0 - Caused by: java.sql.SQLException: Illegal conversion
2022/01/20 10:04:24 - 表输入.0 - at org.apache.hive.jdbc.HiveBaseResultSet.getBigDecimal(HiveBaseResultSet.java:135)
2022/01/20 10:04:24 - 表输入.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:5282)
2022/01/20 10:04:24 - 表输入.0 - ... 9 more
2022/01/20 10:04:24 - 表输入.0 - !TableInput.Log.FinishedReadingQuery!
2022/01/20 10:04:24 - 表输入.0 - 完成处理 (I=0, O=0, R=0, W=0, U=0, E=1)
2022/01/20 10:04:24 - 测试 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : 错误被检测到!
2022/01/20 10:04:24 - Spoon - 转换完成!!
2022/01/20 10:04:24 - 测试 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : 错误被检测到!
2022/01/20 10:04:24 - 测试 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : 错误被检测到!
2022/01/20 10:04:24 - 测试 - 转换被检测
2022/01/20 10:04:24 - 测试 - 转换正在杀死其他步骤!

Answer 1

你好，我是有问必答小助手，非常抱歉，本次您提出的有问必答问题，技术专家团超时未为您做出解答


本次提问扣除的有问必答次数，将会以问答VIP体验卡（1次有问必答机会、商城购买实体图书享受95折优惠）的形式为您补发到账户。


因为有问必答VIP体验卡有效期仅有1天，您在需要使用的时候【私信】联系我，我会为您补发。