You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Ankit Singhal (JIRA)" <ji...@apache.org> on 2017/05/31 09:10:04 UTC

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

Ankit Singhal created PHOENIX-3898:
--------------------------------------

             Summary: 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
             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 'T
{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)