hive metastore元数据库和表事务查询

1、登录存储hive元数据的MYSQL

2、使用metastore库

-- transactional 表属性 为true
select a.name, b.tbl_name
from metastore.DBS a
         left join metastore.TBLS b on a.DB_ID = b.DB_ID
         left join metastore.TABLE_PARAMS c on b.TBL_ID = c.TBL_ID
where c.PARAM_KEY = 'transactional'
  and c.PARAM_VALUE = 'true';