lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rohan Thakur <rohan.i...@gmail.com>
Subject Re: indexing unrelated tables in single core
Date Thu, 16 May 2013 09:38:05 GMT
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
<arafalov@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.iitd@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message