You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Geoffrey Jacoby (JIRA)" <ji...@apache.org> on 2018/11/14 00:02:00 UTC

[jira] [Created] (PHOENIX-5018) Index mutations created by IndexTool will have wrong timestamps

Geoffrey Jacoby created PHOENIX-5018:
----------------------------------------

             Summary: Index mutations created by IndexTool will have wrong timestamps
                 Key: PHOENIX-5018
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5018
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 5.0.0, 4.14.0
            Reporter: Geoffrey Jacoby
            Assignee: Geoffrey Jacoby


When doing a full rebuild (or initial async build) on an index using the IndexTool and PhoenixIndexImportDirectMapper, we generate the index mutations by creating an UPSERT SELECT query from the base table to the index, then taking the Mutations from it and inserting it directly into the index via an HBase HTable. 

The timestamps of the Mutations use the default HBase behavior, which is to take the current wall clock. However, the timestamp of an index KeyValue should use the timestamp of the initial KeyValue in the base table.

Having base table and index timestamps out of sync can cause all sorts of weird side effects, such as if the base table has data with an expired TTL that isn't expired in the index yet. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)