You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Kadir OZDEMIR (Jira)" <ji...@apache.org> on 2019/11/28 00:12:01 UTC

[jira] [Created] (PHOENIX-5597) No read repair happens when scans filter rows based on a covered column

Kadir OZDEMIR created PHOENIX-5597:
--------------------------------------

             Summary: No read repair happens when scans filter rows based on a covered column
                 Key: PHOENIX-5597
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5597
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.14.3, 5.0.0
            Reporter: Kadir OZDEMIR
            Assignee: Kadir OZDEMIR
             Fix For: 4.15.0, 5.1.0


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'

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)