配置hive

来源：互联网发布：薛之谦的回应知乎编辑：程序博客网时间：2024/06/05 05:06

1.下载解压改名
https://mirrors.tuna.tsinghua.edu.cn/apache/hadoop/common/

2.改路径
export HADOOP_HOME=/home/leon/hadoop-1.2.1
export HIVE_HOME=/home/leon/hadoop-1.2.1/contrib/hive-1.2.1
export PATH=$PATH:$HIVE_HOME/bin:$HADOOP_HOME/bin
export CLASSPATH=$CLASSPATH:$HIVE_HOME/lib

3.改hive环境变量
hive安装路径/conf文件夹下，
cp hive-env.sh.template hive-env.sh

# Set HADOOP_HOME to point to a specific hadoop install directory
export HADOOP_HOME=/home/leon/hadoop-1.2.1(hadoop安装目录)
# Hive Configuration Directory can be controlled by:
export HIVE_CONF_DIR=/home/leon/hadoop-1.2.1/contrib/hive-1.2.1（hive安装目录）

让其马上生效
source /etc/profile

4.给hdfs上的tmp足够权限
hadoop fs -chmod -R 777 /tmp

/*这时候应该可以进hive了*/
在用户目录下直接输　hive

5.配置mysql(如果想将hive的元数据保存在mysql中)

mysql下新建一个hive用户，密码为hive 并给足权限
create user 'hive' IDENTIFIED BY 'hive';
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%' WITH GRANT OPTION;
flush privileges;

登录hive用户，新建database
create database hive

（不新建用户也行，在下面用root登录，密码也为root的密码）

6.配置hive中mysql设置
《hadoop实战》P221
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.53.94:3306/hive_db?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8</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>【用户名】</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>【密码】</value>
<description>password to use against metastore database</description>
</property>

7.将mysql-connector-java-5.1.30-bin.jar 放入 $HIVE_HOME/lib下
下载地址 http://dev.mysql.com/downloads/file/?id=465643

0 0