You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by ra...@polarisFT.com on 2013/02/04 05:41:06 UTC
Start key and End key in HBase
Hi all,
Can anyone let me know what is the use of Start key and End key in HBase.
Regards
Raviprasad. T
Mobile :- 91- 9894769541
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
Visit us at http://www.polarisFT.com
Re: Start key and End key in HBase
Posted by Mohammad Tariq <do...@gmail.com>.
Just to add to whatever Anoop sir has said, the row corresponding to the
endkey is not included in the result set by default.
Warm Regards,
Tariq
https://mtariq.jux.com/
cloudfront.blogspot.com
On Mon, Feb 4, 2013 at 12:38 PM, Anoop Sam John <an...@huawei.com> wrote:
> When you do a scan with out specifying any start/end keys, it is full
> table scan. The scan from client side will go through all the regions one
> after the other.
> But when you know the rowkey range that you want to scan you can specify
> that using start/end keys. This time client will evaluate which all regions
> it need to contact for scaning the data (Based on the start/end keys of
> regions as stored in META table) and only those regions will get contacted
> and scanned.
>
> Also remember that the start key need not be a full rowkey which exactly
> map to a rowkey within a table. This can be a prefix part of the actual
> rowkey also.
>
> -Anoop-
> ________________________________________
> From: raviprasad.t@polarisFT.com [raviprasad.t@polarisFT.com]
> Sent: Monday, February 04, 2013 10:11 AM
> To: user@hbase.apache.org
> Subject: Start key and End key in HBase
>
> Hi all,
> Can anyone let me know what is the use of Start key and End key in
> HBase.
>
>
> Regards
> Raviprasad. T
> Mobile :- 91- 9894769541
>
>
> This e-Mail may contain proprietary and confidential information and is
> sent for the intended recipient(s) only. If by an addressing or
> transmission error this mail has been misdirected to you, you are requested
> to delete this mail immediately. You are also hereby notified that any use,
> any form of reproduction, dissemination, copying, disclosure, modification,
> distribution and/or publication of this e-mail message, contents or its
> attachment other than by its intended recipient/s is strictly prohibited.
>
> Visit us at http://www.polarisFT.com
>
RE: Start key and End key in HBase
Posted by Anoop Sam John <an...@huawei.com>.
When you do a scan with out specifying any start/end keys, it is full table scan. The scan from client side will go through all the regions one after the other.
But when you know the rowkey range that you want to scan you can specify that using start/end keys. This time client will evaluate which all regions it need to contact for scaning the data (Based on the start/end keys of regions as stored in META table) and only those regions will get contacted and scanned.
Also remember that the start key need not be a full rowkey which exactly map to a rowkey within a table. This can be a prefix part of the actual rowkey also.
-Anoop-
________________________________________
From: raviprasad.t@polarisFT.com [raviprasad.t@polarisFT.com]
Sent: Monday, February 04, 2013 10:11 AM
To: user@hbase.apache.org
Subject: Start key and End key in HBase
Hi all,
Can anyone let me know what is the use of Start key and End key in HBase.
Regards
Raviprasad. T
Mobile :- 91- 9894769541
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
Visit us at http://www.polarisFT.com
Re: Start key and End key in HBase
Posted by Mohammad Tariq <do...@gmail.com>.
It signifies start and end of the table regions, it is used in doing range
queries.
Warm Regards,
Tariq
https://mtariq.jux.com/
cloudfront.blogspot.com
On Mon, Feb 4, 2013 at 10:11 AM, <ra...@polarisft.com> wrote:
> Hi all,
> Can anyone let me know what is the use of Start key and End key in
> HBase.
>
>
> Regards
> Raviprasad. T
> Mobile :- 91- 9894769541
>
>
> This e-Mail may contain proprietary and confidential information and is
> sent for the intended recipient(s) only. If by an addressing or
> transmission error this mail has been misdirected to you, you are requested
> to delete this mail immediately. You are also hereby notified that any use,
> any form of reproduction, dissemination, copying, disclosure, modification,
> distribution and/or publication of this e-mail message, contents or its
> attachment other than by its intended recipient/s is strictly prohibited.
>
> Visit us at http://www.polarisFT.com
>
RE: Start key and End key in HBase
Posted by ra...@polarisFT.com.
Hi Anoop,
Yes it for scan.
Regards
Raviprasad. T
Mobile :- 91- 9894769541
-----Anoop Sam John <an...@huawei.com> wrote: -----
To: "user@hbase.apache.org" <us...@hbase.apache.org>
From: Anoop Sam John <an...@huawei.com>
Date: 02/04/2013 10:14AM
Subject: RE: Start key and End key in HBase
Can you pls make the question clear?
You mean use in Scan?
-Anoop-
________________________________________
From: raviprasad.t@polarisFT.com [raviprasad.t@polarisFT.com]
Sent: Monday, February 04, 2013 10:11 AM
To: user@hbase.apache.org
Subject: Start key and End key in HBase
Hi all,
Can anyone let me know what is the use of Start key and End key in HBase.
Regards
Raviprasad. T
Mobile :- 91- 9894769541
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
Visit us at http://www.polarisFT.com
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
Visit us at http://www.polarisFT.com
RE: Start key and End key in HBase
Posted by Anoop Sam John <an...@huawei.com>.
Can you pls make the question clear?
You mean use in Scan?
-Anoop-
________________________________________
From: raviprasad.t@polarisFT.com [raviprasad.t@polarisFT.com]
Sent: Monday, February 04, 2013 10:11 AM
To: user@hbase.apache.org
Subject: Start key and End key in HBase
Hi all,
Can anyone let me know what is the use of Start key and End key in HBase.
Regards
Raviprasad. T
Mobile :- 91- 9894769541
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
Visit us at http://www.polarisFT.com