educoder平台Hive的安装与配置.doc

《educoder平台Hive的安装与配置.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、第一关Hive的安装与配置cd/opt回车tar-zxvfapache-hive-3.1.0-bin.tar.gz回车mvapache-hive-3.1.0-binhive回车vi/etc/profile按i在末尾添加以下两行代码；exportHIVE_HOME=/opt/hiveexportPATH=$HIVE_HOME/bin:$PATH退出wqsource/etc/profile回车hive--version回车rm/opt/hive/lib/log4j-slf4j-impl-2.10.0.

2、jar回车hive--version回车tar-zxvfmysql-connector-java-5.1.45.tar.gz回车cdmysql-connector-java-5.1.45回车cpmysql-connector-java-5.1.45-bin.jar/opt/hive/lib/回车mysql-uroot-p123123-h127.0.0.1回车createdatabasehiveDB;回车createuser'bee'@'%'identifiedby'123123';回车granta

3、llprivilegesonhiveDB.*to'bee'@'%'identifiedby'123123';回车flushprivileges;回车exit回车cd/opt回车cd/opt/hive/conf回车vihive-site.xml回车将以下内容复制到其中（按i进入编辑模式后再进行粘贴）

4、xsl"?>

5、erty>hive.metastore.warehouse.dir/opt/hive/warehousehive.exec.scratchdir/opt/hive/tmphive.querylog.location/opt/hive/logs

6、operty>hive.server2.thrift.port10000hive.server2.thrift.bind.hostlocalhosthive.server2.enable.doAstrue

7、roperty>hive.session.idfalsehive.session.silentfalsejavax.jdo.option.ConnectionURLjdbc:mysql://localhost:3306/hiveDB?createDatabaseIf

8、NotExist=truejavax.jdo.option.ConnectionDriverNamecom.mysql.jdbc.Driverjavax.jdo.option.ConnectionUserNamebee