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.