Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Fri, 9 Jun 2017 18:20:18 +0000 (UTC)
From: "Rajeshbabu Chintaguntla (JIRA)" <jira@apache.org>
To: dev@phoenix.apache.org
Message-ID: <JIRA.13076137.1496221755000.41148.1497032418468@Atlassian.JIRA>
In-Reply-To: <JIRA.13076137.1496221755000@Atlassian.JIRA>
References: <JIRA.13076137.1496221755000@Atlassian.JIRA> <JIRA.13076137.1496221755497@jira-lw-us.apache.org>
Subject: [jira] [Updated] (PHOENIX-3898) Empty result set after split with
 local index on multi-tenant table
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 09 Jun 2017 18:20:24 -0000


     [ https://issues.apache.org/jira/browse/PHOENIX-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajeshbabu Chintaguntla updated PHOENIX-3898:
---------------------------------------------
    Attachment: PHOENIX-3898_v2.patch

[~jamestaylor] Here is the patch removes unnecessary code is getting view index from row key. We can directly get first two bytes from row key after removing the region start key. For salted we need to get two bytes after salted byte and we don't need all these extra logic. 

> 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)