【RocketMQ】消息过滤-SQL过滤

最新推荐文章于 2025-05-26 17:47:58 发布

Bandeo

最新推荐文章于 2025-05-26 17:47:58 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： RocketMQ

本文链接：https://blog.csdn.net/Bandeo/article/details/104942092

RocketMQ 专栏收录该内容

14 篇文章

订阅专栏

本文介绍了如何在RocketMQ中实现消息过滤，通过在生产者端设置消息属性如'id'，并在消费者端使用MessageSelector.bySql进行SQL过滤，例如过滤id大于0的消息。

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

要实现SQL过滤，需要先修改消息队列的配置文件

在broker的配置文件添加enablePropertyFilter=true

生产者要在消息中添加属性：message.putUserProperty("id",i+"");

public class Producer {
    public static void main(String[] args) throws MQClientException, RemotingException, InterruptedException, MQBrokerException {
        DefaultMQProducer producer = new DefaultMQProducer("sqlFilterGroup");
        producer.setNamesrvAddr("192.168.197.126:9876;192.168.197.123:9876");
        producer.start();
        for (int i = 0; i < 3; i++) {
            Message message = new Message("sqlFilterTopic","tag",("sqlFilterMessage"+i).getBytes());
            //在消息中放入属性id
            message.putUserProperty("id",i+"");
            SendResult sendResult = producer.send(message);
            System.out.println(sendResult);
        }
        producer.shutdown();
    }
}

消费者过滤属性值：consumer.subscribe("sqlFilterTopic", MessageSelector.bySql("id > 0"));

import org.apache.rocketmq.client.consumer.DefaultMQPushConsumer;
import org.apache.rocketmq.client.consumer.MessageSelector;
import org.apache.rocketmq.client.consumer.listener.ConsumeConcurrentlyStatus;
import org.apache.rocketmq.client.consumer.listener.MessageListenerConcurrently;
import org.apache.rocketmq.client.exception.MQClientException;
import org.apache.rocketmq.common.message.MessageExt;

/**
 * 记得修改broker配置文件 enablePropertyFilter=true
 */
public class Consumer {
    public static void main(String[] args) throws MQClientException {
        DefaultMQPushConsumer consumer = new DefaultMQPushConsumer("sqlFilterGroup");
        consumer.setNamesrvAddr("192.168.197.126:9876;192.168.197.123:9876");
        //判断消息中的属性，id是否大于0，大于0的才消费
        consumer.subscribe("sqlFilterTopic", MessageSelector.bySql("id > 0"));
        consumer.registerMessageListener((MessageListenerConcurrently) (list, consumeConcurrentlyContext) -> {
            for (MessageExt messageExt : list) {
                System.out.println("收到消息->"+new String(messageExt.getBody()));
            }
            return ConsumeConcurrentlyStatus.CONSUME_SUCCESS;
        });
        consumer.start();
    }
}