kettle输出数据一直报这个错误，怎么百度都查不明白

Question

2022/10/25 18:29:30 - dwd表输出本地mysql.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Because of an error, this step can't continue:
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.core.exception.KettleException:
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - Error batch inserting rows into table [dwd_f_index_date].
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - Errors encountered (first 10):
2022/10/25 18:29:30 - dwd表输出本地mysql.0 -
2022/10/25 18:29:30 - dwd表输出本地mysql.0 -
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - Error updating batch
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - Field 'remarks' doesn't have a default value
2022/10/25 18:29:30 - dwd表输出本地mysql.0 -
2022/10/25 18:29:30 - dwd表输出本地mysql.0 -
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:348)
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:125)
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - at java.lang.Thread.run(Thread.java:748)
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException:
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - Error updating batch
2022/10/25 18:29:30 - dwd表输出本地mysql.0 - Field 'remarks' doesn't have a default value
2022/10/25 18:

Answer 1

这里提示： Field 'remarks' doesn't have a default value
没有填入默认值的地方，没有插入元素
你把这个字段'remarks'需要插入值，或者你修改一下'remarks'默认值