Hi Jörg, That might actually do the trick. I have updated the gist ( https://gist.github.com/bogundersen/e9bac02779e1c4a089dc) with a "Search 4" which uses this method. It gives the expected results, so that is good :) How about the cost of this? We will be doing this for 4-5 facets, and using this method they will all be computed using their own set of filters...
Den fredag den 16. januar 2015 kl. 16.46.46 UTC+1 skrev Jörg Prante: > > Have you considered to use filters / filter buckets like described in the > guide? > > > http://www.elasticsearch.org/guide/en/elasticsearch/guide/current/_filtering_queries_and_aggregations.html > > Jörg > > On Fri, Jan 16, 2015 at 4:15 PM, Bo Finnerup Madsen <bo.gun...@gmail.com > <javascript:>> wrote: > >> Hi, >> >> I am trying to migrate a project from Lucene to elasticsearch, and for >> the most part it is a pleasure :) >> However, I cannot wrap my head around how to recreate the drill sideways >> queries we currently use in Lucene. >> >> The scenario is a basic search page with a free text search and a bunch >> of drill down/sideways facets. In Lucene, the hits that we get for each >> facet, is a correct representation of how many results we would get if that >> facet is used as a limit, but I am unable to do this in elasticsearch... >> >> As an example (full gist available here: >> https://gist.github.com/bogundersen/e9bac02779e1c4a089dc) >> >> I have three items: >> Item 1: >> language : en_GB, >> year: 2013, >> author: [ John, Paul ] >> Item 2: >> language : en_GB, >> year: 2012, >> author: [ John, George ] >> Item 3: >> language : da_DK, >> year: 2012, >> author: [ Ringo ] >> >> Now lets imagine that the user limits to year 2012. If I just include the >> facet in the query ("Search 2" in the gist), I would get the following >> facets: >> year >> 2012 : 2 >> author >> George 1 >> John 1 >> Ringo 1 >> language >> da_DK 1 >> en_GB 1 >> The author and language facets show the correct numbers, but the year >> facet only shows year 2012 thereby not allowing the user to select another >> year without deselecting 2012. >> >> A way around this is to use post filters ("Search 3" in the gist), using >> those I get the following facet results: >> year >> 2012 : 2 >> 2013 : 1 >> author >> John 2 >> George 1 >> Paul 1 >> Ringo 1 >> language >> en_GB 2 >> da_DK 1 >> Here the user is still presented with other years, but the numbers for >> author and language are not correct (e.g. selecting "John" will only give 1 >> result, and not two) >> >> The only way I can think of to make this work, is to do separate queries >> for each facet, but that seems counter intuitive and not very performance >> friendly. Any ideas on how to do this in elasticsearch? >> >> -- >> Bo Madsen >> >> -- >> You received this message because you are subscribed to the Google Groups >> "elasticsearch" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to elasticsearc...@googlegroups.com <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/elasticsearch/2e97801f-a091-4f1d-8e31-1ffb777f287c%40googlegroups.com >> >> <https://groups.google.com/d/msgid/elasticsearch/2e97801f-a091-4f1d-8e31-1ffb777f287c%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/bceb2634-df14-4e3a-bd64-a2e3158a4592%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
