Re: multiple table(how to index multiple table in solr)

2015-11-25 Thread Mugeesh Husain
Thanks you Erick Erickson. -- View this message in context: http://lucene.472066.n3.nabble.com/multiple-table-how-to-index-multiple-table-in-solr-tp4241868p4242165.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: multiple table(how to index multiple table in solr)

2015-11-24 Thread Erick Erickson
See what happens if you simply index the cross product of all three tables. if user U1 reviews restaurant R1 with review rev1, index a single Solr document with all three. Presumably your database has a primary key for each table, so the uniqueKey for the Solr index is the concatenation of those t

Re: multiple table(how to index multiple table in solr)

2015-11-24 Thread Mugeesh Husain
Thanks you for replying me, one more question, if join is bad idea at the time of indexing,or i should denormalize data. How i can index/post Restuarnt,user,review table info to solr. we need a unique key at the posting data to solr. Actually i need a unique key for all table(data) for the pur

Re: multiple table(how to index multiple table in solr)

2015-11-24 Thread Erick Erickson
Not quite an answer, but the question is wrong ;) Do not try to treat Solr like a RDBMS. Your problem statement reveals that you are. Then, no doubt, you'll want to join the "tables" you've indexed. Then you'll discover that this is usually a Bad Idea. Instead, try to flatten (denormalize) the da