Elastic Search Queries : Searching in Nested Array of Documents and Filtering Q by Keval Jain

Hi Soumil, i have one pattern in which i need to search for a specific number. I am using must but even after using must i am getting results other than the query mentioned as well. Is there a way i can just create a query to find the number which i mentioned and not to show any result related to other numbers

What if I know the root/ parent object but not sure about the absolute hierarchy of the value I'm looking for ? For instance, {name: ABC, kids_count: 2, kids: [ {name: AS, kids_count: 1, kids: [{name: JJ, kids_count: 0, kids: [{}] }], {name: XYZ, kids_count: 1, kids: [{name: FOF, kids_count: 0, kids: [{}] }] } ] } and I need to search for a kid with name "FOF" but I'm not sure under which hierarchy he/she would be.

Plz do some facet search

HI Soumil, Can you help me that...how can we write complex query like below in elastic

select distinct t1.referenceno, t2.processstate, t1.processtimestamp from ((SELECT referenceno, MAX(dashboard) AS dashboard, MAX(channel) AS channel, MAX(sequence) AS sequence, MAX(pstr0) AS pstr0, MAX(pstr1) AS pstr1,
MAX(pstr2) AS pstr2, MAX(pstr3) AS pstr3, MAX(pstr4) AS pstr4, MAX(pstr5) AS pstr5, MAX(pstr6) AS pstr6, MAX(pstr7) AS pstr7, MAX(pstr8) AS pstr8, MAX(pstr9) AS pstr9, MAX(pstr10) AS pstr10, MAX(pstr11) AS pstr11, MAX(processtimestamp) AS processtimestamp FROM pmc_temp where processtimestamp IN (select max(processtimestamp) from pmc_temp group by referenceno) GROUP BY referenceno) t1 inner join (select referenceno, processstate from pmc_temp where processtimestamp in (select max(processtimestamp) from pmc_temp group by referenceno) and referenceno
in (select referenceno from pmc_temp group by referenceno)) t2 on t1.referenceno = t2.referenceno);

Thanks in Advance🙂

Hi Soumil, I want to do something like this during update documents. Let's say I have below record in ES,
{
"id": "1",
"student_name": "Rahul",
"books": [
{
"book_id": "11",
"book_name": "History",
"status": "Started"
}
]
}
Now let's say I have received another json to process I need to update the existing document if id is same or just insert it. If I receive below json,
{
"id": "1",
"address": "Bangalore",
"books": [
{
"book_id": "11",
"book_name": "History",
"status": "Finished"
},
{
"book_id": "12",
"book_name": "History",
"status": "Started"
}
]
}
I want to have my final document like below:
{
"id": "1",
"student_name": "Rahul",
"address": "Bangalore",
"books": [
{
"book_id": "11",
"book_name": "History",
"status": "Finished"
},
{
"book_id": "12",
"book_name": "History",
"status": "Started"
}
]
}

I wan to understand whether is it possible to via es queries if yes then want to know the way how to achieve it. Merging at application level and override I can think one way. Please suggest and thanks in advance.

Hi, I've been following your videos, and I'm stuck with a scenario. We get the data from AWS data streams, continuously. So, whenever I search for records, I get the throughout list, instead of getting only the latest records. Can you help me get only the latest records instead of getting them all?

How can we make filter in first index of array only

Other countries don't have background noise or what :D :D

I recommend you do some cutting next time.
I see this was live, was it? Then I understand.
Interresting

How can I search by "group"? help me answer!!! please !!

HI @Somil can you let me know how to do use elastic search template

How to determine the Size? As current default on replay is 10 docs?

Hi Soumil, Is it possible to get the count of all the documents in the inner_hits?

Hi @somil can you tell more about how foreign key system works in case of elastic search.

How to put ..And(must) condition with 2 index

Can you please do a Q and A soon please.