Pentaho雪花插件

Question

我已经在Pentaho版本9.2中安装了Snowflake插件。我有特定的流动，需要更新。这些流动正常，然后突然它们开始显示错误。进入。 找到此错误在表输入步骤中。

表input.0-错误（版本9.2.0.0-290，构建9.2.0.0-290 2021-06-02 06.36.08 buildguy）：意外错误

2022/06/23 20:35:38 - Table input.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/06/23 20:35:38 - Table input.0 - Couldn't get row from result set
2022/06/23 20:35:38 - Table input.0 -  at java.lang.Thread.run (null:-1)
2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.trans.step.RunThread.run (RunThread.java:62)
2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.trans.steps.tableinput.TableInput.processRow (TableInput.java:143)
2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery (TableInput.java:265)
2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.Database.getRow (Database.java:2712)
2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.Database.getRow (Database.java:2734)
2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.Database.getRow (Database.java:2756)
2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet (DatabaseMeta.java:3030)
2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet (BaseDatabaseMeta.java:2138)
2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet (ValueMetaBase.java:5309)
2022/06/23 20:35:38 - Table input.0 -  at net.snowflake.client.jdbc.SnowflakeBaseResultSet.getTimestamp (SnowflakeBaseResultSet.java:302)
2022/06/23 20:35:38 - Table input.0 -  at net.snowflake.client.jdbc.SnowflakeResultSetV1.getTimestamp (SnowflakeResultSetV1.java:236)
2022/06/23 20:35:38 - Table input.0 -  at net.snowflake.client.core.SFBaseResultSet.getTimestamp (SFBaseResultSet.java:522)
2022/06/23 20:35:38 - Table input.0 - 
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.Database.getRow(Database.java:2764)
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.Database.getRow(Database.java:2734)
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.Database.getRow(Database.java:2712)
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:265)
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2022/06/23 20:35:38 - Table input.0 -   at java.lang.Thread.run(Unknown Source)
2022/06/23 20:35:38 - Table input.0 - Caused by: java.lang.NullPointerException
2022/06/23 20:35:38 - Table input.0 -   at net.snowflake.client.core.SFBaseResultSet.getTimestamp(SFBaseResultSet.java:522)
2022/06/23 20:35:38 - Table input.0 -   at net.snowflake.client.jdbc.SnowflakeResultSetV1.getTimestamp(SnowflakeResultSetV1.java:236)
2022/06/23 20:35:38 - Table input.0 -   at net.snowflake.client.jdbc.SnowflakeBaseResultSet.getTimestamp(SnowflakeBaseResultSet.java:302)
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:5309)
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2138)
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:3030)
2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.Database.getRow(Database.java:2756)
2022/06/23 20:35:38 - Table input.0 -   ... 6 more

在数据库连接中也出乎意料的错误，连接类型自动从Snowflake中自动选择到Snowflake数据库。我认为这可能是原因。现在，我的所有流程表输入步骤正在显示错误。 请引导我。

谢谢 湿婆