You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Chinmay Kulkarni (Jira)" <ji...@apache.org> on 2019/12/21 00:57:06 UTC
[jira] [Closed] (PHOENIX-5589) GlobalIndexChecker does not populate
global index related attributes for certain queries
[ https://issues.apache.org/jira/browse/PHOENIX-5589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chinmay Kulkarni closed PHOENIX-5589.
-------------------------------------
Bulk closing Jiras for the 4.15.0 release.
> GlobalIndexChecker does not populate global index related attributes for certain queries
> ----------------------------------------------------------------------------------------
>
> Key: PHOENIX-5589
> URL: https://issues.apache.org/jira/browse/PHOENIX-5589
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.15.0
> Reporter: Jacob Isaac
> Assignee: Kadir OZDEMIR
> Priority: Blocker
> Fix For: 4.15.0, 5.1.0
>
> Attachments: PHOENIX-5589.4.x-HBase-1.5.001.patch, PHOENIX-5589.master.001.patch, PHOENIX-5589.master.002.patch, PHOENIX-5589.master.004.patch, PHOENIX-5589.master.005.patch
>
> Time Spent: 3h
> Remaining Estimate: 0h
>
> To reproduce:
> CREATE TABLE IF NOT EXISTS "TEST_ENTITY"."T_T000001"(OID CHAR(15) NOT NULL,KP CHAR(3) NOT NULL, COL1 VARCHAR,COL2 VARCHAR,COL3 VARCHAR CONSTRAINT pk PRIMARY KEY (OID,KP)) COLUMN_ENCODED_BYTES=0, MULTI_TENANT=true,DEFAULT_COLUMN_FAMILY='Z';
> CREATE VIEW IF NOT EXISTS "TEST_ENTITY"."V_T000001"(ID CHAR(15) NOT NULL,COL4 VARCHAR,COL5 VARCHAR,COL6 VARCHAR CONSTRAINT pk PRIMARY KEY (ID)) AS SELECT * FROM "TEST_ENTITY"."T_T000001" WHERE KP = '0EC';
> CREATE INDEX IF NOT EXISTS IDX_V_T000001 ON "TEST_ENTITY"."V_T000001"(COL4) INCLUDE (COL6) ;
> CREATE VIEW IF NOT EXISTS "TEST_ENTITY"."0EC"(ZID CHAR(15),COL7 VARCHAR,COL8 VARCHAR,COL9 VARCHAR) AS SELECT * FROM "TEST_ENTITY"."V_T000001";
> UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z1','1','g1','h1','i1');
> UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z2','2','g2','h2','i2');
> UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z3','3','g3','h3','i3');
> UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z4','4','g4','h4','i4');
> UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z5','5','g5','h5','i5');
> When running the following queries (COL6 is the included col, COL4 is the indexed column)
> select COL6 from "TEST_ENTITY"."0EC" where COL4 = 'g3';
> The scan attributes are not properly set. (i.e for eg CHECK_VERIFY_COLUMN is not set)
> [~kadir]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)