Versions Compared

Old Version 28

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 29

changes.mady.by.user Xuefu Zhang

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel4

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.

    No Format
    
  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.

    No Format
    
  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.

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

...