phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <josh.el...@gmail.com>
Subject Re: HBase prefix scan.
Date Wed, 20 Jul 2016 04:14:26 GMT
Hi Ankit,

Assuming you provide some condition such as `WHERE ROWKEY_COLUMN like 
"9898989898_@#$%"` in your query, I believe Phoenix will automatically 
execute the query via a bounded range scan over that rowKey prefix.

You can verify this is happening by using the `explain <sql>` command.

ankit beohar wrote:
> 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