Aggregate-on-fields-and-get-distinct-documents

[Rachana_Maniyar (Rachana Soni)]

Hi, I was going through the following thread that talks about how you could get distinct documents with aggregation terms and top hits.

Aggregate on fields and get distinct documents

So I have three documents: Document 1: Title: Paracetamol Subject: SideEffects Body: "some content" Document 2: Title: Paracetamol Type: SideEffects Body: "some different content" Document 3: Title: Paracetamol Type: IndicationsAndDose Body: "some different content" Is it possible to aggregate the results by Title and Type where subject is equal to SideEffects so that the hit count is equal to two. So the following documents would be returned: Document 1: Title: Paracetamol Subje…

my question is, this will work with typically what size of documents ?

I have some million records and the above query yields me READTimeOut error from elasticsearch.

Is there some other way to address getting unique results for this huge dataset ?

just using aggregation terms to get the list of unique documents works fine for this dataset but I need to access the actual document values and using top_hits is giving readTimeout error.
Kindly advise.

Thanks.