Hive 常用参数设置

1）设置hive显示表头和当前使用数据库

 

<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>

临时设置

hive>set  hive.cli.print.header=true;

hive>hive.cli.print.current.db=true；