hive运行异常

li_shiye 2017-03-01 06:33:15
hive> show databases;
OK
default
Time taken: 5.421 seconds, Fetched: 1 row(s)
hive> describe database default;
OK
default Default Hive database hdfs://master:9000/user/hive/warehouse public ROLE
Time taken: 0.449 seconds, Fetched: 1 row(s)
hive> create table harea (id int,area string) row format delimited fields terminated by '|' stored as textfile;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Could not connect to meta store using any of the URIs provided. Most recent failure: org.apache.thrift.transport.TTransportException: java.net.ConnectException: 拒绝连接 (Connection refused)
at org.apache.thrift.transport.TSocket.open(TSocket.java:226)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:452)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.reconnect(HiveMetaStoreClient.java:347)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:148)

hive启动正常,执行创建表时却报错了,有谁遇到过这类问题,请不吝赐教,网上找个各种方法也没解决!

下面是服务运行情况:
[root@master ~]# jps
1760 SecondaryNameNode
1921 ResourceManager
2561 HQuorumPeer
2625 HMaster
1474 NameNode
2025 NodeManager
2761 HRegionServer
19833 RunJar
20201 Jps

---xml配置情况
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
<description>Username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
<description>password to use against metastore database</description>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
<description>location of default database for the warehouse</description>
</property>

----mysql里的用户
hive 登录也正常
+-----------+-----------+
| user | host |
+-----------+-----------+
| hive | % |
| root | % |
| mysql.sys | localhost |
| root | localhost |
| hive | master |
+-----------+-----------+
...全文
661 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

7,388

社区成员

发帖
与我相关
我的任务
社区描述
其他数据库开发 数据仓库
社区管理员
  • 数据仓库
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧