Page History

...

• 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 Blocknoformat
  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 Blocknoformat
  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. xml

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

...