[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hadoop-dev
Subject:    Hive JDBC Connection Timeout
From:       T2thenike <T2thenike () gmail ! com>
Date:       2010-06-17 15:14:46
Message-ID: 28915107.post () talk ! nabble ! com
[Download RAW message or body]


I am working with complex Hive queries and moderate amounts of data.  I am
running into a problem where my JDBC connection is timing out before the
Hive answer is returned.  The timeout seems to occur at about 3 minutes, but
the query takes at least 5.  I'm running Hadoop 0.20.1, Hive 0.4.0, and I'd
like to stick with these versions.  Is there a way to increase the
connection timeout?

I am setup using Hive and plain text files for inputs.  I'm getting the JDBC
running using "hive --service hiveserver", which enables the JDBC/Thrift
interface.  The actual exception is a SQLException caused by a Thrift
exception where the "Connection timed out".

I have already tried setting the SQL statement.setQueryTimeout(), which seem
to have no effect.  Maybe there's a setting to increase the Thrift timeout,
but I haven't been able to find it. Any suggestions?  
-- 
View this message in context: http://old.nabble.com/Hive-JDBC-Connection-Timeout-tp28915107p28915107.html
Sent from the Hadoop core-dev mailing list archive at Nabble.com.

[prev in list] [next in list] [prev in thread] [next in thread]