Deleting Documents in Apache Solr manually

ByJerry Richard

Multiple times, we need to remove the collection data manually, Like when it occupies a lot of space in the disk causing other services health problems.

To delete collection data manually, We can use the below command

curl -k --negotiate -u : "https://<Solr server hostname>:<Solr port>/solr/<collection name>/update?commit=true" -H "Content-Type: text/xml" --data-binary "<delete><query>evtTime:[* TO NOW-7DAYS]</query></delete>"

The above command will delete documents older than 7 days.

To Validate, We can run the below command to get the old and latest document and check the event time

# To check the oldest data:

curl -k --negotiate -u : "https://<Solr server host>:<Solr port>/solr/<collection name>/select?q=*%3A*&wt=json&ident=true&rows=1&sort=evtTime+asc"

# To check the latest data:

curl -k --negotiate -u : "https://<Solr server host>:<Solr port>/solr/<collection name>//select?q=*%3A*&wt=json&ident=true&rows=1&sort=evtTime+desc"

Please do share if you have any other ways.

Good Luck with your learning. Like the post if it is useful

Jerry Richard

Jerry grew up in a small town where he enjoyed playing video games. Once out of the nest, he pursued a Bachelor's degree in Computer Engineering. After college, he ultimately landed in the IT industry. Currently, he has over 10 years of experience. In his spare time, Jerry enjoys spending time with his family.

He is creator of this website - learnerkb.com, A website dedicated to share the mistake and experience learned.

Check my bio for more information About Me

Similar Posts