I don't know how to query multiple cores and if it's possible at once, but otherwise I would create a JOIN sql script if you need values from multiple tables.
D. On Fri, Jan 11, 2013 at 3:27 PM, Niklas Langvig < niklas.lang...@globesoft.com> wrote: > Ahh sorry, > Now I understand, > Ok seems like a good solution, I just know need to understand how to query > multiple cores now :) > > -----Ursprungligt meddelande----- > Från: Dariusz Borowski [mailto:darius...@gmail.com] > Skickat: den 11 januari 2013 15:15 > Till: solr-user@lucene.apache.org > Ämne: Re: configuring schema to match database > > Hi, > > No, it has actually two tables. User and Item. The example shown on the > blog is for one table, because you repeat the same thing for the other > table. Only your data-import.xml file changes. For the rest, just copy and > paste it in the conf directory. If you are running your solr in Linux, then > you can work with symlinks. > > D. > > > > On Fri, Jan 11, 2013 at 3:12 PM, Niklas Langvig < > niklas.lang...@globesoft.com> wrote: > > > Hi Dariusz, > > To me this example has one table "user" and I have many tables that > > connects to one user and that is what I'm unsure how how to do. > > > > /Niklas > > > > > > -----Ursprungligt meddelande----- > > Från: Dariusz Borowski [mailto:darius...@gmail.com] > > Skickat: den 11 januari 2013 14:56 > > Till: solr-user@lucene.apache.org > > Ämne: Re: configuring schema to match database > > > > Hi Niklas, > > > > Maybe this link helps: > > > > http://www.coderthing.com/solr-with-multicore-and-database-hook-part-1 > > / > > > > D. > > > > > > > > On Fri, Jan 11, 2013 at 2:19 PM, Niklas Langvig < > > niklas.lang...@globesoft.com> wrote: > > > > > Hi! > > > I'm quite new to solr and trying to understand how to create a > > > schema from how our postgres database and then search for the > > > content in solr instead of querying the db. > > > > > > My question should be really easy, it has most likely been asked > > > many times but still I'm not able to google any answer to it. > > > > > > To make it easy, I have 3 columns: users, courses and languages > > > > > > Users has columns , userid, firstname, lastname Courses has column > > > coursename, startdate, enddate Languages has column language, > > > writingskill, verbalskill > > > > > > UserA has taken courseA, courseB and courseC and has writingskill > > > good verbalskill good for english and writingskill excellent > > > verbalskill excellent for spanish UserB has taken courseA, courseF, > > > courseG and courseH and has writingskill fluent verbalskill fluent > > > for english and writingskill good verbalskill good for italian > > > > > > I would like to put this data into solr so I can search for all > > > "users how have taken courseA and are fluent in english". > > > Can I do that? > > > > > > The problem is I'm not sure how to flatten this database into a > > > schema It's easy to understand the users column, for example <field > > > name="userid" type="string" indexed="true" /> <field name="firstname" > > > type="string" indexed="true" /> <field name="lastname" type="string" > > > indexed="true" /> > > > > > > But then I'm not so sure how the schema should look like for courses > > > and languages <field name="userid" type="string" indexed="true" /> > > > <field name="coursename" type="string" indexed="true" /> <field > > > name="startdate" type="string" indexed="true" /> <field name="enddate" > > > type="string" indexed="true" /> > > > > > > > > > Thanks for any help > > > /Niklas > > > > > >