The BEGIN, COMMIT, and ROLLBACK SQL statements are not yet supported. All operations are automatically committed as transactions.

The user initiating the Hive session must have WRITE permission for the destination partition or table.

ZooKeeper and in-memory locks are not compatible with transactions.

Only ORC files are supported.

Destination tables must be bucketed and not sorted.

The only supported isolation level is Snapshot.