Hi Emir, Thank you. The dictionary is static but the descriptions are long text. If i denormalize each document will have 100+ descriptions and I have 8 million records in collection. There is lot of repetition of descriptions and the index becomes large. I am trying to avoid that. Also data load time adds to it as I have to iterate over each ID and add description.
Will join work if ID is multivalued field in Solr collection and single value field in dictionary ? Please advise. Thanks Deepthi On Thu, Feb 8, 2018 at 2:55 AM, Emir Arnautović < emir.arnauto...@sematext.com> wrote: > 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-JoiningAcrossCollections < > https://lucene.apache.org/solr/guide/6_6/other-parsers.html#OtherParsers- > JoiningAcrossCollections> > > 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 <vldpu...@gmail.com> wrote: > > > > 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. > >