From solr-user-return-138891-archive-asf-public=cust-asf.ponee.io@lucene.apache.org Thu Feb 8 08:55:38 2018 Return-Path: X-Original-To: archive-asf-public@eu.ponee.io Delivered-To: archive-asf-public@eu.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by mx-eu-01.ponee.io (Postfix) with ESMTP id 96C0A18064F for ; Thu, 8 Feb 2018 08:55:38 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 86685160C4A; Thu, 8 Feb 2018 07:55:38 +0000 (UTC) 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 C8EAA160C3D for ; Thu, 8 Feb 2018 08:55:37 +0100 (CET) Received: (qmail 82101 invoked by uid 500); 8 Feb 2018 07:55:35 -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 82085 invoked by uid 99); 8 Feb 2018 07:55:34 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Feb 2018 07:55:34 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 80B7F180034 for ; Thu, 8 Feb 2018 07:55:34 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.98 X-Spam-Level: * X-Spam-Status: No, score=1.98 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=sematext-com.20150623.gappssmtp.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id lEeWoMrrfnHx for ; Thu, 8 Feb 2018 07:55:32 +0000 (UTC) Received: from mail-wm0-f66.google.com (mail-wm0-f66.google.com [74.125.82.66]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 612535F11F for ; Thu, 8 Feb 2018 07:55:32 +0000 (UTC) Received: by mail-wm0-f66.google.com with SMTP id i186so7656478wmi.4 for ; Wed, 07 Feb 2018 23:55:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sematext-com.20150623.gappssmtp.com; s=20150623; h=from:mime-version:subject:date:references:to:in-reply-to:message-id; bh=MVEJzbGsLW90/Mj1JIz/YtWRwjJOVWkE2okgZJcZv5o=; b=1l6RGnxP/l532Mf25VaF3wItz4QDijaN+vwVOXCGDLBQN4dQoDtdROPM2hlM11yoES jRukPqUfnXYDwiS8ecrcJJjj75PgOQZDMkf5LjC5GhmG5cc1YmzBsCEPeymtzmuXdTvt kmxiPRBufei3Y1mJehOkpfyRXWn+Mk8P0eOrswAmO+IFxa8ds8hJEg3zUiTE6v6UPvJr bx+HFjaKhQZ6dQlVoSxAx1KgHCIVPPmDpjTjE7QF6km7ffDUQDpwLAD4SzwM6eptygUm zn+MiI20QuzzsVHvg6jabbKNdGi4CJ8d8Es16stIATFly5VnlIYoT9NncCfINNEKWx6T jTNg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:mime-version:subject:date:references:to :in-reply-to:message-id; bh=MVEJzbGsLW90/Mj1JIz/YtWRwjJOVWkE2okgZJcZv5o=; b=pRkoqFK3AIIjjdXemStCv3m3ZHILti0TJ+rsQzkTEbtbhUfM7qc8w+dggqcTH4Anlw k0HIeI0jWQBp0CaFe2zX051fuTaxeU8QfFNHlqWNnJDsSovq+f9TtwXvTZEgoAv0ebOb j+ZHuIehXDlnvBvKoJy/lhm6KOU2P7D/vkvwEsxIBgkvRtFeqPSD0nFgDCbAjvijPD/I 3w1L8fZvMkz5B2J61/yGljCO4GgmXiUiL8k1/BSsO3btfuCF+5x9pfFpqHGnPi/ciTho mNQ6iv/1eq/KKOuWrvEoYbkaLFQs+tPsVuABnYJVa5Jj5eLy1VXYHcEUmveojCYxwqD/ Vtiw== X-Gm-Message-State: APf1xPCgaKWVWIv0OcHGvqLvfOZmKLzy+7ZoCh5bNws2K5niud6Nc/eY mmcjFs4xmEGnZGCCJWfaDMXVk6mGvJc= X-Google-Smtp-Source: AH8x227iup1giqk1nJEpqG1WIanSF8IBhQAvQRho5qmZ30o7SazfYoSdgYXxMRemgtiDKIXM3803rg== X-Received: by 10.28.197.201 with SMTP id v192mr180913wmf.53.1518076526388; Wed, 07 Feb 2018 23:55:26 -0800 (PST) Received: from [192.168.0.13] (cable-77-77-227-36.dynamic.telemach.ba. [77.77.227.36]) by smtp.gmail.com with ESMTPSA id e16sm4028577wre.5.2018.02.07.23.55.24 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 07 Feb 2018 23:55:25 -0800 (PST) From: =?utf-8?Q?Emir_Arnautovi=C4=87?= Content-Type: multipart/alternative; boundary="Apple-Mail=_66082FAD-B546-4C18-8EB6-C5B8B0E5D7E4" Mime-Version: 1.0 (Mac OS X Mail 11.2 \(3445.5.20\)) Subject: Re: Design Question Date: Thu, 8 Feb 2018 08:55:23 +0100 References: To: solr-user@lucene.apache.org In-Reply-To: Message-Id: <467D667A-D718-49CF-AFF5-6D71E7102687@sematext.com> X-Mailer: Apple Mail (2.3445.5.20) --Apple-Mail=_66082FAD-B546-4C18-8EB6-C5B8B0E5D7E4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Deepthi, Is dictionary static? Can value for some id change? If static, and if = query performance matters to you, the best and also the simplest = solution is to denormalise data and store dictionary values with docs. Alternative is to use join query parser: = https://lucene.apache.org/solr/guide/6_6/other-parsers.html#OtherParsers-J= oiningAcrossCollections = HTH, Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > On 8 Feb 2018, at 07:21, Deepthi P wrote: >=20 > I have a dictionary of 20000 ID's and their description which is in a > collection. There is another solr collection in which each document = have 10 > or more ID's(multi valued field). I would like to text search in the > dictionary and bring back the matched ID's and search these ID's in = solr > collection. For example if I search for 'fox' in the dictionary = collection > and it returns 40 ID's, I would like to sent these 40 ID's to solr > collection and bring back documents that have these ID's.Please = suggest the > best way to implement this. --Apple-Mail=_66082FAD-B546-4C18-8EB6-C5B8B0E5D7E4--