ALTER TABLE HBASE OPTIONS command
Add the ability to change HBase table options for a Trafodion table or index to the ALTER TABLE or INDEX DDL statement.
Blueprint information
- Status:
- Started
- Approver:
- Suresh Subbiah
- Priority:
- Undefined
- Drafter:
- Dave Birdsall
- Direction:
- Needs approval
- Assignee:
- Dave Birdsall
- Definition:
- Approved
- Series goal:
- None
- Implementation:
- Good progress
- Milestone target:
- r2.0
- Started by
- Dave Birdsall
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
In design
Gerrit topic: https:/
Addressed by: https:/
Part 1 of ALTER TABLE/INDEX ALTER HBASE_OPTIONS support
Addressed by: https:/
Part 2 of ALTER TABLE/INDEX ALTER HBASE_OPTIONS support
Two pieces of work remain:
1. Add a transactional flavor of ALTER TABLE/INDEX ALTER HBASE_OPTIONS. A key concern here is how to do a rollback in the event of a transaction abort. We must somehow know what state the object was in from an HBase perspective to do this rollback. Fortunately, HBase gives us this information: At the start of the operation we retrieve the table and column descriptors. If we retain these, this is exactly the state we want to return to on rollback.
2. A reviewer (Hans Zeller) suggested extending the syntax to allow removing HBase attributes. I had not thought of this when designing Part 1, as I did not even know that HBase supports this. But it turns out it does! In the HBase shell, one can use the 'table_att_unset' method name to remove a table attribute. At the HBase client level, one calls the remove method on the HTableDescriptor before calling the HBaseAdmin.