On Sunday, September 18, 2016, Cheyenne Forbes <
cheyenne.osanu.for...@gmail.com> wrote:
>
>- Can it be fast?
>- does it use the Hbase regex feature?
>
> It's a similar implementation, but with some optimizations around the
prefix patterns mentioned below.
>
>- how can I make it case insensitive? so when I do "LIKE 'query%' "
>the results include "Query"
>
> Use ILIKE for case insensitive search. Until PHOENIX-1291 gets
implemented, prefix ILIKE patterns as described below will be full table
scans (i.e. slow).
>
>- Can I get millisecond results using "WHERE column LIKE" on a large
>table? couple terabytes of data
>
> If you have have a prefix LIKE pattern (i.e. pkCol LIKE 'XAVIER%') where
the data is significantly filtered based based on leading with the prefix,
then it can be reasonably fast (but still not like a point lookup).
If you have a few particular LIKE patterns you need to be very fast, you
could add functional indexes for them:
http://phoenix.apache.org/secondary_indexing.html#Functional_Index
Otherwise, without other filters in your WHERE clause, your query will be a
full table scan.
>
>- is it recommended
>
>