Return-Path: 
 <dev-return-58724-apmail-lucene-dev-archive=lucene.apache.org@lucene.apache.org>
Delivered-To: apmail-lucene-dev-archive@www.apache.org
Received: (qmail 34729 invoked from network); 31 Oct 2010 14:29:52 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 31 Oct 2010 14:29:52 -0000
Received: (qmail 9680 invoked by uid 500); 31 Oct 2010 14:29:51 -0000
Delivered-To: apmail-lucene-dev-archive@lucene.apache.org
Received: (qmail 9637 invoked by uid 500); 31 Oct 2010 14:29:51 -0000
Mailing-List: contact dev-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@lucene.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@lucene.apache.org>
List-Post: <mailto:dev@lucene.apache.org>
List-Id: <dev.lucene.apache.org>
Reply-To: dev@lucene.apache.org
Delivered-To: mailing list dev@lucene.apache.org
Received: (qmail 9630 invoked by uid 99); 31 Oct 2010 14:29:51 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 31 Oct 2010 14:29:51 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 31 Oct 2010 14:29:49 +0000
Received: from thor (localhost [127.0.0.1])
	by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o9VETNIB022234
	for <dev@lucene.apache.org>; Sun, 31 Oct 2010 14:29:26 GMT
Message-ID: <18408669.162381288535363240.JavaMail.jira@thor>
Date: Sun, 31 Oct 2010 10:29:23 -0400 (EDT)
From: "Koji Sekiguchi (JIRA)" <jira@apache.org>
To: dev@lucene.apache.org
Subject: [jira] Updated: (SOLR-2039) Multivalued fields with dynamic names
 does not work properly with DIH
In-Reply-To: <14617504.284101281553576074.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/SOLR-2039?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Koji Sekiguchi updated SOLR-2039:
---------------------------------

    Component/s: contrib - DataImportHandler

Just assigning a component

> Multivalued fields with dynamic names does not work properly with DIH
> ---------------------------------------------------------------------
>
>                 Key: SOLR-2039
>                 URL: https://issues.apache.org/jira/browse/SOLR-2039
>             Project: Solr
>          Issue Type: Bug
>          Components: contrib - DataImportHandler
>    Affects Versions: 1.4.1
>         Environment: Windows XP, Default Solr 1.4 install with jetty
>            Reporter: K A
>
> Attempting to use multiValued fields using the DataImportHandler with dynamic names does not seem to work as intended.
> Setting up the following in schema.xml
> <dynamicField name="*_s"  type="string"  indexed="true"  stored="true" multiValued="true" /> 
> Then attempting to import a multiValued field through a RDBMS using children records with a dynamic name. The snippet from data-config.xml
> <entity name="terms" query="select distinct DESC_TERM from tem_metadata where item_id=${item.ID_PK}">
>                       <entity name="metadata" query="select * from term_metadata where item_id=${item.ID_PK} AND desc_term='${terms.DESC_TERM}'" >
>                              <field name="${terms.DESC_TERM}_s" column="TEXT_VALUE" />
>                        </entity>
>  </entity>
> Results in only the FIRST record being imported. If we change the field name in the above example to a constant (ie above field entry becomes: <field name="metadata_record_s" column="TEXT_VALUE" />). The multiple records are correctly imported.
> This was posted on solr-user, and others have reported the problem on the mailing list archive.
> The workaround was to use a javascript transform to perform the same behavior. Changes in data-config.xml become:
> <entity name="metadata" query="select * from vw_item_metadata where item_id=${item.DIVID_PK} AND core_desc_term='${terms.CORE_DESC_TERM}'" transformer="script:f1"/> 
> <script><![CDATA[
>       function f1(row) {
>         var name = row.get('CORE_DESC_TERM');
>                         var value = row.get('TEXT_VALUE')
>         row.put(name+ '_s', value);
>        
>         return row;
>       }
>  ]]></script> 
> This results in multivalued field with a dynamic name assigned.
>  

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org