Re: Design Question

2018-02-09 Thread Emir Arnautović
Hi Deepthi, I never tried case with multivalue field. One note about join - your dictionary index must be single shard index and must be replicated on all Solr nodes where your other index is. Let us know how it worked out for you. Thanks, Emir -- Monitoring - Log Management - Alerting - Anomaly

Re: Design Question

2018-02-08 Thread Deepthi P
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

Re: Design Question

2018-02-07 Thread Emir Arnautović
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

Re: Design Question - Dynamic Field Names (*)

2010-01-26 Thread Chris Hostetter
: - We are indexing CSV files and generating field names dynamically from the : "header" line. : User should be able to *list all the possible header names* (i.e. dynamic : field names), and filter results based on some of the field names. : - Also, list* all possible values* associated to for a g

Re: Design Question - Dynamic Field Names (*)

2010-01-19 Thread Kumaravel Kandasami
First Thanks for the response. Yes, mostly likely we want to optimize to one index file. I think it is possible, coming from the RDBMS world we might be over complicating the solution. *Requirement:* - We are indexing CSV files and generating field names dynamically from the "header" line. User

Re: Design Question - Dynamic Field Names (*)

2010-01-19 Thread Shalin Shekhar Mangar
On Sat, Jan 16, 2010 at 3:33 AM, Kumaravel Kandasami < kumaravel.kandas...@gmail.com> wrote: > Need to your suggestion in best designing the following requirement. > > - We have two indexes. > Index 1: "name_index", > Fields: > "id" - indexed, not stored > "field_name" - indexed, stored. > > Ind