Error message, as per log form hive server docker container
I am not sure how this is showing, “hive.jdbc.client.authentication”, I do not
have this in hive-site.xml.
2024-07-15T23:14:49,022 ERROR [HiveServer2-Handler-Pool: Thread-78]
thrift.ThriftCLIService: Login attempt failed for user : <<ms_id>>
org.apache.hive.service.cli.HiveSQLException: Failed to open new session:
java.lang.IllegalArgumentException: hive configuration
hive.jdbc.client.authentication does not exists.
at
org.apache.hive.service.cli.session.SessionManager.createSession(SessionManager.java:494)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.hive.service.cli.session.SessionManager.openSession(SessionManager.java:425)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.hive.service.cli.CLIService.openSession(CLIService.java:191)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.hive.service.cli.thrift.ThriftCLIService.getSessionHandle(ThriftCLIService.java:565)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.hive.service.cli.thrift.ThriftCLIService.OpenSession(ThriftCLIService.java:406)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1595)
~[hive-exec-4.0.0.jar:4.0.0]
at
org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1575)
~[hive-exec-4.0.0.jar:4.0.0]
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
~[hive-exec-4.0.0.jar:4.0.0]
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38)
~[hive-exec-4.0.0.jar:4.0.0]
at
org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:250)
~[hive-exec-4.0.0.jar:4.0.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
~[?:?]
at java.lang.Thread.run(Unknown Source) ~[?:?]
Caused by: org.apache.hive.service.cli.HiveSQLException:
java.lang.IllegalArgumentException: hive configuration
hive.jdbc.client.authentication does not exists.
at
org.apache.hive.service.cli.session.HiveSessionImpl.configureSession(HiveSessionImpl.java:286)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.hive.service.cli.session.HiveSessionImpl.open(HiveSessionImpl.java:198)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.hive.service.cli.session.SessionManager.createSession(SessionManager.java:485)
~[hive-service-4.0.0.jar:4.0.0]
... 13 more
Caused by: java.lang.IllegalArgumentException: hive configuration
hive.jdbc.client.authentication does not exists.
at
org.apache.hadoop.hive.ql.processors.SetProcessor.setConf(SetProcessor.java:255)
~[hive-exec-4.0.0.jar:4.0.0]
at
org.apache.hadoop.hive.ql.processors.SetProcessor.setConf(SetProcessor.java:221)
~[hive-exec-4.0.0.jar:4.0.0]
at
org.apache.hadoop.hive.ql.processors.SetProcessor.setVariable(SetProcessor.java:192)
~[hive-exec-4.0.0.jar:4.0.0]
at
org.apache.hive.service.cli.session.HiveSessionImpl.configureSession(HiveSessionImpl.java:284)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.hive.service.cli.session.HiveSessionImpl.open(HiveSessionImpl.java:198)
~[hive-service-4.0.0.jar:4.0.0]
at
org.apache.hive.service.cli.session.SessionManager.createSession(SessionManager.java:485)
~[hive-service-4.0.0.jar:4.0.0]
... 13 more
From: Shaik, Jilani <jilanibasha.sh...@optum.com>
Date: Monday, July 15, 2024 at 11:00 PM
To: user@hive.apache.org <user@hive.apache.org>
Subject: Hive ldap auth failing from db client tool using jdbc driver
Hi,
I am trying to connect hive with ldap authentication. I was able to connect
using beeline from the hive server. But the same when I am trying to connect
with database tool like db visualizer using jdbc, its failing with below error
message.
This hive instance is running from docker and able to access “HiveServer2” from
browser @ http://localhost:10002/
An error occurred while establishing the connection:
Long Message:
Could not open client transport with JDBC Uri:
jdbc:hive2://localhost:10000/default: Failed to open new session:
java.lang.IllegalArgumentException: hive configuration
hive.jdbc.client.authentication does not exists.
Details:
Type: java.sql.SQLException
SQL State: 08S01
Stack Trace:
org.apache.hive.service.cli.HiveSQLException: Failed to open new session:
java.lang.IllegalArgumentException: hive configuration
hive.jdbc.client.authentication does not exists.
at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:311)
at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:302)
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:745)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:238)
[wrapped] java.sql.SQLException: Could not open client transport with JDBC Uri:
jdbc:hive2://localhost:10000/default: Failed to open new session:
java.lang.IllegalArgumentException: hive configuration
hive.jdbc.client.authentication does not exists.
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:262)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at com.onseven.dbvis.jdbc.b.e.b(Z:525)
at com.onseven.dbvis.jdbc.b.g$_b.call(Z:618)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
Can someone please let me know what is that I am doing incorrect here. I am
running hive version 4.0.0 from docker.
Thanks,
Jilani
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or intended recipient’s authorized agent, the reader is hereby
notified that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
