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.
