-
Notifications
You must be signed in to change notification settings - Fork 25
Description
hi @lucasbak
I tried to enable LLAP for Hive from Ambari, and although Ambari shows it as activated after applying the changes, no hosts appear under the Interactive Query service.
Ambari version: 1.4.6 on RHEL 9
ODP version: ODP‑1.3.1.0 with JDK 17
ranger and kerberos and ssl not configured .
The image below shows that LLAP is enabled.

and It shows that nothing has changed.
hive log
[hdfs@m1 hive]$ hive
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/odp/1.3.1.0-174/hive/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/odp/1.3.1.0-174/hadoop/lib/slf4j-reload4j-1.7.36.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.apache.logging.slf4j.Log4jLoggerFactory]
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/odp/1.3.1.0-174/hive/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/odp/1.3.1.0-174/hadoop/lib/slf4j-reload4j-1.7.36.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.apache.logging.slf4j.Log4jLoggerFactory]
Connecting to jdbc:hive2://m1.bigdata.local:2181,m2.bigdata.local:2181,m3.bigdata.local:2181/default;password=hdfs;serviceDiscoveryMode=zooKeeper;user=hdfs;zooKeeperNamespace=hiveserver2
25/11/22 14:02:02 [main-SendThread(m2.bigdata.local:2181)]: WARN zookeeper.ClientCnxn: Session 0x0 for server m2.bigdata.local/192.168.25.48:2181, Closing socket connection. Attempting reconnect except it is a SessionExpiredException or SessionTimeoutException.
java.net.NoRouteToHostException: No route to host
at sun.nio.ch.Net.pollConnect(Native Method) ~[?:?]
at sun.nio.ch.Net.pollConnectNow(Net.java:672) ~[?:?]
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:946) ~[?:?]
at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:344) ~[zookeeper-3.9.3.1.3.1.0-174.jar:3.9.3.1.3.1.0-174]
at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1291) ~[zookeeper-3.9.3.1.3.1.0-174.jar:3.9.3.1.3.1.0-174]
25/11/22 14:02:02 [main]: INFO jdbc.ZooKeeperHiveClientHelper: Discovered HiveServer2 hosts in ZooKeeper [/hiveserver2]: [serverUri=m1.bigdata.local:10000;version=4.0.1.1.3.1.0-174;sequence=0000000009]
25/11/22 14:02:03 [main]: INFO jdbc.HiveConnection: Connected to m1.bigdata.local:10000
Connected to: Apache Hive (version 4.0.1.1.3.1.0-174)
Driver: Hive JDBC (version 4.0.1.1.3.1.0-174)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 4.0.1.1.3.1.0-174 by Apache Hive
0: jdbc:hive2://m1.bigdata.local:2181,m2.bigd> set hive.execution.engine;
+----------------------------+
| set |
+----------------------------+
| hive.execution.engine=tez |
+----------------------------+
1 row selected (0.037 seconds)
0: jdbc:hive2://m1.bigdata.local:2181,m2.bigd> Closing: 0: jdbc:hive2://m1.bigdata.local:2181,m2.bigdata.local:2181,m3.bigdata.local:2181/default;password=hdfs;serviceDiscoveryMode=zooKeeper;user=hdfs;zooKeeperNamespace=hiveserver2
[hdfs@m1 hive]$