Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-2039

Multivalued fields with dynamic names does not work properly with DIH


    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.1
    • Fix Version/s: 6.3, 7.0
    • Labels:
    • Environment:

      Windows XP, Default Solr 1.4 install with jetty


      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" />

      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"/>

      function f1(row)

      { var name = row.get('CORE_DESC_TERM'); var value = row.get('TEXT_VALUE') row.put(name+ '_s', value); return row; }


      This results in multivalued field with a dynamic name assigned.


        1. SOLR-2039.patch
          0.8 kB
        2. SOLR-2039.patch
          3 kB
          Cao Manh Dat



            • Assignee:
              shalinmangar Shalin Shekhar Mangar
              harrysmithwla K A
            • Votes:
              4 Vote for this issue
              10 Start watching this issue


              • Created: