Home > database >  Kettle cleaning the hive data, the data in the following Error Error to clickhouse setting value # 1
Kettle cleaning the hive data, the data in the following Error Error to clickhouse setting value # 1

Time:03-12

The following is the error log:

2021/03/09 17:24:17 - Table output. 0 - ERROR (version 7.1.0.0-12, build 1 from the 2017-05-16 17.18.02 by buildguy) : Because of an ERROR, this step can 't continue:
2021/03/09 17:24:17 - Table output. 0 - ERROR (version 7.1.0.0-12, build 1 from the 2017-05-16 17.18.02 by buildguy) : org. Pentaho. Di. Core. Exception. KettleException:
2021/03/09 17:24:17 - Table output. 0 - Error inserting a row into the Table [DIM_SKU_TEST] with values: [10000759]
2021/03/09 17:24:17 - Table output. 0
2021/03/09 17:24:17 - Table output. 0 - offending row: [SKU_SK String (2147483647)]
2021/03/09 17:24:17 - Table output. 0
2021/03/09 17:24:17 - Table output. 0 - Error setting value # 1 [String (2147483647)] on prepared statement
2021/03/09 17:24:17 - Table output. 0 - at Java. Lang. Thread. The run (null: 1)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Step. RunThread. Run (62) RunThread. Java:
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. The processRow (tableoutput. Java: 125)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. WriteToTable (tableoutput. Java: 261)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Core. The database. The database. The setValues (1076). The database Java:
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Core. The database. The database. The setValue (1060). The database Java:
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Core. Row. Value. ValueMetaBase. SetPreparedStatementValue ValueMetaBase. Java: (5042)
2021/03/09 17:24:17 - Table output. 0 - at ru. Another dual. Clickhouse. ClickHousePreparedStatementImpl. SetCharacterStream ClickHousePreparedStatementImpl. Java: (416)
2021/03/09 17:24:17 - Table output. 0
2021/03/09 17:24:17 - Table output. 0
2021/03/09 17:24:17 - Table output. 0
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. WriteToTable (tableoutput. Java: 385)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. The processRow (tableoutput. Java: 125)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Step. RunThread. Run (62) RunThread. Java:
2021/03/09 17:24:17 - Table output. 0 - at Java. Lang. Thread. The run (Unknown Source)
2021/03/09 17:24:17 - Table output. 0 - under Caused by: org. Pentaho. Di. Core. Exception. KettleDatabaseException:
2021/03/09 17:24:17 - Table output. 0 - offending row: [SKU_SK String (2147483647)]
2021/03/09 17:24:17 - Table output. 0
2021/03/09 17:24:17 - Table output. 0 - Error setting value # 1 [String (2147483647)] on prepared statement
2021/03/09 17:24:17 - Table output. 0 - at Java. Lang. Thread. The run (null: 1)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Step. RunThread. Run (62) RunThread. Java:
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. The processRow (tableoutput. Java: 125)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. WriteToTable (tableoutput. Java: 261)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Core. The database. The database. The setValues (1076). The database Java:
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Core. The database. The database. The setValue (1060). The database Java:
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Core. Row. Value. ValueMetaBase. SetPreparedStatementValue ValueMetaBase. Java: (5042)
2021/03/09 17:24:17 - Table output. 0 - at ru. Another dual. Clickhouse. ClickHousePreparedStatementImpl. SetCharacterStream ClickHousePreparedStatementImpl. Java: (416)
2021/03/09 17:24:17 - Table output. 0
2021/03/09 17:24:17 - Table output. 0
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Core. The database. The database. The setValues (1078). The database Java:
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. WriteToTable (tableoutput. Java: 261)
2021/03/09 17:24:17 - Table output. 0 -... 3 more
2021/03/09 17:24:17 - Table output. 0 - under Caused by: org. Pentaho. Di. Core. Exception. KettleDatabaseException:
2021/03/09 17:24:17 - Table output. 0 - Error setting value # 1 [String (2147483647)] on prepared statement
2021/03/09 17:24:17 - Table output. 0 - at Java. Lang. Thread. The run (null: 1)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Step. RunThread. Run (62) RunThread. Java:
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. The processRow (tableoutput. Java: 125)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. WriteToTable (tableoutput. Java: 261)
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Core. The database. The database. The setValues (1076). The database Java:
2021/03/09 17:24:17 - Table output. 0 - at org. Pentaho. Di. Core. The database. The database. The setValue (1060). The database Java:
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related