lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joel Bernstein (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (SOLR-9916) Add arithmetic operations to the SelectStream
Date Fri, 06 Jan 2017 01:44:59 GMT

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

Joel Bernstein edited comment on SOLR-9916 at 1/6/17 1:44 AM:
--------------------------------------------------------------

Here is the full expression:

{code}
having(rollup(over=a_f, 
              sum(a_i), 
              search(collection1 q=*:*, fl="id,a_s,a_i,a_f", sort="a_f asc")), 
       eq(sum(a_i), 9)))

{code}

So the "sum(a_i)" is the field in the tuples produced by the rollup.


was (Author: joel.bernstein):
Here is the full expression:

{code}
having(rollup(over=a_f, 
              sum(a_i), 
              search(collection1 q=*:*, fl="id,a_s,a_i,a_f", sort="a_f asc")), 
       eq(sum(a_i), 9)))

{code}

So the having is 

> Add arithmetic operations to the SelectStream
> ---------------------------------------------
>
>                 Key: SOLR-9916
>                 URL: https://issues.apache.org/jira/browse/SOLR-9916
>             Project: Solr
>          Issue Type: New Feature
>      Security Level: Public(Default Security Level. Issues are Public) 
>            Reporter: Joel Bernstein
>
> One of the things that will be needed as the SQL implementation matures is the ability
to do arithmetic operations. For example:
> select (a+b) from x;
> select sum(a)+sum(b) from x;
> We will need to support arithmetic operations within the Streaming API to support these
types of operations.
> It looks like adding arithmetic operations to the SelectStream is the best place to add
this functionality.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message