You must decide your tables fetching by key or index.(Maybe it's not good
big table design pattern)
We're running 0.20.2 now , the index scan is with a little different
between 0.20.2 and 0.20.3.
Now we just test 0.20.3 index ; actually we can't find the right code to
use index scan in 0.20.3.
After scanning, We'll try to put these data to SQLITE memory then you can
easily join your data by
AnsiSQL through SQLITE jdbc.
Fleming Chiu(邱宏明)
707-6128
y_823...@tsmc.com
週一無肉日吃素救地球(Meat Free Monday Taiwan)
<victor.h...@noki
a.com> To:
<hbase-user@hadoop.apache.org>
cc: (bcc: Y_823910/TSMC)
2010/03/22 10:23 Subject: Re: How to join tables
in HBase 20.3
PM
Please respond to
hbase-user
Hi Fleming,
I would love to some sample code to illustrate your method.
Anyone else have a generic way to do it?
Victor
On 3/21/10 11:31 PM, "y_823...@tsmc.com" <y_823...@tsmc.com> wrote:
If you can fetch data fast from Hbase, I think join is not a big problem.
You can setup customer(cus_id as key) and order(ord_id as key and cus_id as
index) table in HBase.
Fetching order detail by cus_id then put it in in-memoty db like sqlite
then do joining locally.
According to our case, there is three part of our code ; fetching data from
hbase , do joining , writing join result back to Hbase.
The time of fetching data from HBase took 83% , join 6%, write back to
Hbase 11%.
If your ap is not fetching huge data from Hbase , although it's not so
convenient like using SQL join in RDBMS.
It's very cool to fetch data from a distributed storage with a good
performance, isn't it?
Fleming Chiu(邱宏明)
707-6128
y_823...@tsmc.com
週一無肉日吃素救地球(Meat Free Monday Taiwan)
|---------+--------------------------------->
| | "Basmajian, Raffi" |
| | <rbasmaj...@oppenheime|
| | rfunds.com> |
| | |
| | 2010/03/19 11:33 PM |
| | Please respond to |
| | hbase-user |
| | |
|---------+--------------------------------->
>-------------------------------------------------------------------------------------------------------------|
|
|
| To: hbase-user@hadoop.apache.org
|
| cc: (bcc: Y_823910/TSMC)
|
| Subject: How to join tables in HBase 20.3
|
>-------------------------------------------------------------------------------------------------------------|
I am new to HBase and come from a rdbms background. After looking in the
sample client code it seems fairly easy to query a single table using
Get and Scan, but it's not so obvious how to join data across multiple
tables.
Are there any examples on how to read/join data across multiple tables?
Thank you
Raffi Basmajian
------------------------------------------------------------------------------
This e-mail transmission may contain information that is proprietary,
privileged and/or confidential and is intended exclusively for the
person(s) to whom it is addressed. Any use, copying, retention or
disclosure by any person other than the intended recipient or the intended
recipient's designees is strictly prohibited. If you are not the intended
recipient or their designee, please notify the sender immediately by return
e-mail and delete all copies. OppenheimerFunds may, at its sole discretion,
monitor, review, retain and/or disclose the content of all email
communications.
==============================================================================
---------------------------------------------------------------------------
TSMC PROPERTY
This email communication (and any attachments) is proprietary information
for the sole use of its
intended recipient. Any unauthorized review, use or distribution by anyone
other than the intended
recipient is strictly prohibited. If you are not the intended recipient,
please notify the sender by
replying to this email, and then delete this email and any copies of it
immediately. Thank you.
---------------------------------------------------------------------------
---------------------------------------------------------------------------
TSMC PROPERTY
This email communication (and any attachments) is proprietary information
for the sole use of its
intended recipient. Any unauthorized review, use or distribution by anyone
other than the intended
recipient is strictly prohibited. If you are not the intended recipient,
please notify the sender by
replying to this email, and then delete this email and any copies of it
immediately. Thank you.
---------------------------------------------------------------------------
