[PHOENIX-1674] Snapshot isolation transaction support through Tephra

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: SFDC
• Assignee: Unassigned
• Reporter: James R. Taylor
• Created: 18/Feb/15 22:15
• Updated: 24/Aug/17 07:47
• Resolved: 13/Jan/16 02:20

Description

Tephra (http://tephra.io/ and https://github.com/caskdata/tephra) is one option for getting transaction support in Phoenix. Let's use this JIRA to discuss the way in which this could be integrated along with the pros and cons.

Issue Links

• is related to: HBASE-8927 Use nano time instead of mili time everywhere
• is related to: HBASE-11292 Add an "undelete" operation
• is related to: HBASE-12859 New master API to track major compaction completion
• relates to: PHOENIX-4119 Upsert uses timestamp of server holding table metadata
• links to: GitHub Pull Request #133

Sub-Tasks

• Specify ROW level conflict detection: Resolved
• Only sync table metadata when necessary: Resolved
• Support reading your own writes: Resolved
• Implement mechanism to convert a table from non transactional to transactional: Resolved
• Transactional mutable secondary indexes: Resolved
• Ensure that a point delete from the data table ends up as a point delete in the index table: Resolved
• Move TransactionService setup code into ConnectionQueryServicesTestImpl and/or BaseTest: Resolved
• Adjust MetaDataEndPointImpl timestamps if table is transactional: Resolved
• Set value in our empty key value to Tephra won't treat it like a column delete: Resolved
• Issue column family deletes instead of row deletes in PTableImpl: Closed
• Throw error if CURRENT_SCN is set on connection and an attempt is made to start a transaction: Resolved
• Increase testing around transaction integration: Resolved
• Performance test transaction implementation for immutable data: Resolved
• Do not perform conflict detection for append-only tables: Resolved
• Allow index without WAL codec if table is transactional: Resolved
• Create .py script in phoenix/bin to start transaction manager: Resolved
• Implement QueryPlan.getTableRefs(): Resolved
• Merge txn branch into master: Resolved
• Checkpoint transaction when necessary: Resolved
• Recreating a non-txn table as a txn table fails.: Resolved
• Perform additional scan in PhoenixTransactionalIndexer.getIndexUpdates() only if required: Resolved
• Set TRANSACTIONAL to true for derived views when transitioning to transactional table: Resolved
• Ensure commented out test snippets in TransactionIT pass after TEPHRA-143 is fixed: Resolved
• Use single byte value for empty key value: Resolved
• Rollback doesn't work when checkpointing is done: Resolved
• Prevent write of Tephra delete markers in preDelete to ensure current data state hasn't change: Resolved
• Set Tephra TTL based on HBase TTL: Resolved
• Do not require transaction manager to be run: Resolved
• Cleanup API for determining if non transactional mutable secondary index configured properly: Resolved
• Refactoring tests that start the txn manager to use BaseOwnClusterIT: Resolved
• Add tephra test dependency to pherf module: Resolved
• Add tephra test dependency to spark module: Resolved
• Modify pom to include tephra dependencies in server jar: Resolved
• Disallow usage of ROW_TIMESTAMP with transactional tables: Resolved
• Rows committed in transaction overlapping index creation are not populated: Resolved