Spark SQL cassandra delete records
<p>Is there a way to delete some records based on a select query?</p>

<p>I have this query,</p>

<p><code>Select min(id) from ID having count(*)&gt;1</code> which will show the duplicates. I need to get those ids and delete them. How can I do it in spark sql?</p>