Congratulations, James. We will surely benefit from this tool.
On Wed, Jan 30, 2013 at 1:04 PM, James Taylor <[EMAIL PROTECTED]> wrote:
> 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
> * Full query support with predicate push down and optimal scan key
> * 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
> * 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:
> Phoenix HBase Dev:
> and check out our roadmap:
> We welcome feedback and contributions from the community to Phoenix and look
> forward to working together.
> James Taylor