[
https://issues.apache.org/jira/browse/SOLR-8571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15107035#comment-15107035
]
Kevin Risden edited comment on SOLR-8571 at 10/7/16 3:23 PM:
-------------------------------------------------------------
Once this is done we can support the following construct:
{code}
daemon(update(jdbc(connection="jdbc:solr://zkHost?collection=collection1&numWorkers=10&aggregationMode=map_reduce",
sql="select year, month, concat(month, '_',
year) as id, sum(price) from tablex group by year, month")))
{code}
In the code above the jdbc stream is connecting to a SolrCloud and running a
SQL aggregate query which is used to update another SolrCloud collection. The
daemon code will run this in the background at intervals. The concat function
creates the id field on the fly so aggregates update properly.
was (Author: joel.bernstein):
Once this is done we can support the following construct:
{code}
daemon(update(jdbc(connection="jdbc:solr://zkHost?collection=collection1&numWorkers=10&aggregationMode=map_reduce",
sql="select year, month, concat('month,
year', '_') as id, sum(price) from tablex group by year, month")))
{code}
In the code above the jdbc stream is connecting to a SolrCloud and running a
SQL aggregate query which is used to update another SolrCloud collection. The
daemon code will run this in the background at intervals. The concat function
creates the id field on the fly so aggregates update properly.
> Wire the ConcatOperation into the SQLhandler
> --------------------------------------------
>
> Key: SOLR-8571
> URL: https://issues.apache.org/jira/browse/SOLR-8571
> Project: Solr
> Issue Type: New Feature
> Reporter: Joel Bernstein
> Priority: Minor
>
> This will support the *concat* function. Syntax:
> {code}
> select a, b, concat('a','|','b') as c from tableX
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
