Win7安装Hive

一直用Win7最近需要学习Hadoop相关框架，在windows下安装了hadoop,hbase.hive 等工具，请浏览我blog吧.

Hive版本：2.1.1

Hadoop 版本:2.5.2

元数据存储在mysql，版本：5.6.23

hive的hive-site.xml内容如下：

<configuration>

	<!-- WARNING!!! This file is provided for documentation purposes ONLY!     -->
	<!-- WARNING!!! Any changes you make to this file will be ignored by Hive. -->
	<!-- WARNING!!! You must make your changes in hive-site.xml instead.       -->

	<!-- config mysql connection -->
	<property>
		<name>javax.jdo.option.ConnectionURL</name>
		<value>jdbc:mysql://127.0.0.1:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value>
		<description>JDBC connect string for a JDBC metastore</description>
	</property>

	<property>
		<name>javax.jdo.option.ConnectionDriverName</name>
		<value>com.mysql.jdbc.Driver</value>
		<description>Driver class name for a JDBC metastore</description>
	</property>

	<property>
		<name>javax.jdo.option.ConnectionUserName</name>
		<value>root</value>
		<description>username to use against metastore database</description>
	</property>

	<property>
		<name>javax.jdo.option.ConnectionPassword</name>
		<value>root</value>
		<description>password to use against metastore database</description>
	</property>
	<property>
		<name>hive.metastore.schema.verification</name>
		<value>false</value>
	</property>



	<property>
		<name>javax.jdo.option.DetachAllOnCommit</name>
		<value>true</value>
		<description>detaches all objects from session so that they can be used after transaction is committed</description>
	</property>

	<property>
		<name>javax.jdo.option.NonTransactionalRead</name>
		<value>true</value>
		<description>reads outside of transactions</description>
	</property>

 	<property>
        <name>datanucleus.readOnlyDatastore</name>
        <value>false</value>
    </property>
    <property> 
        <name>datanucleus.fixedDatastore</name>
        <value>false</value> 
    </property>

    <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>
    

</configuration>

运行hive --service metastore

成功，mysql的hive库生成相应的表：

win7安装hive参考了：

https://blog.csdn.net/yingxiake/article/details/51656970

http://doudouclever.blog.163.com/blog/static/1751123102013922222513970/

https://blog.csdn.net/m0_37324825/article/details/80185448

https://blog.csdn.net/beidiqiuren/article/details/51274318

https://blog.csdn.net/vipyeshuai/article/details/50847281 详细讲晰hbase与hive 区别

https://ifnoelse.gitbooks.io/learning-hive/content/hive_express/first_hive_app.html 最佳入门例子

等文章