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

Data missing when using local index

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 4.2.1, 4.2.2
    • 4.3.0
    • None
    • None
    • ubuntu
      HBase 0.98.7
      Hadoop 2.5.1
      OS: ubuntu

    Description

      1. crate a table by the schema as below:
      CREATE TABLE IF NOT EXISTS Miss_data_table(
      a BIGINT NOT NULL,
      b VARCHAR,
      c INTEGER,
      d INTEGER,
      e INTEGER,
      f INTEGER,
      g VARCHAR,
      h VARCHAR,
      i INTEGER,
      j VARCHAR,
      k INTEGER,
      l VARCHAR,
      m VARCHAR,
      n INTEGER,
      o INTEGER,
      p VARCHAR,
      q VARCHAR,
      r INTEGER,
      s BIGINT,
      t VARCHAR CONSTRAINT pk PRIMARY KEY(a))

      2.create local index for the table with column: q
      create local index idx_q on Miss_data_table (q);

      3.upsert data into table.
      upsert into Miss_data_table values(96660688,'hello/TEST-0',156,-1,-1,0,'2013-02-14 18:34:05.0','TEST-1',0,'495839182',0,'50','',0,0,'1818378','102218',0,26,'20141201')

      4. execute querys...
      select a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t from Miss_data_table where q = '102218';

      ----------------------------------------------------------------------------------------------------+

      A B C D E F G H I J K L M N O P Q R S T

      ----------------------------------------------------------------------------------------------------+

      96660688 hello/TEST-0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 102218 NULL 26 20141201

      ----------------------------------------------------------------------------------------------------+

      select a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t from Miss_data_table where a=96660688;
      -------------------------------------------------------------------------------------------------------------------------------+

      A B C D E F G H I J K L M N O P Q R S T

      -------------------------------------------------------------------------------------------------------------------------------+

      96660688 hello/TEST-0 156 -1 -1 0 2013-02-14 18:34:05.0 TEST-1 0 495839182 0 50 NULL 0 0 1818378 102218 0 26 20141201

      -------------------------------------------------------------------------------------------------------------------------------+

      // execute the query plain ,it shows we fetch data by local index.

      explain select a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t from Miss_data_table where q = '102218';
      ------------------------------------------

      PLAN

      ------------------------------------------

      CLIENT 1-CHUNK PARALLEL 1-WAY RANGE SCAN OVER _LOCAL_IDX_TEST.MISS_DATA_TABLE [-32768,'102218']
      CLIENT MERGE SORT

      ------------------------------------------

      Attachments

        1. PHOENIX-1570.patch
          2 kB
          James R. Taylor
        2. PHOENIX-1570_v6.patch
          17 kB
          James R. Taylor
        3. PHOENIX-1570_v5.patch
          17 kB
          Wei Xue
        4. PHOENIX-1570_v4.patch
          24 kB
          James R. Taylor
        5. PHOENIX-1570_v3.patch
          22 kB
          James R. Taylor
        6. PHOENIX-1570_v2.patch
          4 kB
          James R. Taylor
        7. FetchDataByLocalIndexIT.java
          5 kB
          wuchengzhi
        8. 1570.patch
          3 kB
          Wei Xue

        Issue Links

          Activity

            People

              maryannxue Wei Xue
              bdifn wuchengzhi
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: