[jira] [Commented] (PHOENIX-3898) Empty result set after split with local index on multi-tenant table

["James Taylor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16043713#comment-16043713 ] 

James Taylor commented on PHOENIX-3898:
---------------------------------------

That's a bit strange to query the index table directly, [~ankit@apache.org] (though still a bug, of course). Do you get the same behavior if you select from the data table? Any difference if you quit sqlline, start it again, and reissue the count query?

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