Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase, mail # user - Announcing Phoenix: A SQL layer over HBase


Copy link to this message
-
Announcing Phoenix: A SQL layer over HBase
James Taylor 2013-01-30, 21:04
We are pleased to announce the immediate availability of a new open
source project, Phoenix, a SQL layer over HBase that powers the HBase
use cases at Salesforce.com. We put the SQL back in the NoSQL:

  * Available on GitHub at https://github.com/forcedotcom/phoenix
  * Embedded JDBC driver implements the majority of java.sql interfaces,
    including the metadata APIs.
  * Built for low latency queries through parallelization, the use of
    native HBase APIs, coprocessors, and custom filters.
  * Allows columns to be modelled as a multi-part row key or key/value
    cells.
  * Full query support with predicate push down and optimal scan key
    formation.
  * DDL support: CREATE TABLE, DROP TABLE, and ALTER TABLE for
    adding/removing columns.
  * Versioned schema repository. Snapshot queries use the schema that
    was in place when data was written.
  * 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.
  * Limited transaction support through client-side batching.
  * Single table only - no joins yet and secondary indexes are a work in
    progress.
  * Follows ANSI SQL standards whenever possible
  * Requires HBase v 0.94.2 or above
  * BSD-like license
  * 100% Java

Join our user groups:
     Phoenix HBase User:
https://groups.google.com/forum/#!forum/phoenix-hbase-user
     Phoenix HBase Dev:
https://groups.google.com/forum/#!forum/phoenix-hbase-dev
and check out our roadmap:
https://github.com/forcedotcom/phoenix/wiki#wiki-roadmap

We welcome feedback and contributions from the community to Phoenix and
look forward to working together.

Regards,

James Taylor
@JamesPlusPlus