let me further elaborate: [db>table1] field1 = int field2= string (solr indexing = true) field3 = csv
[During import into solr] splitBy="," [After import] solr will be searched for terms from field2. [needed] counts of occurrances of each value in csv On Fri, Sep 6, 2013 at 9:35 PM, Raheel Hasan <raheelhasan....@gmail.com>wrote: > Its a csv from the database. I will import it like this, (say for example > the field is 'emailids' and it contain csv of email ids): > <field column="mailId" splitBy="," sourceColName="emailids"/> > > > > On Fri, Sep 6, 2013 at 9:01 PM, Jack Krupansky <j...@basetechnology.com>wrote: > >> You're not being clear here - are the commas delimiting fields or do you >> have one value per row? >> >> Yes, you can tokenize a comma-delimited value in Solr. >> >> >> -- Jack Krupansky >> >> -----Original Message----- From: Raheel Hasan >> Sent: Friday, September 06, 2013 11:54 AM >> To: solr-user@lucene.apache.org >> Subject: Re: Facet Count and RegexTransformer>splitBy >> >> >> Hi, >> >> What I want is very simple: >> >> The "query" results: >> row 1 = a,b,c,d >> row 2 = a,f,r,e >> row 3 = a,c,ff,e,b >> .. >> >> facet count needed: >> 'a' = 3 occurrence >> 'b' = 2 occur. >> 'c' = 2 occur. >> . >> . >> . >> >> >> I searched and found a solution here: >> http://stackoverflow.com/**questions/9914483/solr-facet-** >> multiple-words-with-comma-**separated-values<http://stackoverflow.com/questions/9914483/solr-facet-multiple-words-with-comma-separated-values> >> >> But I want to be sure if it will work. >> >> >> >> On Fri, Sep 6, 2013 at 8:20 PM, Jack Krupansky <j...@basetechnology.com>* >> *wrote: >> >> Facet counts are per field - your counts are scattered across different >>> fields. >>> >>> There are additional capabilities in the facet component, but first you >>> should describe exactly what your requirements are. >>> >>> -- Jack Krupansky >>> -----Original Message----- From: Raheel Hasan >>> Sent: Friday, September 06, 2013 9:58 AM >>> To: solr-user@lucene.apache.org >>> Subject: Facet Count and RegexTransformer>splitBy >>> >>> >>> Hi guyz, >>> >>> Just a quick question: >>> >>> I have a field that has CSV values in the database. So I will use the >>> DataImportHandler and will index it using RegexTransformer's splitBy >>> attribute. However, since this is the first time I am doing it, I just >>> wanted to be sure if it will work for Facet Count? >>> >>> For example: >>> From "query" results (say this is the values in that field): >>> row 1 = 1,2,3,4 >>> row 2 = 1,4,5,3 >>> row 3 = 2,1,20,66 >>> . >>> . >>> . >>> . >>> so facet count will get me: >>> '1' = 3 occurrence >>> '2' = 2 occur. >>> . >>> . >>> .and so on. >>> >>> >>> >>> >>> >>> -- >>> Regards, >>> Raheel Hasan >>> >>> >> >> >> -- >> Regards, >> Raheel Hasan >> > > > > -- > Regards, > Raheel Hasan > -- Regards, Raheel Hasan
