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