[
https://issues.apache.org/jira/browse/PHOENIX-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16043816#comment-16043816
]
Ankit Singhal commented on PHOENIX-3898:
----------------------------------------
bq. That's a bit strange to query the index table directly, Ankit Singhal
(though still a bug, of course).
Yeah, this is just for demonstration , I could show it with and without
NO_INDEX hint too.
bq. Do you get the same behaviour if you select from the data table?
if I do count(*) on data table with NO_INDEX hint, I'll get correct data which
is there in a data table column family.
bq. Any difference if you quit sqlline, start it again, and reissue the count
query
We checked after split that data for local index family is not even there in
physical HBase table
> 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
>
>
> 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)
