James Taylor created PHOENIX-2440:
-------------------------------------

             Summary: Document transactional behavior
                 Key: PHOENIX-2440
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2440
             Project: Phoenix
          Issue Type: Sub-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)

Reply via email to