Re: Exact searc on Field Query
Thanks a lot Isan. That's helps. On Wed, Mar 23, 2016 at 1:59 AM Ishan Chattopadhyaya < ichattopadhy...@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": > > https://cwiki.apache.org/confluence/display/solr/Defining+Fields > > Regards, > Ishan > > > On Wed, Mar 23, 2016 at 10:33 AM, SHANKAR REDDY < > sankara.teluku...@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
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": https://cwiki.apache.org/confluence/display/solr/Defining+Fields Regards, Ishan On Wed, Mar 23, 2016 at 10:33 AM, SHANKAR REDDY 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 >
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