Having rollback for DDLs was a bad idea.
and it turns out to be an unexpected behavior for the user.
DDLs only have transient errors (e.g. zk, hdfs, meta down)
if we abort/rollback on a transient failure the user will get a failure,
and it is not clear why the user needs to retry the command when the system can do that.