Uploaded image for project: 'CDH (READ-ONLY)'
  1. CDH (READ-ONLY)
  2. DISTRO-856

Impala Connection using JDBC fails after enabling Kerberos and Sentry

    Details

    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Sentry
    • Labels:

      Description

      We had Impala running on a Cloudera clustera. We installed Kerberos and Sentry and now not able to connect to Impala using JDBC using Cloudera's JDBC driver. The user has the admin role and able to connect using Impala - Shell but when trying to connect through JDBC throws exception. I am putting the Connection String and exception below.

      Impala Connection String: jdbc:impala://xxx.xxx.xxx.xxx:21050/default;AuthMech=3;UID=chuser;PWD=<pwd>;

      Here is the error message:

      Exception in thread "main" java.sql.SQLException: [Simba][ImpalaJDBCDriver](500164) Error initialized or created transport for authentication: java.net.ConnectException: Connection timed out: connect.
      at com.cloudera.hivecommon.api.HiveServer2ClientFactory.createTransport(Unknown Source)
      at com.cloudera.hivecommon.api.HiveServer2ClientFactory.createClient(Unknown Source)
      at com.cloudera.hivecommon.core.HiveJDBCCommonConnection.connect(Unknown Source)
      at com.cloudera.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
      at com.cloudera.jdbc.common.AbstractDriver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:664)
      at java.sql.DriverManager.getConnection(DriverManager.java:270)
      at main.ImpalaConnector.main(ImpalaConnector.java:36)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      Caused by: com.cloudera.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500164) Error initialized or created transport for authentication: java.net.ConnectException: Connection timed out: connect.
      ... 12 more
      Caused by: org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection timed out: connect
      at org.apache.thrift.transport.TSocket.open(TSocket.java:185)
      at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:248)
      at org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37)
      at com.cloudera.hivecommon.api.HiveServer2ClientFactory.createTransport(Unknown Source)
      at com.cloudera.hivecommon.api.HiveServer2ClientFactory.createClient(Unknown Source)
      at com.cloudera.hivecommon.core.HiveJDBCCommonConnection.connect(Unknown Source)
      at com.cloudera.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
      at com.cloudera.jdbc.common.AbstractDriver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:664)
      at java.sql.DriverManager.getConnection(DriverManager.java:270)
      at main.ImpalaConnector.main(ImpalaConnector.java:36)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)
      Caused by: java.net.ConnectException: Connection timed out: connect
      at java.net.DualStackPlainSocketImpl.connect0(Native Method)
      at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
      at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
      at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
      at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
      at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
      at java.net.Socket.connect(Socket.java:589)
      at org.apache.thrift.transport.TSocket.open(TSocket.java:180)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              hidhingra31 Himanshu
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: