[
https://issues.apache.org/jira/browse/SOLR-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joel Bernstein updated SOLR-7560:
---------------------------------
Attachment: SOLR-7560.patch
New Patch adding support for the HAVING clause of GROUP BY statements.
Sample syntax:
{code}
select str_s, count(*), sum(field_i), min(field_i), max(field_i), avg(field_i)
from mytable where text='XXXX' group by str_s having ((sum(field_i) = 19) AND
(min(field_i) = 8))
{code}
> Parallel SQL Support
> --------------------
>
> Key: SOLR-7560
> URL: https://issues.apache.org/jira/browse/SOLR-7560
> Project: Solr
> Issue Type: New Feature
> Components: clients - java, search
> Reporter: Joel Bernstein
> Fix For: 5.3
>
> Attachments: SOLR-7560.patch, SOLR-7560.patch, SOLR-7560.patch
>
>
> This ticket provides support for executing *Parallel SQL* queries across
> SolrCloud collections. The SQL engine will be built on top of the Streaming
> API (SOLR-7082), which provides support for *parallel relational algebra* and
> *real-time map-reduce*.
> Basic design:
> 1) A new SQLHandler will be added to process SQL requests. The SQL statements
> will be compiled to live Streaming API objects for parallel execution across
> SolrCloud worker nodes.
> 2) SolrCloud collections will be abstracted as *Relational Tables*.
> 3) The Presto SQL parser will be used to parse the SQL statements.
> 4) A JDBC thin client will be added as a Solrj client.
> This ticket will focus on putting the framework in place and providing basic
> SELECT support and GROUP BY aggregate support.
> Future releases will build on this framework to provide additional SQL
> features.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
