Hello Solr Community!
I am implementing a data connection to Solr through the Data Import Handler
and non-multivalued fields are working correctly, but multivalued fields
are not getting indexed properly.
I am new to DataImportHandler, but from what I could find, the entity is
the way to go for multivalued field. The weird thing is that data is being
indexed for one row, meaning first raw_tag gets populated.
Anyone have any ideas?
Thanks,
Briggs
This is the relevant part of the schema:
<field name ="raw_tag" type="text_en_lessAggressive" indexed="true"
stored="false" multivalued="true"/>
<field name ="raw_tag_string" type="string" indexed="false"
stored="true" multivalued="true"/>
<copyField source="raw_tag" dest="raw_tag_string"/>
And the relevant part of data-import.xml:
<document name="merchant">
<entity name="site"
query="select * from site ">
<field column="siteId" name="siteId" />
<field column="domain" name="domain" />
<field column="aliasFor" name="aliasFor" />
<field column="title" name="title" />
<field column="description" name="description" />
<field column="requests" name="requests" />
<field column="requiresModeration" name="requiresModeration" />
<field column="blocked" name="blocked" />
<field column="affiliateLink" name="affiliateLink" />
<field column="affiliateTracker" name="affiliateTracker" />
<field column="affiliateNetwork" name="affiliateNetwork" />
<field column="cjMerchantId" name="cjMerchantId" />
<field column="thumbNail" name="thumbNail" />
<field column="updateRankings" name="updateRankings" />
<field column="couponCount" name="couponCount" />
<field column="category" name="category" />
<field column="adult" name="adult" />
<field column="rank" name="rank" />
<field column="redirectsTo" name="redirectsTo" />
<field column="wwwRequired" name="wwwRequired" />
<field column="avgSavings" name="avgSavings" />
<field column="products" name="products" />
<field column="nameChecked" name="nameChecked" />
<field column="tempFlag" name="tempFlag" />
<field column="created" name="created" />
<field column="enableSplitTesting" name="enableSplitTesting" />
<field column="affiliateLinklock" name="affiliateLinklock" />
<field column="hasMobileSite" name="hasMobileSite" />
<field column="blockSite" name="blockSite" />
<entity name="merchant_tags" pk="siteId"
query="select raw_tag, freetags.id,
freetagged_objects.object_id as siteId
from freetags
inner join freetagged_objects
on freetags.id=freetagged_objects.tag_id
where freetagged_objects.object_id='${site.siteId}'">
<field column="raw_tag" name="raw_tag"/>
</entity>
</entity>
</document>
