Hive安装-windows（转载）

  <!--修改的配置-->  

 <property>  

 <name>hive.metastore.warehouse.dir</name>  

 <!--hive的数据存储目录，指定的位置在hdfs上的目录-->  

 <value>/user/hive/warehouse</value>  

 <description>location of default database for the warehouse</description>  

 </property>  

 <property>  

 <name>hive.exec.scratchdir</name>  

 <!--hive的临时数据目录，指定的位置在hdfs上的目录-->  

 <value>/tmp/hive</value>  

 <description>HDFS root scratch dir for Hive jobs which gets created with write all (733) permission. For each connecting user, an HDFS scratch dir: ${hive.exec.scratchdir}/<username> is created, with ${hive.scratch.dir.permission}.</description>  

 </property>  

 <property>  

 <name>hive.exec.local.scratchdir</name>  

 <!--本地目录-->  

 <value>F:/hadoop/apache-hive-2.1.1-bin/hive/iotmp</value>  

 <description>Local scratch space for Hive jobs</description>  

 </property>  

 <property>  

 <name>hive.downloaded.resources.dir</name>  

 <!--本地目录-->  

 <value>F:/hadoop/apache-hive-2.1.1-bin/hive/iotmp</value>  

 <description>Temporary local directory for added resources in the remote file system.</description>  

 </property>  

 <property>  

 <name>hive.querylog.location</name>  

 <!--本地目录-->  

 <value>F:/hadoop/apache-hive-2.1.1-bin/hive/iotmp</value>  

 <description>Location of Hive run time structured log file</description>  

 </property>  

 <property>  

 <name>hive.server2.logging.operation.log.location</name>  

 <value>F:/hadoop/apache-hive-2.1.1-bin/hive/iotmp/operation_logs</value>  

 <description>Top level directory where operation logs are stored if logging functionality is enabled</description>  

 </property>  

 <!--新增的配置-->  

 <property>  

 <name>javax.jdo.option.ConnectionURL</name>  

 <value>jdbc:mysql://localhost:3306/hive?characterEncoding=UTF-8</value>  

 </property>  

 <property>  

 <name>javax.jdo.option.ConnectionDriverName</name>  

 <value>com.mysql.jdbc.Driver</value>  

 </property>  

 <property>  

 <name>javax.jdo.option.ConnectionUserName</name>  

 <value>root</value>  

 </property>  

 <property>  

 <name>javax.jdo.option.ConnectionPassword</name>  

 <value>root</value>  

 </property>  

 <!-- 解决 Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"  -->  

 <property>  

 <name>datanucleus.autoCreateSchema</name>  

 <value>true</value>  

 </property>  

 <property>  

 <name>datanucleus.autoCreateTables</name>  

 <value>true</value>  

 </property>  

 <property>  

 <name>datanucleus.autoCreateColumns</name>  

 <value>true</value>  

 </property>  

 <!-- 解决 Caused by: MetaException(message:Version information not found in metastore. )  -->  

 <property>    

 <name>hive.metastore.schema.verification</name>    

 <value>false</value>    

 <description>    

     Enforce metastore schema version consistency.    

     True: Verify that version information stored in metastore matches with one from Hive jars.  Also disable automatic    

           schema migration attempt. Users are required to manully migrate schema after Hive upgrade which ensures    

           proper metastore schema migration. (Default)    

     False: Warn if the version information stored in metastore doesn't match with one from in Hive jars.    

 </description>    

 </property>