On Sunday, September 18, 2016, Cheyenne Forbes <
> - 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:
Otherwise, without other filters in your WHERE clause, your query will be a
full table scan.
> - is it recommended