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