2021/07/15 14:55:48 - Spoon - Using legacy execution engine
2021/07/15 14:55:48 - Spoon - 转换已经打开.
2021/07/15 14:55:48 - Spoon - 正在打开转换 [HiveToClickhouse]...
2021/07/15 14:55:48 - Spoon - 开始执行转换.
2021/07/15 14:55:48 - HiveToClickhouse - Validating active environment 'Environment #1'
2021/07/15 14:55:48 - HiveToClickhouse - Validation against environment home : D:\guojc\work\Kettle
2021/07/15 14:55:48 - HiveToClickhouse - 为了转换解除补丁开始 [HiveToClickhouse]
2021/07/15 14:55:48 - 表输出.0 - Connected to database [Clickhouse192.168.0.71] (commit=1000)
2021/07/15 14:55:49 - 表输出.0 - ERROR (version 8.2.0.7-719, build 8.2.0.7-719 from 2019-06-27 12.22.51 by kettle) : Because of an error, this step can't continue:
2021/07/15 14:55:49 - 表输出.0 - ERROR (version 8.2.0.7-719, build 8.2.0.7-719 from 2019-06-27 12.22.51 by kettle) : org.pentaho.di.core.exception.KettleException:
**2021/07/15 14:55:49 - 表输出.0 - Error inserting row into table [t_member_cookie_test] with values: [234801626280573059]**
2021/07/15 14:55:49 - 表输出.0 -
2021/07/15 14:55:49 - 表输出.0 - offending row : [cookie String(2147483647)]
2021/07/15 14:55:49 - 表输出.0 -
2021/07/15 14:55:49 - 表输出.0 - Error setting value #1 [String(2147483647)] on prepared statement
2021/07/15 14:55:49 - 表输出.0 - at java.lang.Thread.run (null:-1)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run (RunThread.java:62)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow (TableOutput.java:125)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable (TableOutput.java:261)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.database.Database.setValues (Database.java:1079)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.database.Database.setValue (Database.java:1063)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.row.value.ValueMetaBase.setPreparedStatementValue (ValueMetaBase.java:5388)
2021/07/15 14:55:49 - 表输出.0 - at ru.yandex.clickhouse.ClickHousePreparedStatementImpl.setCharacterStream (ClickHousePreparedStatementImpl.java:416)
2021/07/15 14:55:49 - 表输出.0 -
2021/07/15 14:55:49 - 表输出.0 -
2021/07/15 14:55:49 - 表输出.0 -
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:384)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:125)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2021/07/15 14:55:49 - 表输出.0 - at java.lang.Thread.run(Unknown Source)
2021/07/15 14:55:49 - 表输出.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2021/07/15 14:55:49 - 表输出.0 - offending row : [cookie String(2147483647)]
2021/07/15 14:55:49 - 表输出.0 -
2021/07/15 14:55:49 - 表输出.0 - Error setting value #1 [String(2147483647)] on prepared statement
2021/07/15 14:55:49 - 表输出.0 - at java.lang.Thread.run (null:-1)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run (RunThread.java:62)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow (TableOutput.java:125)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable (TableOutput.java:261)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.database.Database.setValues (Database.java:1079)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.database.Database.setValue (Database.java:1063)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.row.value.ValueMetaBase.setPreparedStatementValue (ValueMetaBase.java:5388)
2021/07/15 14:55:49 - 表输出.0 - at ru.yandex.clickhouse.ClickHousePreparedStatementImpl.setCharacterStream (ClickHousePreparedStatementImpl.java:416)
2021/07/15 14:55:49 - 表输出.0 -
2021/07/15 14:55:49 - 表输出.0 -
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.database.Database.setValues(Database.java:1081)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:261)
2021/07/15 14:55:49 - 表输出.0 - ... 3 more
2021/07/15 14:55:49 - 表输出.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2021/07/15 14:55:49 - 表输出.0 - Error setting value #1 [String(2147483647)] on prepared statement
2021/07/15 14:55:49 - 表输出.0 - at java.lang.Thread.run (null:-1)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run (RunThread.java:62)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow (TableOutput.java:125)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable (TableOutput.java:261)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.database.Database.setValues (Database.java:1079)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.database.Database.setValue (Database.java:1063)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.row.value.ValueMetaBase.setPreparedStatementValue (ValueMetaBase.java:5388)
2021/07/15 14:55:49 - 表输出.0 - at ru.yandex.clickhouse.ClickHousePreparedStatementImpl.setCharacterStream (ClickHousePreparedStatementImpl.java:416)
2021/07/15 14:55:49 - 表输出.0 -
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5474)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.database.Database.setValue(Database.java:1063)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.database.Database.setValues(Database.java:1079)
2021/07/15 14:55:49 - 表输出.0 - ... 4 more
2021/07/15 14:55:49 - 表输出.0 - Caused by: java.sql.SQLFeatureNotSupportedException
2021/07/15 14:55:49 - 表输出.0 - at ru.yandex.clickhouse.ClickHousePreparedStatementImpl.setCharacterStream(ClickHousePreparedStatementImpl.java:416)
2021/07/15 14:55:49 - 表输出.0 - at org.pentaho.di.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5388)
2021/07/15 14:55:49 - 表输出.0 - ... 6 more
2021/07/15 14:55:49 - 表输出.0 - 完成处理 (I=0, O=0, R=1, W=0, U=0, E=1)
2021/07/15 14:55:49 - 表输入.0 - Finished reading query, closing connection.
2021/07/15 14:55:49 - HiveToClickhouse - 转换被检测
2021/07/15 14:55:49 - HiveToClickhouse - 转换正在杀死其他步骤!
2021/07/15 14:55:49 - 表输入.0 - 完成处理 (I=3, O=0, R=0, W=2, U=0, E=0)
2021/07/15 14:55:49 - HiveToClickhouse - Transformation duration : 1.089 seconds [ 1.088" ]
2021/07/15 14:55:49 - HiveToClickhouse - ERROR (version 8.2.0.7-719, build 8.2.0.7-719 from 2019-06-27 12.22.51 by kettle) : 错误被检测到!
2021/07/15 14:55:49 - Spoon - 转换完成!!
2021/07/15 14:55:49 - HiveToClickhouse - ERROR (version 8.2.0.7-719, build 8.2.0.7-719 from 2019-06-27 12.22.51 by kettle) : 错误被检测到!
2021/07/15 14:55:49 - HiveToClickhouse - ERROR (version 8.2.0.7-719, build 8.2.0.7-719 from 2019-06-27 12.22.51 by kettle) : 错误被检测到!
源表Hive只有一个字段，目标表Clickhouse也只有一个字段，字段类型是String，然后怎么都插入不进去，都报错。
我尝试将数据源的sql写一个固定值，比如‘select 'aa' cookie’这样也不行，但是呢，‘select 1111 cookie’这样写就可以插入进去，就是把字符串改成了数字就可以插入了。
不知道是什么问题了，麻 烦 各 位大 佬帮 忙 解 答一 下。
感 谢
已经解决了
请问这个问题怎么解决的？我现在也遇到了这个问题