phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacobo Coll <>
Subject Local index not used with non covered queries
Date Wed, 03 Feb 2016 12:01:42 GMT

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:

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?

Jacobo Coll

View raw message