I had read http://wiki.apache.org/solr/DataImportHandler but I didn't
realize that was for multivalued.
Than you very much!
On Tue, Jun 8, 2010 at 8:01 AM, Alexey Serba <ase...@gmail.com> wrote:
> Hi Alberto,
>
> You can add child entity which returns multiple records, i.e.
>
> <entity name="root" query="select id, title from titles">
> <entity name="child" query="select value from multivalued where
> title_id='${root.id}'">
> </entity>
> </entity>
>
> HTH,
> Alex
>
> 2010/6/7 Alberto García Sola <alberto...@gmail.com>:
> > Hello, this is my first message to this list.
> >
> > I was wondering if it is possible to use multiValued when using MySQL (or
> > any SQL-database engine) through DataImportHandler.
> >
> > I've tried using a query which return something like this:
> > 1 - title1 - multivalue1-1
> > 1 - title1 - multivalue1-2
> > 1 - title1 - multivalue1-3
> > 2 - title2 - multivalue2-1
> > 2 - title2 - multivalue2-2
> >
> > And using the first row as ID. But that only returns me the first
> occurrence
> > rather than transforming them into multiValued fields.
> >
> > Is there a way to deal with multiValued in databases?
> >
> > NOTE: The way of working with multivalues I use is using foreign keys and
> > relate them into the query so that the query gives me the results the way
> I
> > have shown.
> >
> > Regards,
> > Alberto.
> >
>
