# Finding duplication using sql api

**URL:** <https://discuss.elastic.co/t/finding-duplication-using-sql-api/184345>\
**Category:** Elasticsearch\
**Created:** [June 5, 2019, 11:43am UTC](https://discuss.elastic.co/t/finding-duplication-using-sql-api/184345 "2019-06-05T11:43:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gurunga011](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@gurunga011](https://discuss.elastic.co/u/gurunga011)\
**Post date:** [June 5, 2019, 11:43am UTC](https://discuss.elastic.co/t/finding-duplication-using-sql-api/184345/1 "2019-06-05T11:43:02Z")

</div>

I am trying to first see and count all of my duplicates in an index using sql api and if possible delete it. Looks like DISTINCT, COUNT is not working on my fields since all the fields has a type"text".

COUNT Error: cannot use non-grouped columns , status 400

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 3, 2019, 11:43am UTC](https://discuss.elastic.co/t/finding-duplication-using-sql-api/184345/2 "2019-07-03T11:43:08Z")

</div>

Closed on July 3, 2019, 11:43am UTC

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