<property>
<name>hive.cli.print.header</name>
<value>true</value>
<description>Whether to print the names of the columns in query output.</description>
</property>
<property>
<name>hive.cli.print.current.db</name>
<value>true</value>
<description>Whether to include the current database in the Hive prompt.</description>
</property>
<!-- 只显示列名,不是表名.列名 -->
<property>
<name>hive.resultset.use.unique.column.names</name>
<value>false</value>
</property>

显示效果如下:

HIVE 查询结果中显示库名、列名(不带表名)_hadoop