cdh hive mysql 元数据常用介绍

table version

select * from version;

+--------+----------------+----------------------------+
| VER_ID | SCHEMA_VERSION | VERSION_COMMENT            |
+--------+----------------+----------------------------+
|      1 | 2.1.1          | Hive release version 2.1.1 |
+--------+----------------+----------------------------+

table cdh_version

select * from cdh_version;

+--------+----------------+------------------------------------------+
| VER_ID | SCHEMA_VERSION | VERSION_COMMENT                          |
+--------+----------------+------------------------------------------+
|      1 | 2.1.1-cdh6.2.0 | Hive release version 2.1.1 for CDH 6.2.0 |
+--------+----------------+------------------------------------------+

table DBS

数据库的相关信息

select * from DBS;

+-------+-----------------------+-----------------------------------------------------------------------+------------------------+------------+------------+-------------+
| DB_ID | DESC                  | DB_LOCATION_URI                                                       | NAME                   | OWNER_NAME | OWNER_TYPE | CREATE_TIME |
+-------+-----------------------+-----------------------------------------------------------------------+------------------------+---