在启动hive cli的时候,select * from 表名 出现的仅仅是表数据,并不会显示表的结构和数据库的名称,使用该操作,会在hive cli 进行数据库语句查询的时候,显示数据库和表的结构
hive> set hive.cli.print.header=true;
hive> select * from emp_hive1;
OK
emp_hive1.empno emp_hive1.ename emp_hive1.job emp_hive1.mgr emp_hive1.hiredate emp_hive1.salary emp_hive1.comm emp_hive1.deptno
mysql> show tables;
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
sort_cols
tab_col_stats
table_params
tbl_col_privs
tbl_privs
tbls
txn_components
txns
type_fields
types
version
write_set
https://www.cnblogs.com/qingyunzong/p/8710356.html
1、关于整个hive的版本信息表
mysql> select * from version;
+--------+----------------+----------------------------+
| VER_ID | SCHEMA_VERSION | VERSION_COMMENT |
+--------+----------------+----------------------------+
| 1 | 2.1.0 | Hive release version 2.1.0 |
+--------+----------------+----------------------------+
该表很重要,
mysql> show tables;
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
sort_cols
tab_col_stats
table_params
tbl_col_privs
tbl_privs
tbls
txn_components
txns
type_fields
types
version
write_set
https://www.cnblogs.com/qingyunzong/p/8710356.html
1、关于整个hive的版本信息表
mysql> select * from version;
+--------+----------------+----------------------------+
| VER_ID | SCHEMA_VERSION | VERSION_COMMENT |
+--------+----------------+----------------------------+
| 1 | 2.1.0 | Hive release version 2.1.0 |
+--------+----------------+----------------------------+
该表很重要,