accumulo-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Vines (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ACCUMULO-1014) query language
Date Mon, 04 Feb 2013 14:56:17 GMT

    [ https://issues.apache.org/jira/browse/ACCUMULO-1014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13570312#comment-13570312
] 

John Vines commented on ACCUMULO-1014:
--------------------------------------

Because pig and hive fall back to using mayo reduce to do their queries. If
we do this, we should do something more realtime.

Sent from my phone, please pardon the typos and brevity.


                
> query language
> --------------
>
>                 Key: ACCUMULO-1014
>                 URL: https://issues.apache.org/jira/browse/ACCUMULO-1014
>             Project: Accumulo
>          Issue Type: Improvement
>          Components: client
>            Reporter: Eric Newton
>            Assignee: Billie Rinaldi
>             Fix For: 1.6.0
>
>
> Implement a query language.
> We can do some basic selection/projection and roll-up using iterators.
> I'm thinking something like:
> {noformat}
> using LatLonRow;
> SELECT * 
>  WHERE row MATCHES LatLonRow.ranges('0.0', '0.0', '0.25', '0.25')
>    AND columnFamily == 'mapLevel2'
> ;
> {noformat}
> Given a table structure, we can support the expressiveness of JEXL and the wikisearch
example.
> {noformat}
> 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'
>       );
> {noformat}
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message