I actually just got a prototype working that loads up HBase data through Phoenix into Spark for analytics.
So far the results look very promising. Across millions of rows, we're getting queries back in the orders of single seconds.
I'm also able to get millions of rows back on specific, unindexed queries (e.g. "SELECT * FROM EVENTS WHERE TYPE = 'some_type'"), and can run analytics across that data in under a minute per run.
The previous comparison to CQL for Cassandra is apt, though I've found the builtin functions and grammar to be a lot more powerful.
So far the results look very promising. Across millions of rows, we're getting queries back in the orders of single seconds.
I'm also able to get millions of rows back on specific, unindexed queries (e.g. "SELECT * FROM EVENTS WHERE TYPE = 'some_type'"), and can run analytics across that data in under a minute per run.
The previous comparison to CQL for Cassandra is apt, though I've found the builtin functions and grammar to be a lot more powerful.