mysql中hive的元数据信息

mysql中hive的元数据信息

mysql中关于hive的元数据存放表

+---------------------------+

| Tables_in_hive2           |

+---------------------------+

| aux_table                 |

| bucketing_cols            |

| cds                       |

| columns_v2                |

| compaction_queue          |

| completed_compactions     |

| completed_txn_components  |

| database_params           |

| db_privs                  |

| dbs                       |

| delegation_tokens         |

| func_ru                   |

| funcs                     |

| global_privs              |

| hive_locks                |

| idxs                      |

| index_params              |

| key_constraints           |

| master_keys               |

| next_compaction_queue_id  |

| next_lock_id              |

| next_txn_id               |

| notification_log          |

| notification_sequence     |

| nucleus_tables            |

| part_col_privs            |

| part_col_stats            |

| part_privs                |

| partition_events          |

| partition_key_vals        |

| partition_keys            |

| partition_params          |

| partitions                |

| role_map                  |

| roles                     |

| sd_params                 |

| sds                       |

| sequence_table            |

| serde_params              |

| serdes                    |

| skewed_col_names          |

| skewed_col_value_loc_map  |

| skewed_string_list        |

| skewed_string_list_values |

| skewed_values             |

​

VERSION表

hive的版本信息以及hive所在主机的地址

mysql> SELECT * FROM VERSION;

 

+--------+----------------+----------------------------------------+

| VER_ID | SCHEMA_VERSION | VERSION_COMMENT                        |

+--------+----------------+----------------------------------------+

|      1 | 2.1.0          | Set by MetaStore centos@192.168.33.101 |

+--------+----------------+----------------------------------------+

DBS表

存放hive数据库的元数据信息

mysql> select * from DBS;

+-------+-----------------------+----------------------------------------------+---------+------------+------------+

| DB_ID | DESC                  | DB_LOCATION_URI                              | NAME    | OWNER_NAME | OWNER_TYPE |

+-------+-----------------------+----------------------------------------------+---------+------------+------------+

|     1 | Default Hive database | hdfs://mycluster/user/hive/warehouse         | default | public     | ROLE       |

|    21 | NULL                  | hdfs://mycluster/user/hive/warehouse/tang.db | tang    | centos     | USER       |

+-------+-----------------------+----------------------------------------------+---------+------------+------------+

TBLS表

TBLS 存放了各表的元数据信息。

mysql> select * from TBLS;

+--------+-------------+-------+------------------+--------+-----------+-------+--------------+---------------+--------------------+--------------------+

| TBL_ID | CREATE_TIME | DB_ID | LAST_ACCESS_TIME | OWNER  | RETENTION | SD_ID | TBL_NAME     | TBL_TYPE      | VIEW_EXPANDED_TEXT | VIEW_ORIGINAL_TEXT |

+--------+-------------+-------+------------------+--------+-----------+-------+--------------+---------------+--------------------+--------------------+

|     56 |  1557839523 |     1 |                0 | centos |         0 |    61 | tt           | MANAGED_TABLE | NULL               | NULL               |

|     66 |  1575383020 |     1 |                0 | centos |         0 |    71 | test2        | MANAGED_TABLE | NULL               | NULL               |

|     71 |  1575462931 |    21 |                0 | centos |         0 |    76 | student_test | MANAGED_TABLE | NULL               | NULL               |

+--------+-------------+-------+------------------+--------+-----------+-------+--------------+---------------+--------------------+--------------------+

 

COLUMNS_V2表

COLUMNS_V2表存放了列的元数据信息

mysql> select * from COLUMNS_V2;

+-------+---------+-------------+-----------------------------+-------------+

| CD_ID | COMMENT | COLUMN_NAME | TYPE_NAME                   | INTEGER_IDX |

+-------+---------+-------------+-----------------------------+-------------+

|    71 | NULL    | id          | int                         |           0 |

|    71 | NULL    | info        | struct<name:string,age:int> |           1 |

+-------+---------+-------------+-----------------------------+-------------+

PARTITOINS 表

PARTITOINS 表存放了表分区的元数据信息.

PARTITION_KEYS表

PARTITION_KEYS 存放了分区key的元数据信息

PARTITION_VALUES表

PARTITION_VALUES 存放了分区值的元数据信息 、