Congratulations, James. We will surely benefit from this tool.
On Wed, Jan 30, 2013 at 1:04 PM, James Taylor <jtay...@salesforce.com> 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 > 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
