Hi Briggs,
By saying "multivalued fields are not getting indexed prperly", do you mean
to say that you are not able to search on those fields ?
Have you tried actually searching your Solr index for those multivalued
terms and make sure if it returns the search results ?
One possibility could be that the multivalued fields are getting indexed
correctly and are searchable.
However, since your schema.xml has a "raw_tag" field whose "stored"
attribute is set to false, you may not be able to see those fields.
On Thu, Dec 1, 2011 at 1:43 PM, Briggs Thompson <w.briggs.thomp...@gmail.com
> wrote:
> 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>
> >
>
--
Thanks and Regards
Rahul A. Warawdekar
