hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pavan Sudheendra <pavan0...@gmail.com>
Subject Re: How to join 2 tables using hadoop?
Date Sat, 20 Jul 2013 05:48:19 GMT
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
>>



-- 
Regards-
Pavan

Mime
View raw message