[
https://issues.apache.org/jira/browse/PHOENIX-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16043824#comment-16043824
]
Rajeshbabu Chintaguntla commented on PHOENIX-3898:
--------------------------------------------------
There is local index column family but the local index data was not written
back because during compaction we might be seeking with wrong key that's what
causing it to skip rewriting the data. Looking into find the root cause.
> 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)
