CDH的节点执行hive命令,有些节点只能看到default库
[root@wjltony ~]# hive
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated and will likely be removed in a future release
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
Logging initialized using configuration in jar:file:/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.14.2.p0.3/jars/hive-common-1.1.0-cdh5.14.2.jar!/hive-log4j.properties
WARNING: Hive CLI is deprecated and migration to Beeline is recommended.
hive> show databases;
OK
default
Time taken: 6.438 seconds, Fetched: 1 row(s)
hive>
实际上我是已经建了库表的,且在其他节点上是能看到的
经过排查后发现是/etc/hive/conf/hive-site.xml文件的配置不一致所致
解决方法:将正常节点的hive-site.xml替换后恢复正常
hive> show databases;
OK
default
network
Time taken: 1.87 seconds, Fetched: 2 row(s)
hive>