3 ms·
There are some SQL databases build on top of HBase. HBase and the whole Hadoop ecosystem is not what I'd call easy, but once you are familiar with it, scaling i
by lukaslalinsky 11y ago
There are some SQL databases build on top of HBase. HBase and the whole Hadoop ecosystem is not what I'd call easy, but once you are familiar with it, scaling it is relatively easy (probably still not as easy as Cassandra, thanks to the fact that Cassandra always hashes things and does not allow sorted range scans).
I'm currently experimenting with Phoenix, because it's a relatively thin layer above HBase, but it doesn't provide many features that you expect in relational databases like transactions. SELECT support is quite complete, it can do JOINs, subqueries, etc.
I have recently discovered Trafodion which looks like a much more complete relational database, but at the expense of no longer being just a HBase client.
http://phoenix.apache.org/ http://phoenix.apache.org/
https://wiki.trafodion.org/wiki/index.php/Main_Page https://wiki.trafodion.org/wiki/index.php/Main_Page
https://vimeo.com/128190098 https://vimeo.com/128190098