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