[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2012-01-18 Thread Todd Lipcon (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13188876#comment-13188876
 ] 

Todd Lipcon commented on HIVE-2163:
---

We came across this same issue in another scenario - it looks like Hive is 
somewhere setting the thread's ContextClassLoader to null. I opened HADOOP-7982 
to work around the issue from the Hadoop side, but I think Hive must have a bug 
that causes these problems.

 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Carl Steinbach
 Fix For: 0.7.1


 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:
 {noformat}
 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 
 

[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2012-01-18 Thread Carl Steinbach (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13188879#comment-13188879
 ] 

Carl Steinbach commented on HIVE-2163:
--

@Todd: can you provide more details about this other situation you encountered? 
How can I reproduce it? Thanks.

 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Carl Steinbach
 Fix For: 0.7.1


 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:
 {noformat}
 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 
 

[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2012-01-18 Thread Todd Lipcon (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1314#comment-1314
 ] 

Todd Lipcon commented on HIVE-2163:
---

Unfortunately the other situation was integrated into some non-open-source 
software, so it's not easy to reproduce. It does make use of the Hive metadata, 
so my guess is that calling into some SessionState code (as described above in 
this ticket) was the culprit. I did verify that the ContextClassLoader was set 
to null which is what caused the problem, I just couldn't tell how it got that 
way.

 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Carl Steinbach
 Fix For: 0.7.1


 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:
 {noformat}
 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) 
 

[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2012-01-18 Thread Carl Steinbach (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13188892#comment-13188892
 ] 

Carl Steinbach commented on HIVE-2163:
--

Todd, thanks for finding this. I filed HIVE-2729 to track the 
ContextClassLoader issue.

 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Carl Steinbach
 Fix For: 0.7.1


 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:
 {noformat}
 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 
 

[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2011-06-03 Thread Mythili Gopalakrishnan (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13043289#comment-13043289
 ] 

Mythili Gopalakrishnan commented on HIVE-2163:
--

I have the exact same problem. I have squirrel installed on windows machine 
which is not part of the cloudera hadoop cluster. and I am trying to connect to 
HIVE using JDBC. Is there anything else to do to get this working...





 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach

 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:
 {noformat}
 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 
 

[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2011-06-03 Thread Bennie Schut (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13043317#comment-13043317
 ] 

Bennie Schut commented on HIVE-2163:


HIVE-2054 removes the dependency to SessionState which includes code which 
should be server side so it's most likely fixed by that. Can you try 0.7.1 or 
higher?

 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach

 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:
 {noformat}
 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 
 

[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2011-06-03 Thread Mythili Gopalakrishnan (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13043357#comment-13043357
 ] 

Mythili Gopalakrishnan commented on HIVE-2163:
--

Thanks. Is 0.7.1 available in binary form for download?

 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach

 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:
 {noformat}
 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 

[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2011-06-03 Thread Carl Steinbach (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13043936#comment-13043936
 ] 

Carl Steinbach commented on HIVE-2163:
--

0.7.1 has not yet been released, but you can get SNAPSHOT tarballs here:

https://builds.apache.org/job/Hive-branch-0.7.1-h0.21/


 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach

 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:
 {noformat}
 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 

[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2011-05-13 Thread Todd Lipcon (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13032846#comment-13032846
 ] 

Todd Lipcon commented on HIVE-2163:
---

Any idea of the root cause of this? Is SquirrelSQL doing something funky with 
the thread's context classloader by any chance?

 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach

 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:
 {noformat}
 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 

[jira] [Commented] (HIVE-2163) SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0

2011-05-12 Thread Carl Steinbach (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13032765#comment-13032765
 ] 

Carl Steinbach commented on HIVE-2163:
--

There's a workaround.

Ignore the directions on the wiki. Instead, set HADOOP_HOME, HIVE_HOME, PATH, 
and CLASSPATH as follows before running squirrel-sql.sh:

{noformat}

export HADOOP_HOME=YOUR_HADOOP_HOME
export HIVE_HOME=YOUR_HIVE_HOME
export PATH=$HIVE_HOME/bin:$HADOOP_HOME/bin:$PATH

# You'll need to manually expand the wildcards
export CLASSPATH=$HADOOP_HOME/hadoop-*.jar:$HIVE_HOME/conf:$HIVE_HOME/lib/*.jar
{noformat}


 SquirrelSQL 3.2.1 doesn't work with Hive 0.7.0
 --

 Key: HIVE-2163
 URL: https://issues.apache.org/jira/browse/HIVE-2163
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Carl Steinbach

 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:
 {noformat}
 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