hive查看数据库里库的信息_Hive高阶之显示数据库名称和字段名

在hive中默认是不显示数据库的名称和数据表的字段名称的，这样我们在hive进行查询的时候就会发现不是很方便。默认hive的客户端执行方式如下：

[root@node3 ~]# sudo -u hive hive

Logging initialized using configuration in jar:file:/opt/cloudera/parcels/CDH-5.15.2-1.cdh5.15.2.p0.3/jars/hive-common-1.1.0-cdh5.15.2.jar!/hive-log4j.properties

WARNING: Hive CLI is deprecated and migration to Beeline is recommended.

hive> show databases;

OK

default

test

Time taken: 1.219 seconds, Fetched: 2 row(s)

hive> show tables;

OK

emp

Time taken: 0.085 seconds, Fetched: 8 row(s)

hive> select * from emp;

OK

7369 SMITH CLERK 7902 1980-12-17 800.0 NULL 20

7499 ALLEN SALESMAN 7698 1981-2-20 1600.0 300.0 30

......

7934 MILLER CLERK 7782 1982-1-23 1300.0 NULL 10

Time taken: 0.768 seconds, Fetched: 14 row(s)

hive>

如何才能让客户端显示我们想知道的数