[
https://issues.apache.org/jira/browse/IMPALA-5040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Greg Rahn closed IMPALA-5040.
-----------------------------
Resolution: Information Provided
> User Name authentication (i.e. AuthMech=2) causes JDBC connection to get HUNG.
> ------------------------------------------------------------------------------
>
> Key: IMPALA-5040
> URL: https://issues.apache.org/jira/browse/IMPALA-5040
> Project: IMPALA
> Issue Type: Bug
> Components: Clients
> Affects Versions: Impala 2.2.4
> Reporter: Sudarshan
> Priority: Major
> Attachments: ImpalaJDBC_driver.log, Impala_connection_0.log,
> impalad.INFO
>
>
> Creating a JDBC connection with "AuthMech=2", [jdbc_url] with Cloudera JDBC
> Driver for Impala Version 2.5.36, causes the JDBC connection to get HUNG for
> a long time. It never returns. netstat shows that a TCP connection is
> established and it remains in this state for a long time.
> {code:java}
> [root@nightly59-unsecure-2 impalad]# netstat -an | grep 21050
> tcp 0 0 :::21050 :::*
> LISTEN
> tcp 0 0 ::ffff:172.31.113.152:21050 ::ffff:172.16.1.48:50028
> ESTABLISHED
> [root@nightly59-unsecure-2 impalad]#
> {code}
> [jdbc_url]
> jdbc:impala://nightly59-unsecure-2.gce.cloudera.com:21050/default;AuthMech=2;REQUEST_POOL=sudarshan_pool;UID=sudarshan;LogLevel=6;LogPath=/tmp/IMPALA_TEST
> Entire source code is as follows.
> {code:java}
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.ResultSet;
> import java.sql.Statement;
> public class SampleCode_Impala_Unsecure {
> public static final String JDBC_4_DRIVER =
> "com.cloudera.impala.jdbc4.Driver";
> public static final String DRIVER_CLASS = JDBC_4_DRIVER;
> public static final String CONNECTION_URL =
> "jdbc:impala://nightly59-unsecure-2.gce.cloudera.com:21050/default;AuthMech=2;REQUEST_POOL=sudarshan_pool;UID=sudarshan;LogLevel=6;LogPath=/tmp/IMPALA_TEST";
> public static void main(String[] args) throws Exception{
> Class.forName(DRIVER_CLASS);
> Connection connection = DriverManager.getConnection(CONNECTION_URL);
> Statement st = connection.createStatement();
> ResultSet rs = st.executeQuery("select 'hello' ");
> while (rs.next()) {
> System.out.println(rs.getString(1));
> }
> rs.close();
> st.close();
> connection.close();
> }
> }
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
