lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joel Bernstein (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SOLR-8571) Wire the ConcatOperation into the SQLhandler
Date Tue, 19 Jan 2016 17:22:39 GMT

    [ https://issues.apache.org/jira/browse/SOLR-8571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15107035#comment-15107035
] 

Joel Bernstein commented on SOLR-8571:
--------------------------------------

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


Mime
View raw message