Compare the Data in SOLR-优快云博客

本文链接：https://blog.youkuaiyun.com/magic_dreamer/article/details/84913153

本文介绍如何在Solr中通过特定查询条件删除数据，包括按campaign_id筛选并删除记录的方法。此外，还提供了从Solr检索数据的示例，并展示了如何使用Meld这一比较工具来对比数据差异。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Compare the Data in SOLR

How to Clean Data in SOLR
http://xxxx.us-east-1.elasticbeanstalk.com/solr/allJobs/update?commit=true&stream.body=%3Cdelete%3E%3Cquery%3Ecampaign_id:21%3C/query%3E%3C/delete%3E

This will delete all the data filter by query campaign_id=21

Here is How I fetch and get all the reference ID
http://bat-searcher.xxxxx.us-east-1.elasticbeanstalk.com/job/select?q=campaign_id%3A+21&sort=job_reference+asc&rows=10000&fl=job_reference&wt=json&indent=true

http://xxxxxx.us-east-1.elasticbeanstalk.com/solr/allJobs/select?fl=job_reference&q=campaign_id:%2021%20AND%20%20deduped:%20false%20AND%20paused:%20false%20AND%20daily_capped:%20false%20AND%20expired:%20false&rows=10000&sort=job_reference%20asc

Output format of the Response
https://lucene.apache.org/solr/guide/6_6/response-writers.html

In CSV format
http://xxxxxx.us-east-1.elasticbeanstalk.com/solr/allJobs/select?wt=csv&fl=job_reference&q=campaign_id:%2021%20AND%20%20deduped:%20false%20AND%20paused:%20false%20AND%20daily_capped:%20false%20AND%20expired:%20false&rows=10000&sort=job_reference%20asc

http://bat-searcher.xxxxxx.us-east-1.elasticbeanstalk.com/job/select?wt=csv&q=campaign_id%3A+21&sort=job_reference+asc&rows=10000&fl=job_reference&wt=json&indent=true

Command to Clean the Redis Data
>curl -X POST -H 'Content-Type: application/json' 'http://xxxxx.us-east-1.elasticbeanstalk.com/solr/allJobs/update' --data-binary '
{
"delete": { "query":"campaign_id:21" } ,
"commit": {}
}'

Compare Tool Meld for Mac Book
https://github.com/yousseb/meld/releases/

References:
https://github.com/yousseb/meld/releases/