Table of Contents | ||
---|---|---|
|
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:
...
Please see the Admin Manual's section on the Metastore for details.
For security configuration (Hive 0.10 and later), see the Hive Metastore Security section in the Language Manual's Configuration Properties.
Hive Configuration Variables
...
Used to
...
Interact with Hadoop
Variable Name | Description | Default Value |
hadoop.bin.path | The location of hadoop script which is used to submit jobs to hadoop when submitting through a separate jvm. | $HADOOP_HOME/bin/hadoop |
hadoop.config.dir | The location of the configuration directory of the hadoop installation | $HADOOP_HOME/conf |
fs.default.name |
| file:/// |
map.input.file |
| null |
mapred.job.tracker | The url to the jobtracker. If this is set to local then map/reduce is run in the local mode. | local |
mapred.reduce.tasks | The number of reducers for each map/reduce stage in the query plan. | 1 |
mapred.job.name | The name of the map/reduce job | null |
Hive Variables
...
Used to Pass Run Time Information
Variable Name | Description | Default Value |
hive.session.id | The id of the Hive Session. |
|
hive.query.string | The query string passed to the map/reduce job. |
|
hive.query.planid | The id of the plan for the map/reduce stage. |
|
hive.jobname.length | The maximum length of the jobname. | 50 |
hive.table.name | The name of the hive table. This is passed to the user scripts through the script operator. |
|
hive.partition.name | The name of the hive partition. This is passed to the user scripts through the script operator. |
|
hive.alias | The alias being processed. This is also passed to the user scripts through the script operator. |
|
...