执行hive> show databases;报错:FAILED: HiveException java.lang.RuntimeException

执行hive> show databases;报错:FAILED: HiveException java.lang.RuntimeException,第1张

执行hive> show databases;报错:FAILED: HiveException java.lang.RuntimeException

错误信息如下:

hive> show databases;
FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHivemetaStoreClient

解决方法:

执行命令:./hive --service metastore &

[sonkwo@sonkwo-bj-data001 bin]$ ./hive --service metastore &

重新启动hive问题解决

[sonkwo@sonkwo-bj-data001 bin]$  ./hive
which: no hbase in (/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/module/jdk1.8.0_212/bin:/opt/module/ha/hadoop-3.1.3/bin:/opt/module/ha/hadoop-3.1.3/sbin:/opt/module/zookeeper-3.5.7/bin:/opt/module/hive-3.1.2/bin:/home/sonkwo/.local/bin:/home/sonkwo/bin)
Hive Session ID = e30c7d1f-c2b7-403d-9f38-caaf1466244e

Logging initialized using configuration in jar:file:/opt/module/hive-3.1.2/lib/hive-common-3.1.2.jar!/hive-log4j2.properties Async: true
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
Hive Session ID = 0844fb27-583d-4d85-81a8-29042a6682c2
hive> show databases;
OK
default
Time taken: 0.784 seconds, Fetched: 1 row(s)
hive>

欢迎分享,转载请注明来源:内存溢出

原文地址:https://www.54852.com/zaji/5679151.html

(0)
打赏 微信扫一扫微信扫一扫 支付宝扫一扫支付宝扫一扫
上一篇 2022-12-17
下一篇2022-12-17

发表评论

登录后才能评论

评论列表(0条)

    保存