[jira] [Commented] (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:comment-tabpanel&focusedCommentId=15113869#comment-15113869 ] 

James Taylor commented on PHOENIX-2440:
---------------------------------------

[~tdsilva] - I started the documentation off here: https://phoenix.apache.org/transactions.html with the minimum so that users can at least try transactions with our RC. Needs to be expanded upon to include all of the above (i.e. I didn't mention conflict detection and other details). Probably more examples would be good. Maybe a link to what ACID means (on wikipedia)?

> 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.
> - 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)