lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexey Serba <ase...@gmail.com>
Subject Re: multiValued using
Date Tue, 08 Jun 2010 06:01:11 GMT
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 <alberto666@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.
>

Mime
View raw message