[ 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) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org