[
https://issues.apache.org/jira/browse/SOLR-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708682#comment-14708682
]
Susheel Kumar commented on SOLR-7560:
-------------------------------------
Hi Joel,
I started with two basic tests on my local box
a) add field alias e.g.
select id,name as product_name from techproducts limit 20
which currently fails as data returned contains still "name" as the
field/column key than product_name
b) I wanted to get additional field returned from SQL e.g
select id,name,manu,mul(price,weight) from techproducts limit 20
which currently fails with error "Aggregate functions only supported with group
by queries." while actually I just want to have additional calculated field
based on some function/formula for every document. I checked SQLHandler.java
which currently throws this out due to presence of parenthesis without any
group by/aggregate function.
Please let me know your suggestion on this.
Thanks,
Susheel
> 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: Trunk
>
> Attachments: SOLR-7560.calcite.patch, SOLR-7560.patch,
> 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]
