蜂巢有数据字典吗? [英] Does hive have a data dictionary?
本文介绍了蜂巢有数据字典吗?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
配置单元是否有数据字典?我试图获取蜂巢中的表的列名称.类似于oracle查询，除了describe命令:
Does hive have a data dictionary? I am trying to fetch the column names of tables in hive. Similar to oracle query other than describe command:
SELECT COLUMN_NAME,DATA_TYPE FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = ? ORDER BY COLUMN_ID;
推荐答案
Hive使用外部关系数据库作为其元商店.您可以使用metastore API(例如MySQL)直接查询已配置的metastore.更高级别的组件是 HCatalog ，该组件提供了用于访问和操作元存储库的API.
Hive uses an external relational database as its metastore. You can query the configured metastore directly, using the metastore API (eg. MySQL). A higher level component is HCatalog, which offers an API to access and manipulate the metastore.
这篇关于蜂巢有数据字典吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
