博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
hive_hiveserver2 hive-site.xml config and start
阅读量:4914 次
发布时间:2019-06-11

本文共 4850 字,大约阅读时间需要 16 分钟。

hive-site.xml

# vi hive-site.xml 
javax.jdo.option.ConnectionURL
jdbc:mysql://sd-9c1f-2eac:3306/hive?createDatabaseIfNotExist=true
javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
Driver class name for a JDBC metastore
javax.jdo.option.ConnectionUserName
hive
username to use against metastore database
javax.jdo.option.ConnectionPassword
hive
password to use against metastore database
hive.hwi.listen.host
0.0.0.0
This is the host address the Hive Web Interface will listen on
hive.hwi.listen.port
9999
This is the port the Hive Web Interface will listen on
hive.hwi.war.file
lib/hive-hwi-2.1.1.war
This is the WAR file with the jsp content for Hive Web Interface
hive.exec.local.scratchdir
/home/hadoop/iotmp
Local scratch space for Hive jobs
hive.downloaded.resources.dir
/home/hadoop/iotmp
Temporary local directory for added resources in the remote file system.
hive.server2.transport.mode
binary
hive.server2.thrift.http.port
10001
hive.server2.thrift.http.max.worker.threads
500
hive.server2.thrift.http.min.worker.threads
5
hive.server2.thrift.http.path
cliservice
hive.server2.thrift.min.worker.threads
5
hive.server2.thrift.max.worker.threads
500
hive.server2.thrift.port
10000
hive.server2.thrift.bind.host
sd-9c1f-2eac
hive.server2.authentication
NONE
View Code

启动mysql

[Dev root @ sd-9c1f-2eac /usr/local/src/apache-hive-2.1.1-bin/conf]# service mysql startStarting MySQL...

启动hiveserver2

# hive --service metastore &# hive --service hiveserver2 &

hiveserver2 连接 mysql

[Dev root @ sd-9c1f-2eac /usr/local/src/apache-hive-2.1.1-bin]# $HIVE_HOME/bin/beeline  -u jdbc:hive2://localhost:10000
which: no hbase in (/usr/lib64/qt-3.3/bin:/usr/local/sbin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:/usr/local/src/jdk1.8.0_112/bin:/usr/local/src/hadoop-2.7.3/bin:/usr/local/src/apache-hive-2.1.1-bin/bin:/home/pl62716/spark-2.1.0-bin-hadoop2.6/bin:/home/pl62716/apache-maven-3.3.9/bin://home/pl62716/sbt-launcher-packaging-0.13.13/bin:/root/bin)SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/usr/local/src/apache-hive-2.1.1-bin/lib/hive-jdbc-2.1.1-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/usr/local/src/apache-hive-2.1.1-bin/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/usr/local/src/hadoop-2.7.3/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]Connecting to jdbc:hive2://localhost:10000Connected to: Apache Hive (version 2.1.1)Driver: Hive JDBC (version 2.1.1)17/05/08 03:38:46 [main]: WARN jdbc.HiveConnection: Request to set autoCommit to false; Hive does not support autoCommit=false.Transaction isolation: TRANSACTION_REPEATABLE_READBeeline version 2.1.1 by Apache Hive0: jdbc:hive2://localhost:10000>
View Code

转载于:https://www.cnblogs.com/liupuLearning/p/6814037.html

你可能感兴趣的文章
5.9 容器
查看>>
创建oracle数据库的表空间、用户、目录、导入\导出文件等信息
查看>>
php禁止浏览器使用缓存页面的方法
查看>>
django的模型类管理器-----------数据库操作的封装
查看>>
java 回调
查看>>
CF1100E Andrew and Taxi 二分答案+拓扑排序
查看>>
子弹朝向问题的解决,移动方法的编写
查看>>
$("#id a") - $("#id .c a") = ?
查看>>
题目1034:寻找大富翁---用了sort()函数,注意头文件;
查看>>
Windows下Wamp装不上Memcache扩展
查看>>
js中数组的map()方法
查看>>
wpa破解学习实践
查看>>
USACO 2008 FEB Eating Together
查看>>
5月13 jquery的一些应用
查看>>
mysql命令行如何得到表结构
查看>>
有效的更改IE、Firefox、Chrome浏览器缓存位置的方法
查看>>
SQL*Plus 系统变量之7 - BLO[CKTERMINATOR]
查看>>
MATLAB 统计数据并画出统计直方图
查看>>
TTTTTTTTTTTTTTTTT CF #182 div1 B floyd
查看>>
adbi命令【转】
查看>>