Phoenix: A SQL layer over HBase 'We put the SQL back in the NoSQL'

 

Phoenix is a SQL layer over HBase, delivered as a client-embedded JDBC driver, powering the HBase use cases at Salesforce.com. Phoenix targets low-latency queries (milliseconds), as opposed to batch operation via map/reduce. To see what's supported, go to our language reference guide, and read more on our wiki.

http://forcedotcom.github.com/phoenix/

https://github.com/forcedotcom/phoenix

Commands

SELECT
UPSERT VALUES
UPSERT SELECT
DELETE
CREATE
DROP
ALTER TABLE
EXPLAIN

Other Grammar

Constraint
Table Options
Options
Column
Select Expression
Split Point
Table Expression
Order
Expression
And Condition
Condition
Compare
Operand
Summand
Factor
Term
Bind Parameter
Value
Case
Case When
Name
Quoted Name
Alias
Null
Data Type
String
Boolean
Numeric
Int
Long
Decimal
Number
Comments

 

Aggregate Functions

AVG
COUNT
MAX
MIN
SUM

String Functions

SUBSTR
TRIM
LTRIM
RTRIM
LENGTH
REGEXP_SUBSTR
REGEXP_REPLACE

Time and Date Functions

ROUND
TRUNCATE
TO_CHAR
TO_DATE
CURRENT_DATE
CURRENT_TIME

Index

INTEGER Type
UNSIGNED_INT Type
BIGINT Type
UNSIGNED_LONG Type
DECIMAL Type
BOOLEAN Type
TIME Type
DATE Type
TIMESTAMP Type
VARCHAR Type
CHAR Type
BINARY Type