Get distinct count in json facet

[jay harkhani <ja...@hotmail.com>]

Hello,

We are using Solr v-6.1.0. We have 2 shards and 2 replica. In collection there are lakhs of documents. When make query it returns around 20000 documents. We need distinct count based on docNumber field in json facet query.  We tried to use both unique and hll function but it not return accurate result. In unique function for more than 100 documents while in hll for more than 7000 documents it gives wrong result.

Some documents with field values as below:

docNumber       poi     status
document 1      1       draft   abc
document 2      2       review
xyz
document 3
1       draft
xyz
document 4
3       review
abc
document 5
1       draft
abc

Following query used to get count from solr:

Using hll function:
json.facet={project_id:{type:terms,field:project_id,limit:100,facet:{distcount:"hll(docNumber)",status:{type:terms,field:status,limit:-1,facet:{distcount:"hll(docNumber)",poi:{type:terms,field:poi,limit:-1,facet:{distcount:"hll(docNumber)"}}}}}}}

Using unique function:
json.facet={project_id:{type:terms,field:project_id,limit:100,facet:{distcount:"unique(docNumber)",status:{type:terms,field:status,limit:-1,facet:{distcount:"unique(docNumber)",poi:{type:terms,field:poi,limit:-1,facet:{distcount:"unique(docNumber)"}}}}}}}

Please suggest approach to get distinct count in json.facet.

Regards,
Jay Harkhani.