Hive installation
来源:互联网 发布:linux删除文件恢复 编辑:程序博客网 时间:2024/05/17 03:35
目标:用mysql作为hive的metastore存储;
版本:hive-1.0.0;
环境:hadoop-2.4.1;
1、安装mysql
#query all
rpm -qa | grep mysql
# remove mysql with no dependency
rpm -e mysql-libs-5.1.66-2.el6_3.i686 --nodeps
#install
rpm -ivh MySQL-server-5.1.73-1.glibc23.i386.rpm
rpm -ivh MySQL-client-5.1.73-1.glibc23.i386.rpm
#start/stop mysql
service mysql start
service mysql stop
#mysql setup
/usr/bin/mysql_secure_installation
#login
mysql -uroot -p123
#连接权限设置 *.*:所有库下的所有表;%:任何IP地址或主机都可以连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
FLUSH PRIVILEGES;
2、配置hive
2.1、解压hive.tar.gz
2.2、cp hive-default.xml.template hive-site.xml
修改hive-site.xml
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://node04:3306/hive?createDatabaseIfNotExist=true</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>123</value>
<description>password to use against metastore database</description>
</property>
</configuration>
版本:hive-1.0.0;
环境:hadoop-2.4.1;
1、安装mysql
#query all
rpm -qa | grep mysql
# remove mysql with no dependency
rpm -e mysql-libs-5.1.66-2.el6_3.i686 --nodeps
#install
rpm -ivh MySQL-server-5.1.73-1.glibc23.i386.rpm
rpm -ivh MySQL-client-5.1.73-1.glibc23.i386.rpm
#start/stop mysql
service mysql start
service mysql stop
#mysql setup
/usr/bin/mysql_secure_installation
#login
mysql -uroot -p123
#连接权限设置 *.*:所有库下的所有表;%:任何IP地址或主机都可以连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
FLUSH PRIVILEGES;
2、配置hive
2.1、解压hive.tar.gz
2.2、cp hive-default.xml.template hive-site.xml
修改hive-site.xml
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://node04:3306/hive?createDatabaseIfNotExist=true</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>123</value>
<description>password to use against metastore database</description>
</property>
</configuration>
2.3 用./hadoop-2.4.1/share/hadoop/yarn/lib/jline-0.9.94.jar 替换hive原有的jline.jar
3、./apache-hive-1.0.0-bin/bin/hive 就可打开hive client
0 0
- Hive installation
- HIVE INSTALLATION
- Apache Hive Installation
- Hive学习5_Hive - Installation
- Hadoop and Spark and Hive Installation
- Hive----------Cannot find hadoop installation: $HADOOP_HOME m...
- 解决Hive installation issues: Hive metastore database is not initialized
- 解决Hive installation issues: Hive metastore database is not initialized
- Hive
- HIVE
- Hive
- hive
- hive
- hive
- hive
- hive
- Hive
- hive
- java-web 之 第一讲 xml 文件
- 2015年代理保健食品经营许可证
- BUAAoj 上面一道排序再单调栈
- 构建乘积数组
- iOS 8中的TestFlight简介
- Hive installation
- Jquery
- 严重: StandardServer.await: create[8005]:
- iOS 开发中的争议(一)类的成员变量应该如何定义?
- 东京区域赛
- 按位异或交换两个变量时的一个陷阱
- 将Android源代码导入Intellij IDEA
- MSCOMM32控件注册的两种办法
- iOS 开发中的争议(二)UI到底应该用xib/storyboard完成,还是用手写代码来完成?