[jira] [Assigned] (PHOENIX-2582) Creating an index while a batch of rows is being written leads to missing rows in the index table

["Thomas D'Silva (JIRA)" <ji...@apache.org>]

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

Thomas D'Silva reassigned PHOENIX-2582:
---------------------------------------

    Assignee: Thomas D'Silva

> Creating an index while a batch of rows is being written leads to missing rows in the index table
> -------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-2582
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2582
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Thomas D'Silva
>            Assignee: Thomas D'Silva
>
> If we create an index while we are upserting rows to the table its possible we can miss writing corresponding rows to the index table. 
> If a region server is writing a batch of rows and we create an index just before the batch is written we will miss writing that batch to the index table. This is because we run the inital UPSERT SELECT to populate the index with an SCN that we get from the server which will be before the timestamp the batch of rows is written. 
> We need to figure out if there is a way to determine that are pending batches have been written before running the UPSERT SELECT to do the initial index population.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)