hive启动问题,hiveserver2一直不启动

Question

2015-09-22 16:50:55,690 INFO [main]: metastore.ObjectStore (ObjectStore.java:setConf(272)) - Initialized ObjectStore
2015-09-22 16:50:55,691 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(746)) - 0: get_databases: default
2015-09-22 16:50:55,691 INFO [main]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(371)) - ugi=hadoop ip=unknown-ip-addr cmd=get_databases: default

2015-09-22 16:50:55,701 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(746)) - 0: Shutting down the object store...
2015-09-22 16:50:55,702 INFO [main]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(371)) - ugi=hadoop ip=unknown-ip-addr cmd=Shutting down the object store...

2015-09-22 16:50:55,703 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(746)) - 0: Metastore shutdown complete.
2015-09-22 16:50:55,703 INFO [main]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(371)) - ugi=hadoop ip=unknown-ip-addr cmd=Metastore shutdown complete.

2015-09-22 16:50:55,703 INFO [main]: service.AbstractService (AbstractService.java:start(104)) - Service:ThriftBinaryCLIService is started.
2015-09-22 16:50:55,704 INFO [main]: service.AbstractService (AbstractService.java:start(104)) - Service:HiveServer2 is started.
2015-09-22 16:50:55,793 INFO [Thread-11]: thrift.ThriftCLIService (ThriftBinaryCLIService.java:run(98)) - Starting ThriftBinaryCLIService on port 10000 with 5...500 worker threads

hiveserver2一直卡在启动ThriftBinaryCLIService是为什么?配置文件改了bind.host

Answer 1

这个表示hiveserver2已经启动了，再开一个窗口直接用beeline连接hive就行了
bin/beeline
beeline> !connect jdbc:hive2://hadoop102:10000（回车）
Connecting to jdbc:hive2://hadoop102:10000
Enter username for jdbc:hive2://hadoop102:10000: atguigu（回车）
Enter password for jdbc:hive2://hadoop102:10000: （直接回车）
Connected to: Apache Hive (version 1.2.1)
Driver: Hive JDBC (version 1.2.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://hadoop102:10000> show databases;
+----------------+--+
| database_name |
+----------------+--+
| default |
| hive_db2 |
+----------------+--+

如果主机地址、端口号、用户名、密码都没有写错的话，就可以连接上

如果报连接不上端口，没有权限之类的
需要在hadoop 的 core.site.xml 添加以下配置

hadoop.proxyuser.root.hosts



hadoop.proxyuser.root.groups

也可能的hadoop hdfs 上的tmp文件夹 和 存储hive元数据的文件夹，权限太小了，把权限放大就行
bin/hadoop fs -mkdir /tmp
bin/hadoop fs -mkdir -p /user/hive/warehouse
bin/hadoop fs -chmod g+w /tmp
bin/hadoop fs -chmod g+w /user/hive/warehouse 这个是存hive元数据的目录，配置在hive的hive.site.xml文件，你的可能不是这个目录