Hi Stuti, There are several approaches depending on your exact situation, but most involve secondary indexes. You should read the HBase book, specifically the chapter on secondary indexes:
http://hbase.apache.org/book.html#secondary.indexes -chris On Wed, Aug 17, 2011 at 10:18 AM, Stuti Awasthi <stutiawas...@hcl.com>wrote: > Hi all > > I have read that Hbase query will depend on <Row-Key> only . I was trying > to map my tables of RDBMS to HBASE and was thinking way out for the > following ? > > RDBMS Schema : > > Table Sales > Column: > > * Sales_Id (PK) > > * User_Id (FK) > > * Product_ID (FK) > > * Name > > * Mobile > > * Email > > Query : Select Name , Mobile, Email from Sales where User_id= "xyz" and > Product_Id= "123" > > This query is fairly simple in RDBMS because we can query based on columns. > How to do this efficiently in Hbase ? > > > > ________________________________ > ::DISCLAIMER:: > > ----------------------------------------------------------------------------------------------------------------------- > > The contents of this e-mail and any attachment(s) are confidential and > intended for the named recipient(s) only. > It shall not attach any liability on the originator or HCL or its > affiliates. Any views or opinions presented in > this email are solely those of the author and may not necessarily reflect > the opinions of HCL or its affiliates. > Any form of reproduction, dissemination, copying, disclosure, modification, > distribution and / or publication of > this message without the prior written consent of the author of this e-mail > is strictly prohibited. If you have > received this email in error please delete it and notify the sender > immediately. Before opening any mail and > attachments please check them for viruses and defect. > > > ----------------------------------------------------------------------------------------------------------------------- >