I have a SOLR 8.X.  I suspect one of the core has duplicates and wants to
remove the duplicated documents.  Signature, as in the SOLR guide, is not
implemented.  https://solr.apache.org/guide/6_6/de-duplication.html

in sql, a query without the use of a hash column will be liked:
;WITH CTE AS
(
    SELECT  cols,
            RN = ROW_NUMBER() OVER( PARTITION BY cols
                                    ORDER BY updated DESC)
    FROM [table]
)
DELETE FROM CTE
WHERE RN > 1

what would be the syntax for SOLR query?

Reply via email to