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 ------------------------------------------------------------------------------ {{{ <property> <name>hive.exec.scratchdir</name> - <value>/tmp/hive-${user.name}</value> + <value>/tmp/mydir</value> <description>Scratch space for Hive jobs</description> </property> }}} @@ -22, +22 @@ 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: + Broadly the configuration variables are categorized into: + === Hive Configuration Variables === ||'''Variable Name'''||'''Description'''||'''Default Value'''|| ||hive.exec.script.wrapper||||null|| ||hive.exec.plan||||null|| @@ -34, +35 @@ ||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: + === Hive MetaStore Configuration Variables === ||'''Variable Name'''||'''Description'''||'''Default Value'''|| ||hive.metastore.metadb.dir|||||| ||hive.metastore.warehouse.dir|||||| ||hive.metastore.uris|||||| + ||hive.metastore.usefilestore|||||| + ||hive.metastore.rawstore.impl|||||| + ||hive.metastore.local|||||| + ||javax.jdo.option.ConnectionURL|||||| + ||javax.jdo.option.ConnectionDriverName|||||| + ||javax.jdo.option.ConnectionUserName|||||| + ||javax.jdo.option.ConnectionPassword|||||| + ||org.jpox.autoCreateSchema|||||| + ||org.jpox.fixedDatastore|||||| + ||hive.metastore.checkForDefaultDb|||||| - Hadoop related variables: + === Hive Configuration Variables used to interact with Hadoop === ||'''Variable Name'''||'''Description'''||'''Default Value'''|| ||hadoop.bin.path||||System.getenv("HADOOP_HOME") + "/bin/hadoop"|| ||hadoop.config.dir||||System.getenv("HADOOP_HOME") + "/conf"|| @@ -59, +67 @@ ||mapred.reduce.tasks||||1|| ||mapred.job.name||||null|| - Things we log in the jobconf: + === Hive Variables used to pass run time information === ||'''Variable Name'''||'''Description'''||'''Default Value'''|| ||hive.session.id|||||| ||hive.query.string|||||| ||hive.query.planid|||||| ||hive.jobname.length||||50|| + ||hive.table.name|||||| + ||hive.partition.name|||||| + ||hive.alias||||||
