Hi, We recently published a blog post on how we transformed Apache Phoenix into a Document Database while retaining the power of SQL. The data type support we introduced in Phoenix could also be done in HBase.
However, for all the features that Phoenix complements HBase with (e.g. global consistent secondary indexes, sparse indexes, uncovered indexes, change data capture, multi-tenancy etc), it felt more compelling to introduce document data support in Phoenix. Our learnings from MongoDB, Amazon DocumentDB, DynamoDB combined with existing SQL support in Phoenix helped us make Phoenix a very unique database that provides Document database semantics using SQL. Blog post: https://engineering.salesforce.com/evolving-apache-phoenix-overcoming-5-challenges-to-add-document-data-support/ More technical details: https://engineering.salesforce.com/wp-content/uploads/2024/11/Phoenix-as-Document-Database.pdf
