Re: Hbase query

[Christopher Tarnas <cf...@email.com>]

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 <st...@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.
>
>
> -----------------------------------------------------------------------------------------------------------------------
>