Support for sub-queries with aggregations (where date = (select max(date) from index))
Description
Attachments
2
follows up on
Activity
Show:
shreyash hisariya February 15, 2018 at 10:14 AM
Sure. I can start with design of initial shape of it. If you can help me with the process it will really help.
Also, I have updated the document with content of RuleOutput.
Sanne Grinovero February 14, 2018 at 10:32 AM
Hi , thank you for the very clear feature request.
Could you also clarify the content of RuleOutput ?
We'll take it in consideration, but I'm not sure if we will be able to implement it in short time.
This is probably good material for version 6.1 as it's a new feature and we're very busy with all requirements for 6.0. If it's urgent for you my suggestion is to contribute some patches? We're happy to help, but if you can outline the initial shape of it it would help a lot.
Details
Details
Assignee
Unassigned
UnassignedReporter
shreyash hisariya
shreyash hisariyaComponents
Priority
MajorCreated February 14, 2018 at 6:44 AM
Updated September 25, 2023 at 2:48 PM
I have a use case where I am fetching results from hibernate search documents after indexing. However its not a simple matching query. I need to apply SQL aggregate functions while fetching data from document.
Since it is not supported currently I had to implement all such function in Java itself after fetching a list of entities.
I have attached a document which will illustrate this use case in more detail.
NOTE (Yoann): aggregations are being implemented as part of HSEARCH-3649, but this ticket is about more than just aggregations: it's also about using them in sub-queries and having predicates rely on the result of these sub-queries. Not sure there is such a built-in feature in Elasticsearch, it might require multiple queries. To be investigated.