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