Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-5589

GlobalIndexChecker does not populate global index related attributes for certain queries

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 4.15.0
    • 4.15.0, 5.1.0
    • None
    • None

    Description

      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 Ozdemir

      Attachments

        1. PHOENIX-5589.4.x-HBase-1.5.001.patch
          7 kB
          Kadir OZDEMIR
        2. PHOENIX-5589.master.001.patch
          7 kB
          Kadir OZDEMIR
        3. PHOENIX-5589.master.002.patch
          7 kB
          Kadir OZDEMIR
        4. PHOENIX-5589.master.004.patch
          7 kB
          Kadir OZDEMIR
        5. PHOENIX-5589.master.005.patch
          7 kB
          Kadir OZDEMIR

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            kozdemir Kadir OZDEMIR
            jisaac Jacob Isaac
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 3h
                3h

                Issue deployment