[
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-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
