Error BINLOG_FORMAT = STATEMENT when writing from spark to MySql
There is no option specified in spark documentation to change BINLOG_FORMAT
.
You can check the possible options here.
From the exception message:
InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
READ_UNCOMMITTED
is the default isolation in spark. You can try changing this option.