sqoop1.4.7之删除时事务异常

最新推荐文章于 2024-01-17 15:45:10 发布

jiandequn

最新推荐文章于 2024-01-17 15:45:10 发布

阅读量596

点赞数

分类专栏： sqoop

本文链接：https://blog.csdn.net/jiandequn/article/details/108007817

版权

当mysql的binlog_format=STATEMENT 是，sqoop执行以下删除语句异常：


sqoop eval \
--connect 'jdbc:mysql://*:3306/yn_hadoop?useUnicode=true&characterEncoding=utf-8' \
--username ynhadoop \
--password * \
--query "delete from video_user_count_rank_day where t_date>='2020-08-03' and t_date<'2020-08-04';";

sqoop对mysql进行按条件查询删除时，报transaction isolation level is READ COMMITTED or READ UNCOMMITTED；如下：

2020-08-14 14:42:53,064 WARN tool.EvalSqlTool: SQL exception executing statement: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
	at com.mysql.jdbc.MysqlIO.c