Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 1E468200ABF for ; Tue, 3 May 2016 07:33:56 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 1CD9C1609A7; Tue, 3 May 2016 07:33:56 +0200 (CEST) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 669D016098B for ; Tue, 3 May 2016 07:33:55 +0200 (CEST) Received: (qmail 34831 invoked by uid 500); 3 May 2016 05:33:52 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 34817 invoked by uid 99); 3 May 2016 05:33:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 May 2016 05:33:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 84A2DC05B5 for ; Tue, 3 May 2016 05:33:51 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.511 X-Spam-Level: X-Spam-Status: No, score=0.511 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, URI_HEX=1.313] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id RozVXkCkPUSe for ; Tue, 3 May 2016 05:33:49 +0000 (UTC) Received: from mail-io0-f172.google.com (mail-io0-f172.google.com [209.85.223.172]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 92C185F2F0 for ; Tue, 3 May 2016 05:33:48 +0000 (UTC) Received: by mail-io0-f172.google.com with SMTP id u185so14795191iod.3 for ; Mon, 02 May 2016 22:33:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=OQDgL60bqIcCY9WJZOxxRmQrvRszKAYeaqgow/PPpvM=; b=AdGq4Jj9sLKM/L4lPk4CP/AHNnww3iHZCqoxIjOo76Pnk++g0j1vyS9x36z2msDv2S FCZzygX4jeEAVK33T0Z2G+Dalyoccdn8WwQPrA7u1dnIeAGp3cZEl2y63dWrxCGxcJjt +hfuEYma9plRdXstjoWu8D+D4FlDf4hd/LL6wnrKlatQjtq3L1GmteDnnjvGbXY0On6z i4e4RWCzzSFpIzk/LBLv2yxJZSF6YZQR4PQyZIWSLYRnZKlMgeDd+FbFsOkQwa6SH71r GdTjDBAB/2V5fSOdqwN3ur8dulrx6ZjnHz5eV54eOzzTm130WhMQhppt1cAAYT9nsDyT TOIA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=OQDgL60bqIcCY9WJZOxxRmQrvRszKAYeaqgow/PPpvM=; b=kHRzJolW5Ht1IjG6Zr+zIEEYYmr0dt0rzTpxSUagOzhWveoskvDDb2IWBXRSq7qO8H Y+4M7zCZtYvX4Xyu2qlHd6DWPVQTiBpPJSwf0NHNAXTjQmFKPj+g6/HHedIPezpmsPbe l7b2h/5bcYVb8cRe4m3+PpvIgMdqSQAu07MxMdvIL4GIyBzwkDd5PsAA4NVOAuSrEy5o I5MsY44gazc5rLO33MPFuM3Fx1skpLT/f4yO3B8hrBjXJiVUlTSAQZ6yi5ONH1dQ0+3I d0qhnlViXNRo8O+tyhBO9mKWWptugUkWzErBezfSXMrSjf+o8HI0PF0Uv1icrJe+lH+C Y2qg== X-Gm-Message-State: AOPr4FVh7teEmynBIXipg4g8wJCks9WX8inBHCPI96TWx699tAICoS8aZiTlMyqw9kMupchDUFspnyg5EOFTwg== X-Received: by 10.107.169.13 with SMTP id s13mr960327ioe.19.1462253627604; Mon, 02 May 2016 22:33:47 -0700 (PDT) MIME-Version: 1.0 Received: by 10.50.229.9 with HTTP; Mon, 2 May 2016 22:33:08 -0700 (PDT) In-Reply-To: <1462252442065-4274155.post@n3.nabble.com> References: <1462252442065-4274155.post@n3.nabble.com> From: Alexandre Rafalovitch Date: Tue, 3 May 2016 15:33:08 +1000 Message-ID: Subject: Re: Solr comparsion between two columns To: solr-user Content-Type: text/plain; charset=UTF-8 archived-at: Tue, 03 May 2016 05:33:56 -0000 Function queries if you want to do this on a fly: https://cwiki.apache.org/confluence/display/solr/Function+Queries 'if' and 'sub' most likely However, if you are going to do this often for the same fields, you may be better off calculating this during indexing using UpdateRequestProcessors. I don't think we have one for math directly (full list here: http://www.solr-start.com/info/update-request-processors/) , but you could use a Scripting one and implement it that way. Regards, Alex. ---- Newsletter and resources for Solr beginners and intermediates: http://www.solr-start.com/ On 3 May 2016 at 15:14, kavurupavan wrote: > Compare two columns in solr if two fields are equal display true or else > false. > > CASE WHEN o_is_follow = o_follow_id THEN 'TRUE' ELSE 'FALSE'. Please help > me. Thanks in advance. > > > > -- > View this message in context: http://lucene.472066.n3.nabble.com/Solr-comparsion-between-two-columns-tp4274155.html > Sent from the Solr - User mailing list archive at Nabble.com.