Don't you want to specify "splitBy" for the integer field too? Actually though, you shouldn't need to use GROUP_CONCAT and RegexTransformer at all. DIH is designed to handle "1>many" relations between parent and child entities by populating all the child fields as multi-valued automatically. I guess your approach leads to a lot fewer rows getting sent from your db to Solr though.
James Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -----Original Message----- From: Pranav Prakash [mailto:pra...@gmail.com] Sent: Wednesday, July 18, 2012 2:38 PM To: solr-user@lucene.apache.org Subject: How To apply transformation in DIH for multivalued numeric field? I have a multivalued integer field and a multivalued string field defined in my schema as <field name="community_tag_ids" type="integer" indexed="true" stored="true" multiValued="true" omitNorms="true" /> <field name="community_tags" type="text" indexed="true" termVectors="true" stored="true" multiValued="true" omitNorms="true" /> The DIH entity and field defn for the same goes as <entity name="document" dataSource="app" onError="skip" transformer="RegexTransformer" query="..."> <entity name="community_tags" transformer="RegexTransformer" query="SELECT group_concat(a.id SEPARATOR ',') AS community_tag_ids, group_concat(a.title SEPARATOR ',') AS community_tags FROM tags a JOIN tag_dets b ON a.id = b.tag_id WHERE b.doc_id = ${document.id}" > <field column="community_tag_ids" name="community_tag_ids"/> <field column="community_tags" splitBy="," /> </entity> </entity> The value for field community_tags comes correctly as an array of strings. However the value of field community_tag_ids is not proper <arr name="community_tag_ids"> <int>[B@390c0a18</int> </arr> I tried chaining NumberFormatTransformer with formatStyle="number" but that throws DataImportHandlerException: Failed to apply NumberFormat on column. Could it be due to NULL values from database or because the value is not proper? How do we handle NULL in this case? *Pranav Prakash* "temet nosce"