lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From harrysmith <>
Subject Re: DIH and multivariable fields problems
Date Sat, 07 Aug 2010 00:46:56 GMT

Thanks, this helps a great deal, and I may be able to use this method.

Is this how DIH is intended to be used? The multi values should be returned
in 1 row then manipulated by a transformer? This is fine, but is just
unclear from the documentation. I was under the assumption that multiple
rows returned for a child entity with the same parent would be able to
create a multivalued entry.

>From the DataImportHandler wiki:

" is possible to create a multivalued field by joining an entity with
another.i.e if the sub-entity returns multiple rows for one row from parent
entity it can go into a multivalued field"

  For multiple value fields using the DIH, i use group_concat with the 
regextransformer's splitby:
<entity dataSource="grad_schools" query="
           SELECT    group_concat( separator '|') as 
           FROM professors
             WHERE     professors.university_guid = '${universities.guid}'
<field column="university_professors" splitBy="\|" />

hope that's helpful.

Programmer and UC Irvine Graduate Student
Find a great grad school based on research interests:

On 8/6/10 4:39 PM, harrysmith wrote:
> I'm having a difficult time understanding how multivariable fields work
> with
> the DataImportHandler when the source is a RDBMS. I've read the following
> from the wiki:

View this message in context:
Sent from the Solr - User mailing list archive at

View raw message