Re: Seasonal searches in SOLR 5.x
Hi, I suggest having a "season" field (or whatever you might want to call it) using DateRangeField but simply use a nominal year value. So basically all durations would be within this nominal year. For some docs that span new-years, this might mean 2 durations and that's okay. Also it's okay if you have multiple values and it's okay if your calculations result in some that overlap; you needn't make them distinct; it'll all get coalesced in the index. If for some reason you wind up going the route of abusing point data for durations, I recommend this link: http://wiki.apache.org/solr/SpatialForTimeDurations and it most definitely does not require polygons (and thus JTS); I'm not sure what gave you that impression. It's all rectangles & points. ~ David On Mon, Mar 21, 2016 at 1:29 PM Ioannis Kirmitzoglou < ioanniskirmitzog...@gmail.com> wrote: > Hi all, > > I would like to implement seasonal date searches on date ranges. I’m using > SOLR 5.4.1 and have indexed date ranges using a DateRangeField (let’s call > this field date_ranges). > Each document in SOLR corresponds to a biological sample and each sample > was collected during a date range that can span from a single day to > multiple years. For my application it makes sense to enable seasonal > searches, ie find samples that were collected during a specific period of > the year (e.g. summer, or February). In this type of search, the year that > the sample was collected is not relevant, only the days of the year. I’ve > been all over SOLR documentation and I haven’t been able to find anything > that will enable do me that. The closest I got was a post with instructions > on how to use a spatial field to do date searches ( > https://people.apache.org/~hossman/spatial-for-non-spatial-meetup-20130117/). > Using the logic in that post I was able to come up with a solution but it’s > rather complex and needs polygon searches (which in turn means installing > the JTS Topology suite). > Before committing to that I would like to ask for your input and whether > there’s an easier way to do these types of searches. > > Many thanks, > > Ioannis > > - > Ioannis Kirmitzoglou, PhD > Bioinformatician - Scientific Programmer > Imperial College, London > www.vectorbase.org > www.vigilab.org > > -- Lucene/Solr Search Committer, Consultant, Developer, Author, Speaker LinkedIn: http://linkedin.com/in/davidwsmiley | Book: http://www.solrenterprisesearchserver.com
Re: Seasonal searches in SOLR 5.x
You can write an Update Request Processor which takes a pair of date field value and creates a season code value for a separate field, which could be multivalued for date ranges spanning seasons. Similarly you could have another generated multivalued field which listed the months when the data was collected. You could decide whether to store this extra info as an alphanumeric code or a sall integers (1-4 for seasons, 1-12 for months.) -- Jack Krupansky On Mon, Mar 21, 2016 at 1:26 PM, Ioannis Kirmitzoglou < ioanniskirmitzog...@gmail.com> wrote: > Hi all, > > I would like to implement seasonal date searches on date ranges. I’m using > SOLR 5.4.1 and have indexed date ranges using a DateRangeField (let’s call > this field date_ranges). > Each document in SOLR corresponds to a biological sample and each sample > was collected during a date range that can span from a single day to > multiple years. For my application it makes sense to enable seasonal > searches, ie find samples that were collected during a specific period of > the year (e.g. summer, or February). In this type of search, the year that > the sample was collected is not relevant, only the days of the year. I’ve > been all over SOLR documentation and I haven’t been able to find anything > that will enable do me that. The closest I got was a post with instructions > on how to use a spatial field to do date searches ( > https://people.apache.org/~hossman/spatial-for-non-spatial-meetup-20130117/). > Using the logic in that post I was able to come up with a solution but it’s > rather complex and needs polygon searches (which in turn means installing > the JTS Topology suite). > Before committing to that I would like to ask for your input and whether > there’s an easier way to do these types of searches. > > Many thanks, > > Ioannis > > - > Ioannis Kirmitzoglou, PhD > Bioinformatician - Scientific Programmer > Imperial College, London > www.vectorbase.org > www.vigilab.org > >
Seasonal searches in SOLR 5.x
Hi all, I would like to implement seasonal date searches on date ranges. I’m using SOLR 5.4.1 and have indexed date ranges using a DateRangeField (let’s call this field date_ranges). Each document in SOLR corresponds to a biological sample and each sample was collected during a date range that can span from a single day to multiple years. For my application it makes sense to enable seasonal searches, ie find samples that were collected during a specific period of the year (e.g. summer, or February). In this type of search, the year that the sample was collected is not relevant, only the days of the year. I’ve been all over SOLR documentation and I haven’t been able to find anything that will enable do me that. The closest I got was a post with instructions on how to use a spatial field to do date searches (https://people.apache.org/~hossman/spatial-for-non-spatial-meetup-20130117/). Using the logic in that post I was able to come up with a solution but it’s rather complex and needs polygon searches (which in turn means installing the JTS Topology suite). Before committing to that I would like to ask for your input and whether there’s an easier way to do these types of searches. Many thanks, Ioannis - Ioannis Kirmitzoglou, PhD Bioinformatician - Scientific Programmer Imperial College, London www.vectorbase.org www.vigilab.org