查看Hive表元数据字段注解（hive元数据mysql库中）

最新推荐文章于 2025-05-18 10:56:55 发布

柔情岁月-万圣节

最新推荐文章于 2025-05-18 10:56:55 发布

阅读量2.9k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/redhat1986/article/details/84786793

本文介绍如何通过Hive元数据在MySQL数据库中查看表字段的注解。首先，查找表对应的sd_id，然后使用sd_id获取cd_id，最后通过cd_id查询到字段的详细注解信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

根据表名查sd_id

mysql> select sd_id,tbl_name from tbls where tbl_name='s_member_core_customer_i';
+--------+--------------------------+
| sd_id  | tbl_name                 |
+--------+--------------------------+
| 111921 | s_member_core_customer_i |
+--------+--------------------------+
1 row in set (0.00 sec)

根据sd_id查cd_id

 mysql> select cd_id,sd_id from sds where sd_id='111921';
+-------+--------+
| cd_id | sd_id  |
+-------+--------+
| 35017 | 111921 |
+-------+--------+

根据cd_id即可查出注解字段

mysql> select * from columns_v2  where cd_id='35017';
+-------+---------------------------------------------------------------------------------------------------+----------------+-----------+-------------+
| CD_ID | COMMENT                                                                                           | COLUMN_NAME    | TYPE_NAME | INTEGER_IDX |
+-------+---------------------------------------------------------------------------------------------------+----------------+-----------+-------------+
| 35017 | notinuse/????(PERSON_CERTIFY????,IMPORT_PERSON_BATCH_REGISTER??????????,OTHER_ORG_REGISTER?????)  | cert_from      | string    |           4 |
| 35017 | kyclevel-10/0/10/20/30/?????-10/0/10/20/30                                                        | certify_info   | string    |           2 |
| 35017 | VerificationStatus:C:Verified,N:NotVerified,U:InProgress/????(C????,N???,U?????)                  | certify_status | string    |           3 |
| 35017 | Createtime/????                                                                                   | created_date   | string    |           7 |
| 35017 | uniquekey/??id                                                                                    | customer_id    | string    |           1 |
| 35017 | Deleteornot:Deleteornot:0:No,1:Yes(whenusingthetableshouldfilterwheredelete_status=0)/????(0?,1?) | delete_status  | int       |           9 |
| 35017 | OperationStatus:N:Normal,F:Frozen,W:Inactive,C:Delete/?????(N??,F??,W???,C??)                     | enable_status  | string    |           6 |
| 35017 | autogeneratedkey(runningnumber)/??                                                                | id             | int       |           0 |
| 35017 | Updatetime/????                                                                                   | modified_date  | string    |           8 |
| 35017 | notinuse/??????(T?,F??)                                                                           | sub_user_flag  | string    |           5 |
+-------+---------------------------------------------------------------------------------------------------+----------------+-----------+-------------+