phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3898) Empty result set after split with local index on multi-tenant table
Date Fri, 09 Jun 2017 18:23:21 GMT

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

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

+1. Yes that's better/simpler. Thanks!

> 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
>
>         Attachments: PHOENIX-3898.patch, PHOENIX-3898_v2.patch
>
>
> 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)

Mime
View raw message