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)