Hive Metastore MySQL tables

hive-meta-mysql.sql

select *
-- CONCAT(d.name, '.', t.TBL_NAME) as name, 
-- d.DB_LOCATION_URI as loc, 
-- t.TBL_TYPE as type
from hive.DBS as d
join hive.TBLS as t 
 on t.DB_ID = d.DB_ID
order by d.NAME,t.TBL_NAME                                          
;