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
