You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by SHANKAR REDDY <sa...@gmail.com> on 2016/03/23 06:03:20 UTC
Exact searc on Field Query
Team,
I have the below requirement using solr search with fq.
We have table A, with column COL1 which has the below values.
Table A
Col1
--------
SANKARA REDDY TELUKUTLA
SANKARA TELUKUTLA
SANKARA
The requirement is when we search using fq on COL1, for SANKARA, I would
like get exact match like SANKARA but not other records.
At this point, I see the fq=COL1='SANKARA' , which returns all the fields
starts with SANKARA i.e all the records. But I want to get only SANKARA
( like exact match ).
Please let me know how I can achieve this.
Kind Regards,
Sankara Telukutla
MDM/ BIG DATA Solution Architech
--
Kind Regards,
Sankara Telukutla
Re: Exact searc on Field Query
Posted by SHANKAR REDDY <sa...@gmail.com>.
Thanks a lot Isan. That's helps.
On Wed, Mar 23, 2016 at 1:59 AM Ishan Chattopadhyaya <
ichattopadhyaya@gmail.com> wrote:
> Hi Sankara,
> Please use the solr-users list for such questions; this list serves a
> different purpose and your question could get lost here.
>
> Try to use a string field, instead of a text field, in your schema. You
> would need to reindex your documents.
>
> https://cwiki.apache.org/confluence/display/solr/Field+Types+Included+with+Solr
>
> As an example, you could have a field col1_s (which is a dynamic string
> field based on the out of the box schema). Alternatively, you could add a
> string field to schema by the name of "col1":
> <field name="col1" type="string" indexed="true" stored="true"/>
> https://cwiki.apache.org/confluence/display/solr/Defining+Fields
>
> Regards,
> Ishan
>
>
> On Wed, Mar 23, 2016 at 10:33 AM, SHANKAR REDDY <
> sankara.telukutla@gmail.com> wrote:
>
>> Team,
>> I have the below requirement using solr search with fq.
>>
>> We have table A, with column COL1 which has the below values.
>>
>> Table A
>> Col1
>> --------
>> SANKARA REDDY TELUKUTLA
>> SANKARA TELUKUTLA
>> SANKARA
>>
>> The requirement is when we search using fq on COL1, for SANKARA, I would
>> like get exact match like SANKARA but not other records.
>>
>> At this point, I see the fq=COL1='SANKARA' , which returns all the fields
>> starts with SANKARA i.e all the records. But I want to get only SANKARA
>> ( like exact match ).
>>
>> Please let me know how I can achieve this.
>>
>>
>> Kind Regards,
>> Sankara Telukutla
>> MDM/ BIG DATA Solution Architech
>> --
>>
>> Kind Regards,
>> Sankara Telukutla
>>
>
> --
Kind Regards,
Sankara Telukutla
Re: Exact searc on Field Query
Posted by Ishan Chattopadhyaya <ic...@gmail.com>.
Hi Sankara,
Please use the solr-users list for such questions; this list serves a
different purpose and your question could get lost here.
Try to use a string field, instead of a text field, in your schema. You
would need to reindex your documents.
https://cwiki.apache.org/confluence/display/solr/Field+Types+Included+with+Solr
As an example, you could have a field col1_s (which is a dynamic string
field based on the out of the box schema). Alternatively, you could add a
string field to schema by the name of "col1":
<field name="col1" type="string" indexed="true" stored="true"/>
https://cwiki.apache.org/confluence/display/solr/Defining+Fields
Regards,
Ishan
On Wed, Mar 23, 2016 at 10:33 AM, SHANKAR REDDY <sankara.telukutla@gmail.com
> wrote:
> Team,
> I have the below requirement using solr search with fq.
>
> We have table A, with column COL1 which has the below values.
>
> Table A
> Col1
> --------
> SANKARA REDDY TELUKUTLA
> SANKARA TELUKUTLA
> SANKARA
>
> The requirement is when we search using fq on COL1, for SANKARA, I would
> like get exact match like SANKARA but not other records.
>
> At this point, I see the fq=COL1='SANKARA' , which returns all the fields
> starts with SANKARA i.e all the records. But I want to get only SANKARA
> ( like exact match ).
>
> Please let me know how I can achieve this.
>
>
> Kind Regards,
> Sankara Telukutla
> MDM/ BIG DATA Solution Architech
> --
>
> Kind Regards,
> Sankara Telukutla
>