I mean to say that I want to index 2 tables that is using 2 root entity in data-config.xml one is product table and other is user search table these both have no foreign key and I want to index both of them as document in my solr index what should I do...its taking either one of them and rejecting other table as document when I am taking primary key of one table as unique key in the solr schema...and vice verca.....how to solve this?
On Thu, May 16, 2013 at 4:24 PM, Rohan Thakur <rohan.i...@gmail.com> wrote: > hi > > I got the problem it is with the unique key defined in the schema.xml > if i difine it to be query_id then while indexing it says > missing mandatory key query_id which is not present in the root > entity(data-config.xml) which is indexing the product from the database > which has product_id as the unique key and when in schema I set product_id > as the unique key then it says missing mandatory key product_id which is > not present in the root entity(data-config.xml) which is indiexing the user > query from another table in the database which has user_id as the unique > key. > > how can I fix this thanks I want to index both the tables which are > basically unrelated that is does not have any *Common* fields.... > > thanks > rohan > > > On Thu, May 16, 2013 at 3:24 PM, Michael Della Bitta < > michael.della.bi...@appinions.com> wrote: > >> True, it's complaining that your Solr schema has a required field 'title' >> and your query and data import config aren't providing it. >> On May 16, 2013 5:51 AM, "Rohan Thakur" <rohan.i...@gmail.com> wrote: >> >> > its saying in the logs that missing required field title which is no >> where >> > in the database... >> > >> > >> > On Thu, May 16, 2013 at 3:08 PM, Rohan Thakur <rohan.i...@gmail.com> >> > wrote: >> > >> > > I am not able to index the fields from data base its getting failed... >> > > >> > > data-config.xml >> > > >> > > <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" >> > > url="jdbc:mysql://localhost/test" >> > > user="user" password="dfsdf"/> >> > > <document> >> > > <entity name="catalogsearch_query" query="select >> query_id,query_text >> > > from catalogsearch_query where num_results!= 0"> >> > > <field column="query_id" name="query_id"/> >> > > <field column="query_text" name="user_query"/> >> > > </entity> >> > > </document> >> > > >> > > its showing all failed and 0 indexed >> > > >> > > >> > > On Wed, May 15, 2013 at 8:31 PM, Alexandre Rafalovitch < >> > arafa...@gmail.com >> > > > wrote: >> > > >> > >> 1. Create a schema that accomodates both types of fields either using >> > >> optional fields or dynamic fields. >> > >> 2. Create some sort of differentiator key (e.g. schema), separately >> > >> from id (which needs to be globally unique, so possibly schema+id) >> > >> 3. Use that schema in filter queries (fq) to look only at subject of >> > items >> > >> 4. (Optionally) define separate search request handlers that force >> > >> that schema parameter (using appends or invariants instead of >> > >> defaults) >> > >> >> > >> That should get you most of the way there. >> > >> >> > >> Regards, >> > >> Alex. >> > >> Personal blog: http://blog.outerthoughts.com/ >> > >> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch >> > >> - Time is the quality of nature that keeps events from happening all >> > >> at once. Lately, it doesn't seem to be working. (Anonymous - via >> GTD >> > >> book) >> > >> >> > >> >> > >> On Wed, May 15, 2013 at 7:07 AM, Rohan Thakur <rohan.i...@gmail.com> >> > >> wrote: >> > >> > hi all >> > >> > >> > >> > >> > >> > I want to index 2 separate unrelated tables from database into >> single >> > >> solr >> > >> > core and search in any one of the document separately how can I do >> it? >> > >> > please help >> > >> > >> > >> > thanks in advance >> > >> > regards >> > >> > Rohan >> > >> >> > > >> > > >> > >> > >
