hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adarsh Sharma <adarsh.sha...@orkash.com>
Subject Errors while fetching data through Hive.
Date Tue, 10 Aug 2010 05:57:58 GMT
Hi all,
I am working with Hadoop-0.20.1+HadoopDb+hive.
I have two external table(website_master and master_seed) in Hive whose 
data is in Postgres and trying to fetch data through java code in Eclipse.
I am able to fetch data of website_master but when i tried to fetch data 
of master_seed through same  code, it gives the following error...

Hive Execution
Hive history file=/tmp/root/hive_job_log_root_201008101052_1918617026.txt
Aug 10, 2010 10:52:45 AM 
org.apache.hadoop.hive.ql.session.SessionState$LogHelper printInfo
INFO: Hive history 
file=/tmp/root/hive_job_log_root_201008101052_1918617026.txt
con org.apache.hadoop.hive.jdbc.HiveConnection@340d1fa5
Running: describe master_seed
url_id    int
url    string
location1    string
Running: select url_id,url from master_seed
Exception in thread "main" java.sql.SQLException: 
HiveServerException(message:Query returned non-zero code: 9)
    at 
org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:123)
    at test.Jdbcclient.main(Jdbcclient.java:57)

I Googled a lot but couldn't find any solution.
Can anyone Please tell  me how to debug it.

Thanks in advance.
 



Mime
View raw message