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 >