Cloudera Community

Community Articles

Find and share helpful community-sourced technical articles.

Advanced Search

asish

Guru

To list all the tables that are ACID(TRANSACTIONAL)/ NON_TRANSACTIONAL, perform the following steps:

Connect to the backend database
Execute "use hive" as all the tables are in the Hive database
Note: Please check if the database name is different. This is specified at the time of creating the Hive service.

Execute the following to check for ACID table:

select PARAM_KEY,PARAM_VALUE,TBL_NAME from TABLE_PARAMS,TBLS where PARAM_KEY='transactional' and  PARAM_VALUE='true' and TABLE_PARAMS.TBL_ID=TBLS.TBL_ID;

OR, execute below to check for NON-TRANSACTIONAL table.

select PARAM_KEY,PARAM_VALUE,TBL_NAME from TABLE_PARAMS,TBLS where PARAM_KEY='transactional' and  PARAM_VALUE='false' and TABLE_PARAMS.TBL_ID=TBLS.TBL_ID;

1,003 Views