linux下HIVE/beeline客户端的安装和启动

linux下HIVE/beeline客户端的安装和启动
1.首先安装mysql;(推荐远程安装)
#安装mysql
yum install mysql mysql-server mysql-devel

/etc/init.d/mysqld start 首次启动

mysql 启动mysql进入控制台

mysql>; USE mysql;
mysql>; UPDATE user SET Password=PASSWORD(‘hadoop’) WHERE user=‘root’;
mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘hadoop’ WITH GRANT OPTION;
mysql>; FLUSH PRIVILEGES;

把mysql设置为开机自启动
chkconfig mysqld on

2.单独配置启动metastore服务 全局唯一
具体搭建:
vim $hive_home/conf/hive-env.sh
export HADOOP_HOME=/export/servers/hadoop-2.6.0-cdh5.14.0

vim $hive_home/conf/hive-site.xml


javax.jdo.option.ConnectionURL
jdbc:mysql://bigdata01:3306/hive?createDatabaseIfNotExist=true

<property>
	<name>javax.jdo.option.ConnectionDriverName</name>
	<value>com.mysql.jdbc.Driver</value>
</property>

<propert