Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-2163

SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 0.7.0
    • Fix Version/s: 0.7.1
    • Component/s: JDBC
    • Labels:
      None

      Description

      I tried using SquirrelSQL 3.2.1 with Hive 0.7.0 following the directions located here: http://wiki.apache.org/hadoop/Hive/HiveJDBCInterface

      I registered the Hive JDBC driver with SquirrelSQL, and then get the following exception when I try to connect to the Hive Server process:

      java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: java.io.IOException: failure to login 
      at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:226) 
      at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:72) 
      at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:110) 
      at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133) 
      at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97) 
      at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:281)
      at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.performOK(ConnectToAliasCommand.java:238)
      at net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrame.connect(ConnectionInternalFrame.java:311) 
      at net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrame.access$300(ConnectionInternalFrame.java:56) 
      at net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrame$MyOkClosePanelListener.okPressed(ConnectionInternalFrame.java:461)
      at net.sourceforge.squirrel_sql.client.gui.OkClosePanel.fireButtonPressed(OkClosePanel.java:148) 
      at net.sourceforge.squirrel_sql.client.gui.OkClosePanel.access$100(OkClosePanel.java:33) 
      at net.sourceforge.squirrel_sql.client.gui.OkClosePanel$1.actionPerformed(OkClosePanel.java:174) 
      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028) 
      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351) 
      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) 
      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) 
      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) 
      at java.awt.Component.processMouseEvent(Component.java:6374) 
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) 
      at java.awt.Component.processEvent(Component.java:6139) 
      at java.awt.Container.processEvent(Container.java:2085) 
      at java.awt.Component.dispatchEventImpl(Component.java:4736) 
      at java.awt.Container.dispatchEventImpl(Container.java:2143) 
      at java.awt.Component.dispatchEvent(Component.java:4566) 
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4621) 
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4282) 
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4212) 
      at java.awt.Container.dispatchEventImpl(Container.java:2129) 
      at java.awt.Window.dispatchEventImpl(Window.java:2478) 
      at java.awt.Component.dispatchEvent(Component.java:4566) 
      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:680) 
      at java.awt.EventQueue.access$000(EventQueue.java:86) 
      at java.awt.EventQueue$1.run(EventQueue.java:639) 
      at java.awt.EventQueue$1.run(EventQueue.java:637) 
      at java.security.AccessController.doPrivileged(Native Method) 
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) 
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) 
      at java.awt.EventQueue$2.run(EventQueue.java:653) 
      at java.awt.EventQueue$2.run(EventQueue.java:651) 
      at java.security.AccessController.doPrivileged(Native Method) 
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) 
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:650) 
      at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:93) 
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296) 
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211) 
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201) 
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196) 
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188) 
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) 
      Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: java.io.IOException: failure to login 
      at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthenticator(HiveUtils.java:225) 
      at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:219) 
      ... 49 more 
      Caused by: java.lang.RuntimeException: java.io.IOException: failure to login 
      at org.apache.hadoop.hive.ql.security.HadoopDefaultAuthenticator.setConf(HadoopDefaultAuthenticator.java:53) 
      at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62) 
      at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117) 
      at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthenticator(HiveUtils.java:222) 
      ... 50 more 
      Caused by: java.io.IOException: failure to login 
      at org.apache.hadoop.security.UserGroupInformation.getLoginUser(UserGroupInformation.java:502) 
      at org.apache.hadoop.security.UserGroupInformation.getCurrentUser(UserGroupInformation.java:461) 
      at org.apache.hadoop.hive.shims.Hadoop20SShims.getUGIForConf(Hadoop20SShims.java:447) 
      at org.apache.hadoop.hive.ql.security.HadoopDefaultAuthenticator.setConf(HadoopDefaultAuthenticator.java:51) 
      ... 53 more 
      Caused by: javax.security.auth.login.LoginException: unable to find LoginModule class: org.apache.hadoop.security.UserGroupInformation$HadoopLoginModule 
      at javax.security.auth.login.LoginContext.invoke(LoginContext.java:808) 
      at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186) 
      at javax.security.auth.login.LoginContext$4.run(LoginContext.java:683) 
      at java.security.AccessController.doPrivileged(Native Method) 
      at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680) 
      at javax.security.auth.login.LoginContext.login(LoginContext.java:579) 
      at org.apache.hadoop.security.UserGroupInformation.getLoginUser(UserGroupInformation.java:483) 
      ... 56 more
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                cwsteinbach Carl Steinbach
                Reporter:
                cwsteinbach Carl Steinbach
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: