phoenix-dev mailing list archives

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

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

Mime
View raw message