Still the same.
Can the reason be that if there are duplicate logs/documents, then
the Facet query will count them, but when I do the Search Query, solr
eliminates the duplicates?
On Sat, Jan 24, 2015 at 11:47 PM, Ahmet Arslan <iori...@yahoo.com.invalid>
wrote:
>
>
> Hi Harish,
>
> What happens when you purge deleted terms with
> 'solr/core/update?commit=true&expungeDeletes=true'
>
> ahmet
>
>
>
> On Sunday, January 25, 2015 1:59 AM, harish singh <
> harish.sing...@gmail.com> wrote:
> Hi,
>
> I am noticing a strange behavior with solr facet searching:
>
> This is my facet query:
>
>
> - params:
> {
> - facet: "true",
> - sort: "startTimeISO desc",
> - debugQuery: "true",
> - facet.mincount: "1",
> - facet.sort: "count",
> - start: "0",
> - q: "requestType:(*login* or *LOGIN*) AND (user:(blabla*))",
> - facet.limit: "100",
> - facet.field: "loginUserName",
> - wt: "json",
> - fq: "startTimeISO:[2015-01-22T00:00:00.000Z TO
> 2015-01-23T00:00:00.000Z]",
> - rows: "0"
> }
>
>
> The result I am getting is:
>
> facet_counts:
> {
>
> - facet_queries: { },
> - facet_fields:
> {
> - loginUserName:
> [
> - "harry",
> - 36,
> - "larry",
> - 10,
> - "Carey"
> ]
> },
> - facet_dates: { },
> - facet_ranges: { }
>
> }
>
>
>
> As you see, the result is showing Facet-Count for "loginUserName= harry" is
> 36.
>
> So when I do a Solr Search for logs, I should get 36 logs.
> But I am getting 18.
> This happening for all the searches now.
>
>
> For some reason, I see double counting.
>
> Either Facetting is Double counting or Search is half-counting ?
>
>
> This is my Solr Search Query:
>
>
>
> - params:
> {
> - sort: "startTimeISO desc",
> - debugQuery: "true",
> - start: "0",
> - q: "requestType:(*login* or *LOGIN*) AND (user:(blabla*)) AND (
> loginUserName:("harry"))",
> - wt: "json",
> - fq: "startTimeISO:["2015-01-22T00:00:00.000Z" TO
> "2015-01-23T00:00:00.000Z"]",
> - rows: "200"
> }
>
>
>
> This query gives only 18 logs. But Solr Facet Query gave 36.
>
>
> Is there something incorrect in any of my (or both) queries?
> I am trying to debug but it I think I am missing something silly.
>
