Hacker News Reader

For those know a bit more, is this basically equivalent to CQL for Cassandra except for HBase?

Phoenix supports richer SQL syntax - joins, derived tables, subqueries, indexes, views, functions.