O'Reilly logo

HBase Design Patterns by Sujee Maniyam, Mark Kerzner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Project Phoenix — a SQL for HBase

Phoenix is a relatively recent project that represents a SQL layer over HBase. Its blog is at http://phoenix-hbase.blogspot.com/, and it was first announced at this blog on January 30, 2013.

Here is a brief list of only some of the capabilities that it gives you:

  • Phoenix allows columns to be modeled as a multi-part row key or key/value cells
  • It provides full query support with predicate pushdown and optimal scan key formation
  • It provides DDL support (CREATE TABLE, DROP TABLE, and ALTER TABLE) to add/remove columns
  • It provides DML support, UPSERT VALUES for row-by-row insertion, UPSERT SELECT for mass data transfer between the same or different tables, and DELETE for deleting rows

Most importantly, it does not provide ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required