Re: Hive+Hbase Integration Error.

2012-08-20 Thread Sandeep Reddy P
Hi, Now the Job Tracker log's java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row {"foo":98,"bar":"abc"} at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:161) at org.apache.hadoop.mapred.MapRunner.run

Hive+Hbase Integration Error.

2012-08-20 Thread Sandeep Reddy P
Hi, I want to integrate Hive and Hbase Tables. I created a table in hive using Stored By. When i try to load data into that table using INSERT OVERWRITE TABLE hbase_table_1 SELECT * FROM pokes; I got the following exceptions, FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.ex

Re: Hive/Hbase Integration Error

2011-01-11 Thread Adarsh Sharma
Jean-Daniel Cryans wrote: Can you confirm that the machine you're running hive from can "telnet 192.168.1.101 2181" and pals? Can it even ping? If not, then either the problem is that the machine cannot reach your zookeeper servers or they aren't running. There's not that many other options. J-D

Re: Hive/Hbase Integration Error

2011-01-11 Thread Jean-Daniel Cryans
Can you confirm that the machine you're running hive from can "telnet 192.168.1.101 2181" and pals? Can it even ping? If not, then either the problem is that the machine cannot reach your zookeeper servers or they aren't running. There's not that many other options. J-D

Re: Hive/Hbase Integration Error

2011-01-11 Thread Adarsh Sharma
Jean-Daniel Cryans wrote: Sorry it that wasn't obvious, but you need to run hive using this command: I am extremely Sorry Sir. As per your instructions I am sending you the output of the create table command. Please check the attachment. Thanks & Warm Regards Adarsh Sharma bin/hive

Re: Hive/Hbase Integration Error

2011-01-10 Thread Adarsh Sharma
Jean-Daniel Cryans wrote: Sorry it that wasn't obvious, but you need to run hive using this command: bin/hive -hiveconf hive.root.logger=INFO,console AND in the same shell create the table in order to have more information. What we're trying to get looks like this: http://pastebin.com/gvTXDxtE

Re: Hive/Hbase Integration Error

2011-01-10 Thread Jean-Daniel Cryans
Sorry it that wasn't obvious, but you need to run hive using this command: bin/hive -hiveconf hive.root.logger=INFO,console AND in the same shell create the table in order to have more information. What we're trying to get looks like this: http://pastebin.com/gvTXDxtE Specifically, this line is

Re: Hive/Hbase Integration Error

2011-01-10 Thread Adarsh Sharma
Dear all, Sorry I am replying my own question because I found the cause and want to discuss if anyone have an idea about it. From the wiki's page I found that : http://wiki.apache.org/hadoop/Hive/HBaseIntegration *

Re: Hive/Hbase Integration Error

2011-01-09 Thread Adarsh Sharma
Jean-Daniel Cryans wrote: You also need to create the table in order to see the relevant debug information, it won't create it until it needs it. Sir Check the output : hive> CREATE TABLE hive_hbasetable_k(key int, value string) > STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandl

Re: Hive/Hbase Integration Error

2011-01-09 Thread Jean-Daniel Cryans
You also need to create the table in order to see the relevant debug information, it won't create it until it needs it. J-D On Jan 9, 2011 9:30 PM, "Adarsh Sharma" wrote: > Jean-Daniel Cryans wrote: >> Just figured that running the shell with this command will give all >> the info you need: >> >>

Re: Hive/Hbase Integration Error

2011-01-09 Thread Adarsh Sharma
Jean-Daniel Cryans wrote: Just figured that running the shell with this command will give all the info you need: bin/hive -hiveconf hive.root.logger=INFO,console Thanks JD, below is the output of this command : had...@s2-ratw-1:~/project/hive-0.6.0/build/dist$ bin/hive -hiveconf hive.roo

Re: Hive/Hbase Integration Error

2011-01-09 Thread Adarsh Sharma
Viral Bajaria wrote: Hi Adarsh, Can you provide some more details as follows. I have had issues before on communicating between my HMaster etc. but the initial issue was ACL(s) and my zookeeper settings were a little messed up too (I can't recollect what was wrong with zookeeper). I would su

Re: Hive/Hbase Integration Error

2011-01-07 Thread Viral Bajaria
Hi Adarsh, Can you provide some more details as follows. I have had issues before on communicating between my HMaster etc. but the initial issue was ACL(s) and my zookeeper settings were a little messed up too (I can't recollect what was wrong with zookeeper). I would suggest that you get things u

Re: Hive/Hbase Integration Error

2011-01-07 Thread Jean-Daniel Cryans
Just figured that running the shell with this command will give all the info you need: bin/hive -hiveconf hive.root.logger=INFO,console J-D On Fri, Jan 7, 2011 at 9:57 AM, Jean-Daniel Cryans wrote: > While testing other things yesterday on my local machine, I > encountered the same stack traces

Re: Hive/Hbase Integration Error

2011-01-07 Thread Jean-Daniel Cryans
While testing other things yesterday on my local machine, I encountered the same stack traces. Like I said the other day, which you seem to have discarded while debugging your issue, is that it's not able to connect to Zookeeper. Following the cue, I added these lines in HBaseStorageHandler.setCon

Re: Hive/Hbase Integration Error

2011-01-07 Thread Adarsh Sharma
John Sichi wrote: On Jan 6, 2011, at 9:53 PM, Adarsh Sharma wrote: I want to know why it occurs in hive.log 2011-01-05 15:19:36,783 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cannot be resolved.

Re: Hive/Hbase Integration Error

2011-01-06 Thread John Sichi
On Jan 6, 2011, at 9:53 PM, Adarsh Sharma wrote: > I want to know why it occurs in hive.log > > 2011-01-05 15:19:36,783 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.resources" but it cannot be resolved. > That is a bogus

Re: Hive/Hbase Integration Error

2011-01-06 Thread Adarsh Sharma
John Sichi wrote: Here is what you need to do: 1) Use svn to check out the source for Hive 0.6 I download Hive-0.6.0 source code with the command svn co http://svn.apache.org/repos/asf/hive/branches/branch-0.6/ hive-0.6.0 2) In your checkout, replace the HBase 0.20.3 jars with the ones f

Re: Hive/Hbase Integration Error

2011-01-06 Thread John Sichi
Here is what you need to do: 1) Use svn to check out the source for Hive 0.6 2) In your checkout, replace the HBase 0.20.3 jars with the ones from 0.20.6 3) Build Hive 0.6 from source 4) Use your new Hive build JVS On Jan 6, 2011, at 2:34 AM, Adarsh Sharma wrote: > Dear all, > > I am sorry

Hive/Hbase Integration Error

2011-01-06 Thread Adarsh Sharma
Dear all, I am sorry I am posting this message again but I can't able to locate the root cause after googled a lot. I am trying Hive/Hbase Integration from the past 2 days. I am facing the below issue while creating external table in Hive. I am using hadoop-0.20.2, hbase-0.20.6, hive-0.6.0