Thanks a lot Bill! That was my problem. I thought my code base was pretty recent. Apparently not!!
I have a follow up question. Why does the hive jdbc driver need all of the jar files under lib *and* the hadoop core jar file? It seems like the jdbc driver is primarily acting as a thrift client to the thrift server. Shouldn't the requirements then be much more light-weight? On Tue, Sep 15, 2009 at 2:31 PM, Bill Graham <[email protected]> wrote: > Hi Vijay, > > Check your classpath to make sure you've got the correct hive-jdbc.jar > version built using either the trunk or the current 4.0 branch. > HiveStatement.java:390 used to throw 'java.sql.SQLException: Method not > supported' before HIVE-679 was committed. In the current code base after the > commit, the setMaxRows method is on lines 422-425. > > thanks, > BIll > > > On Tue, Sep 15, 2009 at 2:13 PM, Vijay <[email protected]> wrote: > >> I'm having trouble getting the hive jdbc driver to work on Windows. I'm >> following the Squirrel SQL Client setup from the Hive/HiveJDBCInterface wiki >> page. Everything works great when Squirrel SQL Client is running on Linux >> but on Windows it doesn't. Squirrel can connect to the hive server fine so >> the setup is alright. However, when I issue a query, it doesn't seem to >> execute at all. I see this exception in the Squirrel client: >> >> 2009-09-15 14:10:35,268 [Thread-5] ERROR >> net.sourceforge.squirrel_sql.client.session.SQLExecuterTask - Can't Set >> MaxRows >> java.sql.SQLException: Method not supported >> at >> org.apache.hadoop.hive.jdbc.HiveStatement.setMaxRows(HiveStatement.java:390) >> at >> net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.setMaxRows(SQLExecuterTask.java:318) >> at >> net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:157) >> at >> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) >> at java.lang.Thread.run(Thread.java:619) >> >> I don't seem to get this exception on Linux. I can't get the Squirrel >> client to not set max rows but I'm not entirely sure that's the real >> problem. >> >> Any help is appreciated. >> Vijay >> > >
