hive启动远程模式命令即注意事项

在启动hive前&＃xff0c;一定在保证集群的mysql和Hadoop是启动成功的&＃xff0c;

Hadoop是存储实质数据&＃61;&＃61;
mysql是存储hive的元数据&＃xff08;映射关系数据&＃xff09;

Hadoop的启动命令&＃xff1a;start-all.sh Hadoop
进程名&＃xff1a;NameNode、DataNode
hadoop的关闭命令&＃xff1a;stop-all.sh

[root&＃64;node01 ~]# start-all.sh
This script is Deprecated. Instead use start-dfs.sh and start-yarn.sh
Starting namenodes on [node01]
node01: starting namenode, logging to /export/servers/hadoop-2.6.0-cdh5.14.0/logs/hadoop-root-namenode-node01.out
node01: starting datanode, logging to /export/servers/hadoop-2.6.0-cdh5.14.0/logs/hadoop-root-datanode-node01.out
node02: starting datanode, logging to /export/servers/hadoop-2.6.0-cdh5.14.0/logs/hadoop-root-datanode-node02.out
node03: starting datanode, logging to /export/servers/hadoop-2.6.0-cdh5.14.0/logs/hadoop-root-datanode-node03.out
Starting secondary namenodes [node02]
node02: starting secondarynamenode, logging to /export/servers/hadoop-2.6.0-cdh5.14.0/logs/hadoop-root-secondarynamenode-node02.out
starting yarn daemons
starting resourcemanager, logging to /export/servers/hadoop-2.6.0-cdh5.14.0/logs/yarn-root-resourcemanager-node01.out
node01: starting nodemanager, logging to /export/servers/hadoop-2.6.0-cdh5.14.0/logs/yarn-root-nodemanager-node01.out
node02: starting nodemanager, logging to /export/servers/hadoop-2.6.0-cdh5.14.0/logs/yarn-root-nodemanager-node02.out
node03: starting nodemanager, logging to /export/servers/hadoop-2.6.0-cdh5.14.0/logs/yarn-root-nodemanager-node03.out
[root&＃64;node01 ~]# jps
19504 DataNode
12002 RunJar
20085 Jps
19365 NameNode
9448 QuorumPeerMain
19865 NodeManager
11817 RunJar
2169 -- process information unavailable
19758 ResourceManager

在hadoop启动集群成功后&＃xff0c;HDFS会进入安全模式&＃xff0c;等安全模式结束后再开始启动hive

**

Mysql的启动命令&＃xff1a;mysql -u mysql_name(你的mysql的用户名&＃xff09; -p
按下回车执行后在输入你mysql的password

**

登录hadoop的web端查看是否退出安全模式&＃xff0c;
Hadoop的web端口号为&＃xff1a;50070**

此次启动的是hive远程模式 &＃xff0c;
第一代客户端&＃xff1a;后台挂起启动
nohup /export/servers/hive/bin/hive --service metastore &
nohup /export/servers/hive/bin/hive --service hiveserver2 &

客户端在那就执行这个启动代码&＃xff1a;/export/servers/hive/bin/beeline

&＃xff01; connect jdbc:hive2://node01:10000
…username…:mysql_name
…password…: 可以不用输入&＃xff0c;直接按回车即可

[root&＃64;node02 ~]# /export/servers/hive/bin/beeline
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/export/servers/hbase/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/export/servers/hadoop-2.6.0-cdh5.14.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.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.slf4j.impl.Log4jLoggerFactory]
Beeline version 1.1.0-cdh5.14.0 by Apache Hive
beeline> ! connect jdbc:hive2://node01:10000
scan complete in 2ms
Connecting to jdbc:hive2://node01:10000
Enter username for jdbc:hive2://node01:10000: root
Enter password for jdbc:hive2://node01:10000:
Connected to: Apache Hive (version 1.1.0-cdh5.14.0)
Driver: Hive JDBC (version 1.1.0-cdh5.14.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://node01:10000>

启动成功&＃xff0c;可以直接操作业务了