Thanks for the response.
The issue is resolved now. The problem and resolution was as follows:
1. Hive logs errors to System.err. In our case it went to nohup.out w=
hile we were looking for errors in Hive log4j logs and the Hadoop log4j log=
s. I found this strange.
2. The error log showed a Java "no such method" exception in the Thri=
ft gateway classes. A bit of Googling lead us to people with similar issues=
th_java_lang_nosuchmethoderror). The fix was to replace the libfb303.jar in=
the Hadoop cluster (name and data nodes) with the one that comes with the =
Hive distribution. This again was surprising as we deployed Hadoop and Hive=
from Cloudera CDH2. Btw the Hive distribution was 0.4.x(released Feb '10) =
and not 0.5.1 as mentioned in my mail.
From: Kirk True
Sent: Monday, November 01, 2010 8:58 AM
Cc: Regunath Balasubramanian
Subject: Re: Java client hangs when executing Hive query using JDBC interfa=
If you run `pkill -3 java` on the client and server machines, do you see an=