虚拟机下安装hive

最新推荐文章于 2024-06-12 14:40:30 发布

原创最新推荐文章于 2024-06-12 14:40:30 发布 · 1.7k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#hive #hadoop #mysql

部署运行你感兴趣的模型镜像

1.前置安装hadoop 以及 zookeeper(这里安装了hadoop2.6.0及zookeeper3.4.6)
2.安装mysql数据库
3.需要压缩包hive-1.1.0-cdh5.14.2.tar.gz以及mysql-connector-java-5.1.32

拷贝mysql驱动到hive/lib下

cp mysql-connector-java-5.1.32 /opt/software/hadoop/hive110/lib

解压缩，重命名，授权

tar -zxvf hive-1.1.0-cdh5.14.2.tar.gz -C /opt/software/hadoop/
mv  hive-1.1.0-cdh5.14.2.tar hive110
chown -R root:root hive110/

设置配置文件
/opt/software/hadoop/hive110/conf下 vi hive-site.xml（没有，需要自己新建）

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/opt/software/hadoop/hive110/warehouse</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.181.128:3306/hive110?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>root</value>
</property>
<property>
        <name>hive.metastore.schema.verification</name>
        <value>false</value>
</property>

<property>
<name>hive.server2.authentication</name>
<value>NONE</value>
</property>
<property>
        <name>hive.server2.thrift.client.user</name>
        <value>root</value>
</property>
<property>
<name>hive.server2.thrift.client.password</name>
        <value>root</value>
</property>
</configuration>

配置环境变量：vi etc/profile

#HIVE
export HIVE_HOME=/opt/soft/hive110
export PATH=$HIVE_HOME/bin:$PATH

激活source /etc/profile

按顺序启动服务（hadoop–>zookeeper–>hive）：
start-all.sh
zkServer.sh start
nohup hive --service metastore>/dev/null 2>&1 &
nohup hive --service hiveserver2>/dev/null 2>&1 &
在这里插入图片描述
[root@single bin]# ./beeline -u jdbc:hive2://single:10000
报错：Error: Failed to open new session: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.security.AccessControlException: Permission denied: user=anonymous, access=EXECUTE, inode="/tmp":root:supergroup:drwxrwx–