-Re: Problems using hive JDBC driver on Windows (with Squirrel SQL Client)
Vijay 2009-09-15, 22:46
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.
> 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
>> java.sql.SQLException: Method not supported
>> 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
>> Any help is appreciated.