I would like to inquire that there are more than one field value for the entire document

Elastic Stack Elasticsearch
1

If you look at MS-SQL queries
select T1.column1 AS 'A'
, count(T1.column1) AS 'C'
from Table1 T1
group by column1
having count(column1) > 1

But I would like to have a lookup at the elastic
Will it be possible?

2

It's been a while since I did SQL, but look at using a terms aggregation on the column1 field.

3

@Sihwan or you could try the _sql endpoint with that exact same query. If it works for you and don't want to use SQL, maybe the translate call will help you to get a useful ES query DSL instead.

4

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