hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From T2thenike <T2then...@gmail.com>
Subject Hive JDBC Connection Timeout
Date Thu, 17 Jun 2010 15:14:46 GMT

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.

View raw message