phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chinmay Kulkarni (Jira)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5796) Possible query optimization when query projects uncovered columns and queries on indexed columns
Date Mon, 23 Mar 2020 22:27:00 GMT
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)

Mime
View raw message