Venu Yanamandra created HIVE-20846:
--------------------------------------
Summary: beeline does not honor driver mandated key/value pairs
for uid & pwd.
Key: HIVE-20846
URL: https://issues.apache.org/jira/browse/HIVE-20846
Project: Hive
Issue Type: Bug
Components: Beeline
Affects Versions: 1.1.0
Reporter: Venu Yanamandra
Please confirm and correct if necessary the expectation that beeline program
should honor the driver's key/value pairs for UID/PWD.
Steps to reproduce the issue -
1. Download latest Impala JDBC driver from -
'https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-4.html'
2. Extract, set & export HADOOP_CLASSPATH to: $(hadoop
classpath):<location_of_impala_jdbc_driver>
3. As per the documentation of the driver, we should be setting up:
AuthMech=3;UID=<ldap_user>;PWD=<ldap_user_password> for connecting to impala
jdbc using LDAP. [1]
4. However, beeline is unable to successfully connect.
5. Impala coordinator logs displays the error [2] below.
6. If we however use "user=<ldap_user>;password=<ldap_user_password>" in the
connection string, it works fine. [3]
7. However, the expectation is that beeline should honor driver's kv pairs for
uid/pwd.
Regards,
Venu Yanamandra
{noformat}
[1]:
beeline -d "com.cloudera.impala.jdbc41.Driver" -u
"jdbc:impala://nightly512-3.vpc.cloudera.com:21051/default;SSL=1;SSLTrustStore=/etc/cdep-ssl-conf/CA_STANDARD/truststore.jks;SSLTrustStorePwd=cloudera;AllowSelfSignedCerts=1;CAIssuedCertNamesMismatch=1;AuthMech=3;UID=test1;PWD=Password1;LogLevel=6;LogPath=/root/ijdbc/drvlog"
[2]:
E1024 04:34:52.694922 29833 authentication.cc:159] SASL message (LDAP):
All-whitespace username.
I1024 04:34:52.696190 29833 thrift-util.cc:123] TThreadPoolServer: Caught
TException: SASL(-1): generic failure: All-whitespace username.
[3]:
beeline -d "com.cloudera.impala.jdbc41.Driver" -u
"jdbc:impala://nightly512-3.vpc.cloudera.com:21051/default;SSL=1;SSLTrustStore=/etc/cdep-ssl-conf/CA_STANDARD/truststore.jks;SSLTrustStorePwd=cloudera;AllowSelfSignedCerts=1;CAIssuedCertNamesMismatch=1;AuthMech=3;user=test1;password=Password1;UID=test1;PWD=Password1;LogLevel=6;LogPath=/root/ijdbc/drvlog"
-e "show databases;"
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
