Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Thu, 5 Oct 2017 18:36:00 +0000 (UTC)
From: "James Taylor (JIRA)" <jira@apache.org>
To: dev@phoenix.apache.org
Message-ID: <JIRA.13107064.1507151270000.281771.1507228560047@Atlassian.JIRA>
In-Reply-To: <JIRA.13107064.1507151270000@Atlassian.JIRA>
References: <JIRA.13107064.1507151270000@Atlassian.JIRA> <JIRA.13107064.1507151270200@jira-lw-us.apache.org>
Subject: [jira] [Updated] (PHOENIX-4277) Treat delete markers consistently
 with puts for point-in-time scans
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Thu, 05 Oct 2017 18:36:05 -0000


     [ https://issues.apache.org/jira/browse/PHOENIX-4277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor updated PHOENIX-4277:
----------------------------------
    Summary: Treat delete markers consistently with puts for point-in-time scans  (was: Treat delete markers consistent with puts for point-in-time scans)

> Treat delete markers consistently with puts for point-in-time scans
> -------------------------------------------------------------------
>
>                 Key: PHOENIX-4277
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4277
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: Vincent Poon
>
> The IndexScrutinyTool relies on doing point-in-time scans to determine consistency between the index and data tables. Unfortunately, deletes to the tables cause a problem with this approach, since delete markers take effect even if they're at a later time stamp than the point-in-time at which the scan is being done (unless KEEP_DELETED_CELLS is true). The logic of this is that scans should get the same results before and after a compaction take place.
> Taking snapshots does not help with this since they cannot be taken at a point-in-time and the delete markers will act the same way - there's no way to guarantee that the index and data table snapshots have the same "logical" set of data.
> Using raw scans would allow us to see the delete markers and do the correct point-in-time filtering ourselves. We'd need to write the filters to do this correctly (see the Tephra TransactionVisibilityFilter for an implementation of this that could be adapted). We'd also need to hook this into Phoenix or potentially dip down to the HBase level  to do this.
> Thanks for brainstorming on this with me, [~lhofhansl].


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)