On Jan 5, 2010, at 2:08 PM, Gibbon, Robert, VF-Group wrote: > Woaaa this looks awesome! Questions follow >
Thanks. > * 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 that? > 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... :-) Cheers, Paul > THANKS FOR MAKING THIS YOU STAR > > R > > -----Original Message----- > From: Paul Ambrose [mailto:[email protected]] > Sent: Tue 1/5/2010 9:49 PM > To: [email protected] > 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 >
