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:11:04 UTC
[jira] [Updated] (PHOENIX-3898) Empty result set after split with
local index on multi-tenant table
[ https://issues.apache.org/jira/browse/PHOENIX-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ankit Singhal updated PHOENIX-3898:
-----------------------------------
Description:
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}
was:
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}
> 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 '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)