[jira] [Updated] (PHOENIX-2440) Document transactional behavior

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor updated PHOENIX-2440:
----------------------------------
    Issue Type: Task  (was: Sub-task)
        Parent:     (was: PHOENIX-1674)

> Document transactional behavior
> -------------------------------
>
>                 Key: PHOENIX-2440
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2440
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: James Taylor
>            Assignee: Thomas D'Silva
>
> We need to add a new top level page to explain transactions and their behavior from the user point of view:
> - How to configure a new/existing table to be transactional (CREATE TABLE and ALTER TABLE ... TRANSACTIONAL=true). Also that it's currently a one-way street - you cannot make a transactional table non transactional (PHOENIX-2439).
> - Transaction implicitly started when first statement run against a transactional table
> - Indexes on transactional table are transactional with data table.
> - Exception raised if transaction committed that conflicts (at row level) with other committed transaction.
> - REPEATABLE_READ: Queries do not see commits of other transactions until transaction is ended (rolled back or committed).
> - Transaction will see their own updates (read-your-own-write behavior).
> - Requires that transaction manager is started (and how to start it).
> - Various configuration options specific to transactions
> - Invalid list - how it can potentially grow and how to manually clear it if necessary.
> - Unsupported behavior: for example, certain TTL behavior, no SCN.
> We also need to adjust existing web pages that currently says we don't support full ACID and promote this new capability.



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