You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Adarsh Sharma <ad...@orkash.com> on 2010/08/10 07:57:58 UTC
Errors while fetching data through Hive.
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.
Re: Errors while fetching data through Hive.
Posted by Edward Capriolo <ed...@gmail.com>.
On Tue, Aug 10, 2010 at 1:57 AM, Adarsh Sharma <ad...@orkash.com> 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.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.
>
>
>
>
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