hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "manishbhoge@rocketmail.com" <manishbh...@rocketmail.com>
Subject Re: How to join 2 tables using hadoop?
Date Mon, 22 Jul 2013 03:13:11 GMT

You can store json using map function to hive table. So once you write select query then you
can use map function.
Once data retrived you can join with data on another table.
Sent via Rocket from my HTC 

----- Reply message -----
From: "Pavan Sudheendra" <pavan0591@gmail.com>
To: <user@hbase.apache.org>
Subject: How to join 2 tables using hadoop?
Date: Sat, Jul 20, 2013 11:18 AM

If i have the value of a row in JSON format, would pig we able to
parse it and join the fields as per my needs?

On Fri, Jul 19, 2013 at 10:00 PM, Shahab Yunus <shahab.yunus@gmail.com> wrote:
> You can also look into Pig, if you already haven't. It supports various
> kinds of joins and is simpler than writing your own M/R job (assuming that
> you don't have complex or custom requirements.)
> Regards,
> Shahab
> On Fri, Jul 19, 2013 at 12:24 AM, Pavan Sudheendra <pavan0591@gmail.com>wrote:
>> Hi,
>> I know that HBase by default doesn't support table joins like RDBMS..
>> But anyway, I have a table who value contains a json with a particular
>> ID in it..
>> This id references another table where it is a key..
>> I want to fetch the id first from table A , query table 2 and get its
>> corresponding value..
>> What is the best way of achieving this using the MR framework?
>> Apologizes, i'm still new to Hadoop and HBase so please go easy on me.
>> Thanks for any help
>> --
>> Regards-
>> Pavan

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message