Data Access
Also available as:
loading table of contents...
Transaction Limitations

HDP currently has the following limitations for ACID-based transactions in Hive:

  • 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.