Return-Path: X-Original-To: apmail-hbase-dev-archive@www.apache.org Delivered-To: apmail-hbase-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 63B6EE92C for ; Wed, 30 Jan 2013 22:37:28 +0000 (UTC) Received: (qmail 98453 invoked by uid 500); 30 Jan 2013 22:37:27 -0000 Delivered-To: apmail-hbase-dev-archive@hbase.apache.org Received: (qmail 98401 invoked by uid 500); 30 Jan 2013 22:37:27 -0000 Mailing-List: contact dev-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hbase.apache.org Delivered-To: mailing list dev@hbase.apache.org Delivered-To: moderator for dev@hbase.apache.org Received: (qmail 55619 invoked by uid 99); 30 Jan 2013 21:05:06 -0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jtaylor@salesforce.com designates 64.18.3.86 as permitted sender) Message-ID: <51098AE5.3040805@salesforce.com> Date: Wed, 30 Jan 2013 13:04:37 -0800 From: James Taylor User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130106 Thunderbird/17.0.2 MIME-Version: 1.0 To: HBase User , HBase Dev Subject: Announcing Phoenix: A SQL layer over HBase Content-Type: multipart/alternative; boundary="------------020809020801090309000106" X-Virus-Checked: Checked by ClamAV on apache.org --------------020809020801090309000106 Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit 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 --------------020809020801090309000106--