Re: Phoenix "LIKE 'query%' " performance

2016-09-18 Thread James Taylor
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

Phoenix "LIKE 'query%' " performance

2016-09-18 Thread Cheyenne Forbes
- Can it be fast? - does it use the Hbase regex feature? - how can I make it case insensitive? so when I do "LIKE 'query%' " the results include "Query" - Can I get millisecond results using "WHERE column LIKE" on a large table? couple terabytes of data - is it recommended