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.hiveconnect...@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.
