HIVE 元数据信息 sql查询生成数据字典

最新推荐文章于 2023-03-07 23:33:00 发布

A .Wang，，

最新推荐文章于 2023-03-07 23:33:00 发布

阅读量654

点赞数

本文链接：https://blog.csdn.net/weixin_43170212/article/details/115232513

版权

SELECT
   a. NAME as SCHEMA_NAME,-- 数据库名称
   t.TBL_NAME as TABLE_NAME,-- 表名
   b.PARAM_VALUE as TABLE_COMMENT,-- 表注释
   e.INTEGER_IDX as COLUMN_ID,-- 字段序号
   e.COLUMN_NAME ,-- 字段名
e.TYPE_NAME as COLUMN_DATA_TYPE,-- 字段类型
f.PART_KEYS as PART_COLUMN,-- 分区字段
   e.COMMENT-- 字段注释
FROM
   TBLS t
   JOIN DBS a ON t.DB_ID = a.DB_ID
   LEFT JOIN (select TBL_ID,PARAM_VALUE FROM TABLE_PARAMS where PARAM_KEY='comment') b ON t.TBL_ID = b.TBL_ID
   LEFT JOIN SDS c ON t.SD_ID = c.SD_ID
   LEFT JOIN CDS d ON c.CD_ID = d.CD_ID
   LEFT JOIN COLUMNS_V2 e ON d.CD_ID = e.CD_ID
   LEFT JOIN (SELECT TBL_ID,GROUP_CONCAT(PKEY_NAME) AS PART_KEYS FROM PARTITION_KEYS GROUP BY TBL_ID) f on t.TBL_ID = f.TBL_ID
    where a. NAME = 'qding_dwb' -- 此处选择你需要的库
   order by 1,2,4