You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Mujtaba Chohan (JIRA)" <ji...@apache.org> on 2017/05/05 18:58:04 UTC
[jira] [Created] (PHOENIX-3832) Local Index - Empty resultset for
multi-tenant tables
Mujtaba Chohan created PHOENIX-3832:
---------------------------------------
Summary: Local Index - Empty resultset for multi-tenant tables
Key: PHOENIX-3832
URL: https://issues.apache.org/jira/browse/PHOENIX-3832
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.10.0
Reporter: Mujtaba Chohan
Assignee: Rajeshbabu Chintaguntla
Fix For: 4.11
Schema
{noformat}
CREATE TABLE IF NOT EXISTS T (PKA CHAR(15) NOT NULL, PKF CHAR(3) NOT NULL,
PKP CHAR(15) NOT NULL, CRD DATE NOT NULL, EHI CHAR(15) NOT NULL, STD_COL VARCHAR, INDEXED_COL INTEGER,
CONSTRAINT PK PRIMARY KEY ( PKA, PKF, PKP, CRD DESC, EHI))
VERSIONS=1,MULTI_TENANT=true,IMMUTABLE_ROWS=true;
CREATE LOCAL INDEX IF NOT EXISTS TIDX ON T (INDEXED_COL);
{noformat}
Query
{noformat}
SELECT * FROM T WHERE INDEXED_COL < 1
{noformat}
Resultset is empty for all columns other than PK and indexed column. This is on a single region table.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)