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

Rajeshbabu Chintaguntla updated PHOENIX-3898:
---------------------------------------------
    Attachment: PHOENIX-3898.patch

[~jamestaylor] Here is the patch fixes the issue. Please review.

> 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
>
>         Attachments: PHOENIX-3898.patch
>
>
> 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)

Reply via email to