I recently started testing HBase/Phoenix as a storage solution for our data. The problem is that I am not able to execute some "simple queries". I am using phoenix 4.5.2 and hbase 1.0.0-cdh5.4.0. After creating a table and making some selects (full scan), I started using local indexes to accelerate it. As I know, global indexes only work for covered queries, but:
Unlike global indexes, local indexes will use an index even when all columns referenced in the query are not contained in the index.
Knowing this, I prepared a simple test. A table with 3 columns: the primary key, a locally indexed column and a non indexed column.
Querying by the indexed column works as expected, but if I try to use both columns, it does a full scan.
I know that I can include both columns on the index, but this is not supposed to be required.
In a previous mail I wrote a more detailed example of the test: http://mail-archives.apache.org/mod_mbox/phoenix-user/201512.mbox/%3CCAOJgazo-oCahZxsXrdOOsJxm-DVp7SzcNZhDDNJ2DWzkiNhfvA%40mail.gmail.com%3E
Am I doing something wrong, or missing some step?
Or it is impossible what I am trying to do?
Is there some way to do this without include the other columns in the index?