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 New page: 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. The following table lists all the configuration variables, their descriptions and default values: ||'''Variable Name'''||'''Description'''||'''Default Value'''|| ||hive.exec.script.wrapper||||null|| ||hive.exec.plan||||null|| ||hive.exec.scratchdir||||/tmp/"+System.getProperty("user.name")+"/hive"|| ||hive.exec.submitviachild||||false|| ||hive.exec.script.maxerrsize||||100000|| ||hive.exec.compress.output||||false|| ||hive.exec.compress.intermediate||||false|| ||hive.jar.path|||||| ||hive.aux.jars.path|||||| ||hive.table.name|||||| ||hive.partition.name|||||| ||hive.partition.pruning||||nonstrict|| ||hive.alias|||||| ||hive.map.aggr||||false|| ||hive.join.emit.interval||||1000|| ||hive.map.aggr.hash.percentmemory||||(float)0.5|| ||hive.default.fileformat||||TextFile|| MetaStore related variables: ||'''Variable Name'''||'''Description'''||'''Default Value'''|| ||hive.metastore.metadb.dir|||||| ||hive.metastore.warehouse.dir|||||| ||hive.metastore.uris|||||| Hadoop related variables: ||'''Variable Name'''||'''Description'''||'''Default Value'''|| ||hadoop.bin.path||||System.getenv("HADOOP_HOME") + "/bin/hadoop"|| ||hadoop.config.dir||||System.getenv("HADOOP_HOME") + "/conf"|| ||fs.default.name||||file:///|| ||map.input.file||||null|| ||mapred.job.tracker||||local|| ||mapred.reduce.tasks||||1|| ||mapred.job.name||||null|| Things we log in the jobconf: ||'''Variable Name'''||'''Description'''||'''Default Value'''|| ||hive.session.id|||||| ||hive.query.string|||||| ||hive.query.planid|||||| ||hive.jobname.length||||50||
