【大数据入门实战】hive入门搭建环境

http://hive.apache.org/官方地址

https://github.com/apache/hive 

http://archive.cloudera.com/cdh5/cdh/5/hive-1.1.0-cdh5.7.0.tar.gz

1:解压hive
[hadoop@localhost app]$ tar -zxvf hive-1.1.0-cdh5.7.0.tar.gz 

2:将hive bin 命令添加到环境变量
[hadoop@localhost bin]$ vi ~/.bash_profile 

export HIVE_HOME=/home/hadoop/app/hive-1.1.0-cdh5.7.0
export PATH=$HIVE_HOME/bin:$PATH
PATH=$PATH:$HOME/bin

export PATH

3:
[hadoop@localhost hive-1.1.0-cdh5.7.0]$ hive
Cannot find hadoop installation: $HADOOP_HOME or $HADOOP_PREFIX must be set or hadoop must be in the path

4:
export MYSQL_HOME=/usr/local/mysql
export PATH=${MYSQL_HOME}/bin:$PATH

export HADOOP_HOME=/home/hadoop/app/hadoop-2.6.0-cdh5.7.0
export PATH=$HADOOP_HOME:$PATH

export HIVE_HOME=/home/hadoop/app/hive-1.1.0-cdh5.7.0
export PATH=$HIVE_HOME/bin:$PATH
PATH=$PATH:$HOME/bin

export PATH

1:下载mysql 驱动
wget https://downloads.mysql.com/archives/get/file/mysql-connector-java-5.1.27.tar.gz

2:
[hadoop@localhost conf]$ vi hive-site.xml

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://localhost:3306/ruoze_d6?createDatabaseIfNotExist=true&amp;characterEncoding=UTF-8</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>root</value>
</property>
</configuration>