[jira] [Created] (PHOENIX-5796) Possible query optimization when query projects uncovered columns and queries on indexed columns

[Chinmay Kulkarni (Jira)]

Chinmay Kulkarni created PHOENIX-5796:
-----------------------------------------

             Summary: Possible query optimization when query projects uncovered 
columns and queries on indexed columns
                 Key: PHOENIX-5796
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5796
             Project: Phoenix
          Issue Type: Improvement
    Affects Versions: 4.15.0, 5.0.0
            Reporter: Chinmay Kulkarni
         Attachments: Screen Shot 2020-03-23 at 3.25.38 PM.png, Screen Shot 
2020-03-23 at 3.25.38 PM.png

Start HBase-1.3 server with Phoenix-4.15.0-HBase-1.3 server jar. Connect to it 
using sqlline.py which has Phoenix-4.15.0-HBase-1.3 Phoenix client.

Create a base table like:
{code:sql}
create table t (a integer primary key, b varchar(10), c integer);
{code}

Create an uncovered index on top of it like:
{code:sql}
create index uncov_index_t on t(b);
{code}

Now if you issue the query:
{code:sql}
explain select c from t where b='abc';
{code}




--
This message was sent by Atlassian Jira
(v8.3.4#803005)