Mailing-List: contact dev-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@lucene.apache.org
Date: Tue, 19 Jan 2016 17:22:39 +0000 (UTC)
From: "Joel Bernstein (JIRA)" <jira@apache.org>
To: dev@lucene.apache.org
Message-ID: <JIRA.12932472.1453222829000.149494.1453224159806@Atlassian.JIRA>
In-Reply-To: <JIRA.12932472.1453222829000@Atlassian.JIRA>
References: <JIRA.12932472.1453222829000@Atlassian.JIRA>
 <JIRA.12932472.1453222829519@arcas>
Subject: [jira] [Commented] (SOLR-8571) Wire the ConcatOperation into the
 SQLhandler
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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