hi

I got the problem it is with the unique key defined in the schema.xml
if i difine it to be query_id then while indexing it says
missing mandatory key query_id which is not present in the root
entity(data-config.xml) which is indexing the product from the database
which has product_id as the unique key and when in schema I set product_id
as the unique key then it says missing mandatory key product_id which is
not present in the root entity(data-config.xml) which is indiexing the user
query from another table in the database which has user_id as the unique
key.

how can I fix this thanks I want to index both the tables which are
basically unrelated that is does not have any *Common*  fields....

thanks
rohan


On Thu, May 16, 2013 at 3:24 PM, Michael Della Bitta <
michael.della.bi...@appinions.com> wrote:

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

Reply via email to