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

No read repair happens when scans filter rows based on a covered column

    XMLWordPrintableJSON

Details

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

    Description

      Assume that the schema for a data and index table is as follows:

      create table datatable (id varchar(10) not null primary key, val1 varchar(10), val2 varchar(10), val3 varchar(10))

      create index indextable on datatable (val1) include (val2, val3)

      A query that filters rows on a covered column does not trigger the index read repair for unverified index rows. For example, the following query will not trigger the read repair

      select val2, val3 from datatable WHERE val1 = 'ab' and val2 = 'abc'

       

      Attachments

        1. PHOENIX-5597.4.x-HBase-1.5.001.patch
          22 kB
          Kadir OZDEMIR
        2. PHOENIX-5597.4.x-HBase-1.5.002.patch
          25 kB
          Kadir OZDEMIR
        3. PHOENIX-5597.master.001.patch
          22 kB
          Kadir OZDEMIR

        Issue Links

          Activity

            People

              kozdemir Kadir OZDEMIR
              kozdemir Kadir OZDEMIR
              Votes:
              0 Vote for this issue
              Watchers:
              5 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 - 1h 10m
                  1h 10m