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
>
