一、课程回顾
二、MataStore (配置保存在MySQL中)
1 show databases;
2 use hive and show tables;
一般有三十多张表,如上图所示
3 select * from DBS \G;
DB_ID:每个表隶属数据库,层级结构
4 SELECT * FROM VERSION \G;
5 select * from VERSION;
6 select * from TBLS \G;
*************************** 1. row ***************************
TBL_ID: 1
CREATE_TIME: 1491146248
DB_ID: 1
LAST_ACCESS_TIME: 0
OWNER: hadoop
RETENTION: 0
SD_ID: 1
TBL_NAME: emp
TBL_TYPE: MANAGED_TABLE
VIEW_EXPANDED_TEXT: NULL
VIEW_ORIGINAL_TEXT: NULL
*************************** 2. row ***************************
TBL_ID: 2
CREATE_TIME: 1491146253
DB_ID: 1
LAST_ACCESS_TIME: 0
OWNER: hadoop
RETENTION: 0
SD_ID: 2
TBL_NAME: dept
TBL_TYPE: MANAGED_TABLE
VIEW_EXPANDED_TEXT: NULL
VIEW_ORIGINAL_TEXT: NULL
*************************** 3. row ***************************
TBL_ID: 6
CREATE_TIME: 1491150301
DB_ID: 1
LAST_ACCESS_TIME: 0
OWNER: hadoop
RETENTION: 0
SD_ID: 6
TBL_NAME: t
TBL_TYPE: MANAGED_TABLE
VIEW_EXPANDED_TEXT: NULL
VIEW_ORIGINAL_TEXT: NULL
*************************** 4. row ***************************
TBL_ID: 16
CREATE_TIME: 1491293296
DB_ID: 1
LAST_ACCESS_TIME: 0
OWNER: hadoop
RETENTION: 0
SD_ID: 16
TBL_NAME: hive_table_1
TBL_TYPE: MANAGED_TABLE
VIEW_EXPANDED_TEXT: NULL
VIEW_ORIGINAL_TEXT: NULL
*************************** 5. row ***************************
TBL_ID: 17
CREATE_TIME: 1491293488
DB_ID: 1
LAST_ACCESS_TIME: 0
OWNER: hadoop
RETENTION: 0
SD_ID: 17
TBL_NAME: hive_table_2
TBL_TYPE: MANAGED_TABLE
VIEW_EXPANDED_TEXT: NULL
VIEW_ORIGINAL_TEXT: NULL
*************************** 6. row ***************************
TBL_ID: 26
CREATE_TIME: 1546787041
DB_ID: 1
LAST_ACCESS_TIME: 0
OWNER: hadoop
RETENTION: 0
SD_ID: 26
TBL_NAME: dept_partition
TBL_TYPE: MANAGED_TABLE
VIEW_EXPANDED_TEXT: NULL
VIEW_ORIGINAL_TEXT: NULL
6 rows in set (0.00 sec)
7 select * from TABLE_PARAMS\G ;
mysql> select * from TABLE_PARAMS \G;
*************************** 1. row ***************************
TBL_ID: 1
PARAM_KEY: COLUMN_STATS_ACCURATE
PARAM_VALUE: true
*************************** 2. row ***************************
TBL_ID: 1
PARAM_KEY: numFiles
PARAM_VALUE: 1
*************************** 3. row **************