hive-site.xml添加以下参数:
<property>
<name>hive.cli.print.current.db
</name>
<value>true
</value>
</property>
<property>
<name>hive.cli.print.header
</name>
<value>true
</value>
</property>
效果:
hive (datalake)> select * from mg_hive_external
OK
mg_hive_external
.id mg_hive_external
.name mg_hive_external
.age mg_hive_external
.deptno
1 lisi
18 01
2 wangwu
20 01
3 Jack
22 02
4 tom
25 03
Time taken:
0.081 seconds, Fetched:
4 row(s)
Hive官网配置地址