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

Empty result set after split with local index on multi-tenant table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • None
    • 4.11.0
    • None

    Description

      While testing encounters this(seems related to PHOENIX-3832):-

      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);
      
      0: jdbc:phoenix:localhost> select count(*) from tidx;
      +-----------+
      | COUNT(1)  |
      +-----------+
      | 300000    |
      +-----------+
      
      hbase(main):002:0> split 'TM'
      
      0: jdbc:phoenix:localhost> select count(*) from tidx;
      +-----------+
      | COUNT(1)  |
      +-----------+
      | 0         |
      +-----------+
      

      Attachments

        1. PHOENIX-3898.patch
          5 kB
          Rajeshbabu Chintaguntla
        2. PHOENIX-3898_v2.patch
          6 kB
          Rajeshbabu Chintaguntla
        3. PHOENIX-3898_v3.patch
          6 kB
          Rajeshbabu Chintaguntla

        Issue Links

          Activity

            People

              rajeshbabu Rajeshbabu Chintaguntla
              ankit@apache.org Ankit Singhal
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: