Ao copiar o Table Input e alterar os dados para DIM_TEMPO quando vou ver o preview recebo o seguinte log (início dele):
2021/03/09 07:50:07 - RepositoriesMeta - Reading repositories XML file: C:\Users\wellington.jesus\.kettle\repositories.xml
2021/03/09 07:50:10 - RepositoriesMeta - Reading repositories XML file: C:\Users\wellington.jesus\.kettle\repositories.xml
2021/03/09 07:50:11 - Spoon - Connected to metastore : reposucos, added to delegating metastore
2021/03/09 07:50:11 - RepositoriesMeta - Reading repositories XML file: C:\Users\wellington.jesus\.kettle\repositories.xml
2021/03/09 08:00:49 - /DimensoesDatamart - Dispatching started for transformation [/DimensoesDatamart]
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Unexpected error
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - Couldn't get row from result set
2021/03/09 08:00:50 - Dimensão Tempo DW.0 -
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - Unable to get value 'Date' from database resultset, index 1
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - HOUR_OF_DAY: 0 -> 1
2021/03/09 08:00:50 - Dimensão Tempo DW.0 -
2021/03/09 08:00:50 - Dimensão Tempo DW.0 -
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2760)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2730)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:148)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at java.lang.Thread.run(Unknown Source)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - Unable to get value 'Date' from database resultset, index 1
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - HOUR_OF_DAY: 0 -> 1
2021/03/09 08:00:50 - Dimensão Tempo DW.0 -
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:5314)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2138)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:3019)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2752)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - ... 4 more
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - Caused by: java.sql.SQLException: HOUR_OF_DAY: 0 -> 1
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:85)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:933)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:5296)
2021/03/09 08:00:50 - Dimensão Tempo DW.0 - ... 7 more