hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Ambrose <pambr...@mac.com>
Subject Re: [Announce] HBql
Date Tue, 05 Jan 2010 22:26:48 GMT

On Jan 5, 2010, at 2:08 PM, Gibbon, Robert, VF-Group wrote:

> Woaaa this looks awesome! Questions follow


> * CREATE INDEX - works with vanilla Hbase or needs Transactional Hbase? Builds indexes
as hbase tables? update triggers/scheduled rebuild of the indexes too?

I am simply calling the existing hbase index support: http://tinyurl.com/yanfslo
Note that using indexes requires some enabling 
(as described in the above link and here: http://www.hbql.com/installation.html).

> * Query plans and optimization are now managed by HBQL? User doesn't have to worry about

The queries are still Gets and Scans (as determined by the KEYS clause of the query) and 
the server and client filters are executed as either a SingleColumnValueFilter  or 
as an HBql RecordFilter (depending on the complexity of the expression).

To be clear, I am not looking at the query and seeing if any indexes apply and then 
optimizing the query accordingly.   This is still baby steps time... :-)


> R
> -----Original Message-----
> From: Paul Ambrose [mailto:pambrose@mac.com]
> Sent: Tue 1/5/2010 9:49 PM
> To: hbase-user@hadoop.apache.org
> Subject: [Announce] HBql
> Hi,
> I have been working on an abstraction layer for HBase that I hope 
> HBase users will find helpful.
> Highlights include:
> * A dialect of SQL for HBase (usable in the console, scripts, and code)
> * JDBC bindings
> * JDBC-like bindings that support annotated objects and generics
> * Query Executors that make threaded result reading simple
> * Simplified filter writing for server and/or client
> * Index support 
> HBql is a work in progress and I am open to feedback and suggestions.
> I am still working on the docs, so the examples and javadocs are pretty lame.
> Have a look at: http://www.hbql.com
> Cheers,
> Paul

View raw message