On Tue, Aug 10, 2010 at 1:57 AM, Adarsh Sharma <[email protected]> wrote: > 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. > > > >
Adarsh, HadoopDB AFAIK is a patched version/branch of hive. So a bug in hadoopdb is not necessarily a hive bug, can you recreate the problem in apache-hive? Edward
