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)