In addition, I tried a query like below and changed the column definition
to
<field column="raw_tag" name="raw_tag" splitBy="," />
and still no luck. It is indexing the full content now but not multivalued.
It seems like the "splitBy" ins't working properly.
select group_concat(freetags.raw_tag separator ', ') as raw_tag, site.*
from site
left outer join
(freetags inner join freetagged_objects)
on (freetags.id = freetagged_objects.tag_id
and site.siteId = freetagged_objects.object_id)
group by site.siteId
Am I doing something wrong?
Thanks,
Briggs Thompson
On Thu, Dec 1, 2011 at 11:46 AM, Briggs Thompson <
w.briggs.thomp...@gmail.com> wrote:
> 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>
>
