Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by AshishThusoo: http://wiki.apache.org/hadoop/Hive/AdminManual/Configuration ------------------------------------------------------------------------------ + 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. - A number of configuration variables in Hive can be used by the administrator to change the behavior for their installations. These are defined in two files: - * hive-default.xml - This configuration file contains the default values for various configuration variables. - * hive-site.xml - This configuration file can be used to override the default values by the administrator. - - hive-default.xml is located in the conf directory in your installation root. hive-site.xml should also be created in the same directory. - - In addition these variables can also be overridden at the session level through the cli by using the set commands. e.g. {{{ 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 subsequent queries in the session. + 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. + {{{ + 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. + {{{ + <property> + <name>hive.exec.scratchdir</name> + <value>/tmp/hive-${user.name}</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. The following table lists all the configuration variables, their descriptions and default values:
