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, "[email protected]" <[email protected]> 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 [email protected] 週一無肉日吃素救地球(Meat Free Monday Taiwan) |---------+---------------------------------> | | "Basmajian, Raffi" | | | <rbasmaj...@oppenheime| | | rfunds.com> | | | | | | 2010/03/19 11:33 PM | | | Please respond to | | | hbase-user | | | | |---------+---------------------------------> >-------------------------------------------------------------------------------------------------------------| | | | To: [email protected] | | 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. ---------------------------------------------------------------------------
