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 > > >
