Erick, I had typed tn_lookup_key_id as lowercase and it was defined as
<fieldType name="lowercase" class="solr.TextField"
positionIncrementGap="100">
<analyzer>
<tokenizer class="solr.KeywordTokenizerFactory" />
<filter class="solr.LowerCaseFilterFactory" />
</analyzer>
</fieldType>
Nitin
On Mon, Jul 29, 2013 at 1:23 PM, Erick Erickson <erickerick...@gmail.com>wrote:
> Nitin:
>
> What was your tn_lookup_key_id field definition when things didn't work?
> The stock lowercase is KeywordTokenizerFactory+LowerCaseFilterFactory
> and if this leads to mis-matches as Hoss outlined, it'd surprise me so I
> need
> to file it away in my list of things not to do.
>
> Thanks,
> Erick
>
> On Mon, Jul 29, 2013 at 3:01 PM, Nitin Agarwal <2nitinagar...@gmail.com>
> wrote:
> > Hoss, you rock!
> >
> > That was the issue, I changed tn_lookup_key_id, which was my unique key
> > field, to string and reloaded the index and it works.
> >
> > Jason, Jack and Hoss, thanks for your help.
> >
> > Nitin
> >
> >
> > On Mon, Jul 29, 2013 at 12:22 PM, Chris Hostetter
> > <hossman_luc...@fucit.org>wrote:
> >
> >>
> >> : Here is what my schema looks like
> >>
> >> what is your uniqueKey field?
> >>
> >> I'm going to bet it's "tn_lookup_key_id" and i'm going to bet your
> >> "lowercase" fieldType has an interesting analyzer on it.
> >>
> >> you are probably hitting a situation where the analyzer you have on your
> >> uniqueKey field is munging the values in such a way that when the
> >> coordinator node decides which N docs to include in the response,
> >> and then asks the various shards to give it those specific N
> >> docs, those subsequent field fetching queries fail because of an
> >> analysis mismatch.
> >>
> >> you need to keep your uniqueKeyField simple -- i strongly recommend a
> >> basic StrField. If you also want to do "lowercase" lookups on your key
> >> field, index it redundently in a second field.
> >>
> >>
> >> : *<fields>
> >> : <field name="_version_" type="long" indexed="true" stored="true"
> >> : multiValued="false" />
> >> : <field name="bill_account_name" type="lowercase" indexed="true"
> >> : stored="true" required="false" />
> >> : <field name="bill_account_nbr" type="lowercase" indexed="true"
> >> : stored="true" required="false" />
> >> : <field name="cust_name" type="lowercase" indexed="true"
> >> stored="true"
> >> : required="false" />
> >> : **<field name="tn_lookup_key_id" type="lowercase"
> >> : indexed="true" stored="true" required="true" />
> >> : </fields>*
> >>
> >> -Hoss
> >>
>
