【HIVE】 hive元数据查询语句集合

1、查询表字段

select d.db_id, d.NAME db_name, t.tbl_id, t.tbl_name, t.tbl_type, from_unixtime(t.create_time) create_time, 
c.column_name, c.type_name column_type, c.comment column_desc
from TBLS t 
inner join DBS d on t.DB_ID = d.DB_ID
inner join SDS s on t.SD_ID = s.SD_ID
inner join COLUMNS_V2 c on s.CD_ID = c.CD_ID
where 1 = 1   and (t.tbl_name like '%26526%' or c.column_name like '%26526%' or t.tbl_id = '26526')
order by d.DB_ID, d.NAME, t.TBL_ID, t.TBL_NAME