[ 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)