phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3898) Empty result set after split with local index on multi-tenant table
Date Wed, 31 May 2017 09:10:04 GMT
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)

Mime
View raw message