Hive的安装(常用的是独立模式安装)
<property> <name>hive.metastore.local</name> <value>true</value> <description>controls whether to connect to remove metastore server or open a new metastore server in Hive Client JVM</description></property> <property> <name>javax.jdo.option.ConnectionURL</name> <!--Hive连接数据库的URL--> <value>jdbs:mysql:192.168.10.241:3306/hive>createDatabaseIfNotExist=true</value> <description>JDBC connect string for a JDBC metastore</description></property> <property> <name>javax.jdo.option.ConnectionDriverName</name><!--Hive连接数据库的驱动名--> <value>com.mysql.jdbc.Driver</value> <description>Driver class name for a JDBC metastore</description></property> <property> <name>javax.jdo.option.ConnectionUserName</name><!--Hive连接数据库的username--> <value>root</value> <description>username to use against metastore database</description></property> <property> <name>javax.jdo.option.ConnectionPassword</name><!--Hive连接数据库的password--> <value>123456</value> <description>password to use against metastore database</description></property> <property> <name>hive.metastore.warehouse.dir</name><!--Hive在HDFS上的数据存储目录--> <value>/hive/warehouse</value> <description>the hive data save localtion with hdfs</description></property> <property> <name>hive.exec.scratchdir</name> <!--Hive的数据临时文件目录--> <value>/tmp/hive-asheng</value> <description>the hive data tmp save localtion</description></property>
<6>把mysql的jdbc驱动包放到Hive/lib下
<7>启动Hive
启动hive shell:?
? ? ? ? ? ?hive目录下执行命令bin/hive
? ? ? ? ? ?执行命令show tables?
如果不报错 则安装成功 ?那么进入Hive的新建表则可以在mysql的Hive的数据库中看到相应的元数据信息啦~
3.远程模式安装
远程模式安装是把metastore配置到远程的机器上,可以配置多个,在独立模式的基础上需要在hive-site.xml中增加配置信息
<!--用于远程模式安装的附加信息-->
? ? ? ?
<property> <name>hive.metastore.local</name> <value>false</value> <description>controls whether to connect to remove metastore server or open a new metastore server in Hive Client JVM</description></property> <property> <name>hive.metastore.uris</name> <value>uri1,uri2</value><!--可以配置多个uri,他们之间用分号隔开即可--> <description>JDBC connect string for a JDBC metastore</description></property>
?