hive-1hive安装

本地

首先启动hadoop 集群

Node1:

#yum install mysql-server

# service mysqld start

# mysql

> show databases;

> use mysql

> show tables;

> select user ,host from user;

> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;

> select user ,host from user;

> delete from user where host != '%';

> select user ,host from user;

> flush privileges;

> quit

# mysql -u root –p

#123

> quit

上传hive 安装包

# cd /home/tools/

# tar -zxvf apache-hive-1.2.1-bin.tar.gz -C /home/

#  cd /home/

# mv apache-hive-1.2.1-bin hive-1.2.1

# cd hive-1.2.1/

# vim /etc/profile

export PATH=$PATH:$ZOOKEEPER_HOME/bin

export HIVE_HOME=/home/hive-1.2.1

# source /etc/profile

# cd conf

# mv hive-default.xml.template hive-site.xml

# vim hive-site.xml

之间的全删除  :.,$-1d

<property>

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

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

</property>

<property>

<name>hive.metastore.local</name>

<value>true</value>

</property>

<property>

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

<value>jdbc:mysql://localhost/hive?createDatabaseIfNotExist=true</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>123</value>

</property>

粘贴进去。

传人jar 包

# cd /home/hive-1.2.1/lib

# cp /home/tools/mysql-connector-java-5.1.32-bin.jar ./

#cd /home/hadoop-2.5.1/share/hadoop/yarn/lib

# cp /home/hive-1.2.1/lib/jline-2.12.jar ./

# rm -f jline-0.9.94.jar

# hive

> create table tbl(id int,name string);

> show tables;

> desc tbl;

> insert into tbl values (1,'zhangsan');

> quit;

 

远程服务器模式：

Rempte 分开

Node1 ：

# scp /home/tools/apache-hive-1.2.1-bin.tar.gz root@node2:/home/tools/

Node2 ：

# tar -zxvf /home/tools/apache-hive-1.2.1-bin.tar.gz -C /home/

# cd /home/

# mv apache-hive-1.2.1-bin/ hive-1.2.1

# vim /etc/profile

export HIVE_HOME=/home/hive-1.2.1

export PATH=$PATH:$HIVE_HOME/bin

# source /etc/profile

进入node1

# cd /home/hive-1.2.1/conf

# vim hive-site.xml

删除之间所有的

粘贴进去服务端：

<property>

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

<value>/user/hive2/warehouse</value>

</property>

<property>

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

<value>jdbc:mysql://node1:3306/hive2?createDatabaseIfNotExist=true</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>123</value>

</property>

 

进入node2

# cd /home/hive-1.2.1/conf

# mv hive-default.xml.template hive-site.xml

# vim hive-site.xml

删除之间所有的

粘贴客户端：

<property>

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

<value>/user/hive2/warehouse</value>

</property>

<property>

<name>hive.metastore.local</name>

<value>false</value>

</property>

<property>

<name>hive.metastore.uris</name>

<value>thrift://node1:9083</value>

</property>

 

传人jar 包

# cd /home/hive-1.2.1/lib

# cp /home/tools/mysql-connector-java-5.1.32-bin.jar ./

# cd /home/hadoop-2.5.1/share/hadoop/yarn/lib

# cp /home/hive-1.2.1/lib/jline-2.12.jar ./

# rm -f jline-0.9.94.jar

 

进入node1 ：

# hive --service metastore

( 这样启动不能关，这个问题要解决就后台启动吧 )

也可以后台启动：

# hive --service metastore &

 

进入node2 ：

# hive