phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: HBase prefix scan.
Date Tue, 19 Jul 2016 09:43:07 GMT
Hi Ankit,

My impression is that Phoenix will automatically do that for you. I guess
989898989898 is part of your key, right? So "select * from table where key
like '989898989%'" will trigger the use of a prefix filter on Phoenix. It
will even do a range scan where 9898989898 will be the starting row.

JMS

2016-07-19 5:38 GMT-04:00 ankit beohar <ankitbeohar90@gmail.com>:

> Hi All,
>
> How can I achieve HBase Prefix Filter in Phoenix query.
> My rowkey is 9898989898_@#$_ABC I want all records of 9898989898_@#$
> which is achieve in Hbase through prefix filter I need same in Phoenix
> query.
>
> Best Regards,
> ANKIT BEOHAR
>
>

Mime
View raw message