Details
-
Wish
-
Status: Resolved
-
Trivial
-
Resolution: Won't Fix
-
None
-
None
-
None
Description
Implement a query language.
We can do some basic selection/projection and roll-up using iterators.
I'm thinking something like:
using LatLonRow; SELECT * WHERE row MATCHES LatLonRow.ranges('0.0', '0.0', '0.25', '0.25') AND columnFamily == 'mapLevel2' ;
Given a table structure, we can support the expressiveness of JEXL and the wikisearch example.
using ShardDocument; SELECT ShardDocument.document(row) WHERE row MATCHES ShardDocument.ranges('1990-01-01', '2012-11-10') AND ShardDocument.jexl( 'author ~= ".*Adams" and body = "don't" and body = 'panic' );
I'm sure the syntax is highly suspect, but abuse of the index as well as the indexing structure ought to be something expressible to mere mortals.