基于hive数仓的数据字典查询
SELECT D.NAME AS SCHEMA_NAME, -- 数据库名称 T.TBL_NAME AS TABLE_NAME_EN, -- 表名 P.PARAM_VALUE AS TABLE_NAME_CN, C.INTEGER_IDX AS COLUMN_ID, -- 字段序号 C.COLUMN_NAME AS COLUMN_NAME_EN, -- 字段名 C.COMMENT AS COLUMN_NAME_CN, -- 字段备注 C.TYPE_NAME AS COLUMN_DATA_TYP