Help convert sql to elasticsearch query

i tried to use innerhits but it was not easy.

select parent.key
     , count(child.key) as cnt
  from Docu parent
  left join Docu child
    on parent.key = child.parentKey
 group by parnet.key
 order by cnt desc

please help me ...

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.