phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vincent Poon (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (PHOENIX-2548) Local Indexing Not Looks Like Working As Expected
Date Tue, 31 Oct 2017 23:06:01 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-2548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Vincent Poon resolved PHOENIX-2548.
-----------------------------------
    Resolution: Duplicate

Closing, since in Phoenix 4.8+ , it just appears the explain is confusing, PHOENIX-3344

> Local Indexing Not Looks Like Working As Expected
> -------------------------------------------------
>
>                 Key: PHOENIX-2548
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2548
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.5.2
>            Reporter: Gokhan Cagrici
>            Assignee: Rajeshbabu Chintaguntla
>            Priority: Critical
>              Labels: verify
>             Fix For: 4.13.0
>
>
> Hi,
> We are accessing this table using a variety of different WHERE clauses and for each of
them, we are trying to create an appropriate index to avoid full table scan. Since there is
going to be almost 20 indexes, we tried to proceed with local indexing since there will be
a lot of writes.
> Here is the table definition:
> CREATE TABLE DEVICEDIM_TYPE1 (
>   TENANT_ID VARCHAR NOT NULL,
>   DEVICE_TYPE1_KEY BIGINT NOT NULL,
>   CLASSNAME VARCHAR(64),
>   DAY_IN_MONTH SMALLINT,
>   MONTH_NUMBER SMALLINT,
>   QUARTER_NUMBER SMALLINT,
>   YEAR SMALLINT,
>   WEEK_NUMBER SMALLINT,
>   YEAR_FOR_WEEK SMALLINT,
>   HOUR SMALLINT,
>   MINUTE SMALLINT,
>   IPADDRESS VARCHAR(50),
>   DEVICENAME VARCHAR(255),
>   MACADDRESS VARCHAR(30),
>   CONSTRAINT PK PRIMARY KEY (TENANT_ID, DEVICE_TYPE1_KEY)
> ) SALT_BUCKETS=4, COMPRESSION='GZ', VERSIONS=1, MULTI_TENANT=TRUE;
> And here is the index:
> create local index gokhan_ix2 on devicedim_type1 (devicename, macaddress)
> Now if I execute this:
> explain select devicename from devicedim_type1 where tenant_id = 'ccd' and devicename
= 'abc' and macaddress = 'afg'
> Here is the output:
> CLIENT 4-CHUNK PARALLEL 4-WAY RANGE SCAN OVER DEVICEDIM_TYPE1 [0,'ccd']
>     SERVER FILTER BY (DEVICENAME = 'abc' AND MACADDRESS = 'afg')
>     SERVER 100 ROW LIMIT
> CLIENT 100 ROW LIMIT
> I was expecting the index to be used. Am I wrong?



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message