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

Reply via email to