[
https://issues.apache.org/jira/browse/PHOENIX-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16044702#comment-16044702
]
Rajeshbabu Chintaguntla commented on PHOENIX-3898:
--------------------------------------------------
The index id parsed from the index row was wrong for multi tenant tables. So
when there are no indexes mapped to index id that means the data is from
dropped index so will be skipped writing back during compaction. That's we are
not seeing any data. Fixing it.
> Empty result set after split with local index on multi-tenant table
> -------------------------------------------------------------------
>
> Key: PHOENIX-3898
> URL: https://issues.apache.org/jira/browse/PHOENIX-3898
> Project: Phoenix
> Issue Type: Bug
> Reporter: Ankit Singhal
> Assignee: Rajeshbabu Chintaguntla
> Priority: Blocker
> Fix For: 4.11.0
>
>
> While testing encounters this(seems related to PHOENIX-3832):-
> {code}
> CREATE TABLE IF NOT EXISTS TM (PKA CHAR(15) NOT NULL, PKF CHAR(3) NOT
> NULL,PKP CHAR(15) NOT NULL, CRD DATE NOT NULL, EHI CHAR(15) NOT NULL, FID
> CHAR(15), CREATED_BY_ID VARCHAR,FH VARCHAR, DT VARCHAR, OS VARCHAR, NS
> VARCHAR, OFN VARCHAR CONSTRAINT PK PRIMARY KEY ( PKA, PKF, PKP, CRD DESC, EHI
> )) VERSIONS=1 ,MULTI_TENANT=true;
> CREATE LOCAL INDEX IF NOT EXISTS TIDX ON TM (PKF, CRD, PKP, EHI);
> {code}
> {code}
> 0: jdbc:phoenix:localhost> select count(*) from tidx;
> +-----------+
> | COUNT(1) |
> +-----------+
> | 300000 |
> +-----------+
> {code}
> {code}
> hbase(main):002:0> split 'TM'
> {code}
> {code}
> 0: jdbc:phoenix:localhost> select count(*) from tidx;
> +-----------+
> | COUNT(1) |
> +-----------+
> | 0 |
> +-----------+
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
