Page History

...

Configuring Hive

...

A number of configuration variables in Hive can be used by the administrator to change the behavior for their installations and user sessions. These variables can be configured in any of the following ways, shown in the order of preference:

• Using the set command in the cli for setting session level values for the configuration variable for all statements subsequent to the set command. e.g.

  Code Block
  set hive.exec.scratchdir=/tmp/mydir;

  sets the scratch directory (which is used by hive to store temporary output and plans) to /tmp/mydir for all subseq
• Using -hiveconf option on the cli for the entire session. e.g.

  Code Block
  bin/hive -hiveconf hive.exec.scratchdir=/tmp/mydir

• In hive-site.xml. This is used for setting values for the entire Hive configuration. e.g.

  Code Block
  xml xml
  <property> <name>hive.exec.scratchdir</name> <value>/tmp/mydir</value> <description>Scratch space for Hive jobs</description> </property>

• hive-default.xml - This configuration file contains the default values for various configuration variables that come with prepackaged in a Hive distribution. These should not be changed by the administrator. In order to override any of the values, create hive-site.xml instead and set the value in that file as shown above.

hive-default.xml is located in the conf directory in your installation root. hive-site.xml should also be created in the same directory.

...