How to list the TRANSACTIONAL/NON_TRANSACTIONAL tables from Hive Metadata

[#1]

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

1. Connect to the backend database
2. 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.
3. 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;​