Transactional table access

As administrator, you must set file system permissions or enable the Apache Ranger service to authorize users who want to work with transactional tables. These types of tables are the default and ACID-compliant tables in Hive 3 and later.

ACID tables reside by default in /warehouse/tablespace/managed/hive on HDFS in CDP Data Center. Only the Hive service can own and interact with files in this directory. Storage-based authorization (SBA) does not work for giving users access ACID tables.

Ranger is the only available authorization mechanism for ACID tables.