hive安装

冷不防 2021-09-29 20:08 449阅读 0赞

hive安装

hive hadoop 安装 配置

1.  安装文件

上传文件apache-hive-2.3.3-bin.tar.gz到/opt/hadoop下

解压

tar -xzvf apache-hive-2.3.3-bin.tar.gz

[![1540305751435][]][1540305751435 1]

1.  设置环境变量

vi /etc/profile

export HIVE\_HOME=/opt/hadoop/apache-hive-2.3.3-bin

export PATH=$PATH:$HIVE\_HOME/bin

[![1540306330915][]][1540306330915 1]

enter description here

查看hive版本

hive --version

[![1540306497776][]][1540306497776 1]

1.  修改配置文件

修改hive-site.xml文件

cd /opt/hadoop/apache-hive-2.3.3-bin/conf

cp hive-default.xml.template hive-site.xml

vi hive-site.xml

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

<description>Username to use against metastore database</description>

</property>

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

<description>password to use against metastore database</description>

</property>

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

<value>jdbc:mysql://172.18.12.2:3306/hive</value>

</property>

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

<value>com.mysql.jdbc.Driver</value>

<description>Driver class name for a JDBC metastore</description>

</property>

修改hive-env.sh文件

cp hive-env.sh.template hive-env.sh

vi hive-env.sh

HADOOP\_HOME=/opt/hadoop/hadoop-2.8.5

1.  连接mysql

复制mysql的驱动程序到hive/lib下面

创建mysql的元数据库

schematool -dbType mysql -initSchema

[![1540308528619][]][1540308528619 1]

hadoop fs -mkdir /user/hive

hadoop fs -chown hive:hadoop /user/hive

启动hvie

运行hive之前首先要确保meta store服务已经启动，

nohup hive --service metastore > metastore.log 2>&1 &

启动hive service

nohup hive --service hiveserver2 > hiveserver2.log 2>&1 &

hive

[![1540311014569][]][1540311014569 1]

通过beeline连接

beeline -u jdbc:hive2://172.18.12.1:10000/default -n hive

[![1540312311398][]][1540312311398 1]

访问web

[http://172.18.12.1:10002/][http_172.18.12.1_10002]

[![1540472711497][]][1540472711497 1]

1.  报错处理

Exception in thread "main" java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: $\{system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D

解决方案：将hive-site.xml配置文件的

hive.querylog.location

hive.exec.local.scratchdir

hive.downloaded.resources.dir

三个值（原始为$标识的相对路径）写成绝对值/var/log/hadoop/hive

User: hive is not allowed to impersonate hive (state=08S01,code=0)

[![1540311587546][]][1540311587546 1]

enter description here

解决方案：

修改core-site.xml文件

<name>hadoop.tmp.dir</name>

<value>/u01/hadoop/tmp</value>

<description>Abase for other temporary directories.</description>

</property>

<name>hadoop.proxyuser.hive.hosts</name>

</property>

<name>hadoop.proxyuser.hive.groups</name>

</property>

转载于:https://www.cnblogs.com/brock0624/p/9852934.html

[1540305751435]: /images/20210725/cf574eb44de947e1be545ee85912bc21.png
[1540305751435 1]: https://img2018.cnblogs.com/blog/1511013/201810/1511013-20181025211020514-214961229.png
[1540306330915]: /images/20210725/272a787b5b714f858a04693f9a477e16.png
[1540306330915 1]: https://img2018.cnblogs.com/blog/1511013/201810/1511013-20181025211021954-1777672203.png
[1540306497776]: /images/20210725/a9494714ccb248feb9eab6946777694b.png
[1540306497776 1]: https://img2018.cnblogs.com/blog/1511013/201810/1511013-20181025211023588-1923888359.png
[1540308528619]: /images/20210725/600d6ea7f91d4b5ba9780e8a4eab3666.png
[1540308528619 1]: https://img2018.cnblogs.com/blog/1511013/201810/1511013-20181025211024765-1586934039.png
[1540311014569]: /images/20210725/d2cfde625b0d431a96502500c3f7bf7e.png
[1540311014569 1]: https://img2018.cnblogs.com/blog/1511013/201810/1511013-20181025211026216-1573583555.png
[1540312311398]: /images/20210725/b78009e157d1429c8321c47bf517aad6.png
[1540312311398 1]: https://img2018.cnblogs.com/blog/1511013/201810/1511013-20181025211028891-1775301929.png
[http_172.18.12.1_10002]: http://172.18.12.1:10002/
[1540472711497]: /images/20210725/16ede68c9c044baca22b8fc76350e430.png
[1540472711497 1]: https://img2018.cnblogs.com/blog/1511013/201810/1511013-20181025211030883-29652554.png
[1540311587546]: /images/20210725/a681acb6739c403f95fe896c03c09365.png
[1540311587546 1]: https://img2018.cnblogs.com/blog/1511013/201810/1511013-20181025211033185-1714028036.png