- Reply message -
From: Pavan Sudheendra pavan0...@gmail.com
To: user@hbase.apache.org
Subject: How to join 2 tables using hadoop?
Date: Fri, Jul 19, 2013 9:54 AM
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
@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.yu...@gmail.com wrote:
You can also look
These are two separate things. first is to read data from Json format and
then joining it. we can separate those. You first need to read the row
using JSon storage API for Pig then yes, you can use native Pig constructs
for joining.
Regards,
Shahab
On Saturday, July 20, 2013, Pavan Sudheendra
Try hive with hbase storage handler
On Fri, Jul 19, 2013 at 9:54 AM, Pavan Sudheendra pavan0...@gmail.comwrote:
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
You can write one MR job to finish this. First read two tables at Map
function, the output key will be the reference key for one table and
primary key for the other table. At the Reduce function, you can join the
tuples which contain the same key. Please note this is a very naive
approach, for
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 pavan0...@gmail.comwrote:
Hi,
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.yu...@gmail.com wrote:
You can also look into Pig, if you already haven't. It supports various
kinds of joins and is simpler than
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