如何在kafka connect中为json消息创建smt?

lyr7nygr  于 2021-06-04  发布在  Kafka
关注(0)|答案(0)|浏览(214)

我正在尝试设置一个kafka连接器,用于使用smt的sink到本地文件系统,以过滤一些消息。kafka主题中的消息是json类型,如下所示:

curl -s https://stream.meetup.com/2/rsvps | kafka-console-producer --broker-list localhost:9092 --topic meetups

{"venue":{"venue_name":"Online event","lon":179.1962,"lat":-8.521147,"venue_id":26906060},"visibility":"public","response":"yes","guests":0,"member":{"member_id":230381644,"photo":"https:\/\/secure.meetupstatic.com\/photos\/member\/4\/6\/9\/c\/thumb_268158076.jpeg","member_name":"Tharindu Gurusinghe"},"rsvp_id":1853832558,"mtime":1603346894745,"event":{"event_name":"IoT Data Architecture - Dave Glover","event_id":"273287718","time":1604487600000,"event_url":"https:\/\/www.meetup.com\/mssgug\/events\/273287718\/"},"group":{"group_topics":[{"urlkey":"web-development","topic_name":"Web Development"},{"urlkey":"microsoft-technology","topic_name":"Microsoft Technology"},{"urlkey":"microsoft-sharepoint-technology","topic_name":"Microsoft SharePoint Technology"},{"urlkey":"powershell","topic_name":"PowerShell"},{"urlkey":"microsoft-azure","topic_name":"Microsoft Azure"},{"urlkey":"microsft","topic_name":"Microsoft"},{"urlkey":"saas-software-as-a-service","topic_name":"SaaS (Software as a Service)"},{"urlkey":"iaas-infrastructure-as-a-service","topic_name":"IaaS (Infrastructure as a Service)"},{"urlkey":"technology","topic_name":"Technology"},{"urlkey":"azure","topic_name":"Azure"},{"urlkey":"dotnet","topic_name":".NET"},{"urlkey":"cloud-computing","topic_name":"Cloud Computing"},{"urlkey":"softwaredev","topic_name":"Software Development"},{"urlkey":"xamarin","topic_name":"Xamarin"}],"group_city":"Singapore","group_country":"sg","group_id":18429776,"group_name":"Azure, Office and Data Community (Singapore)","group_lon":103.85,"group_urlname":"mssgug","group_lat":1.3}}

{"venue":{"venue_name":"New York","lon":-74.005974,"lat":40.712776,"venue_id":26019022},"visibility":"public","response":"no","guests":0,"member":{"member_id":14283290,"photo":"https:\/\/secure.meetupstatic.com\/photos\/member\/5\/b\/c\/3\/thumb_264143491.jpeg","member_name":"karla johnson"},"rsvp_id":1853832556,"mtime":1603346894960,"event":{"event_name":"NY Deadlines: Register to Vote by Oct 9. Request an Absentee Ballot by Oct 27","event_id":"273649014","time":1603839480000,"event_url":"https:\/\/www.meetup.com\/NYC-Experience\/events\/273649014\/"},"group":{"group_topics":[{"urlkey":"cultural-activities","topic_name":"Cultural Activities"},{"urlkey":"performing-arts","topic_name":"Performing Arts"},{"urlkey":"museum","topic_name":"Museum"},{"urlkey":"arts","topic_name":"Arts & Entertainment"},{"urlkey":"fun-times","topic_name":"Fun Times"},{"urlkey":"music","topic_name":"Music"},{"urlkey":"film","topic_name":"Film"},{"urlkey":"philosophy","topic_name":"Philosophy"},{"urlkey":"socialnetwork","topic_name":"Social Networking"},{"urlkey":"diningout","topic_name":"Dining Out"},{"urlkey":"adventure","topic_name":"Adventure"},{"urlkey":"science","topic_name":"Science"},{"urlkey":"intellectual-discussion","topic_name":"Intellectual Discussion"},{"urlkey":"conversation","topic_name":"Conversation"},{"urlkey":"newintown","topic_name":"New In Town"}],"group_city":"New York","group_country":"us","group_id":6745272,"group_name":"\"The NYC Experience\"","group_lon":-74,"group_urlname":"NYC-Experience","group_state":"NY","group_lat":40.72}}

这是为Kafka主题会议生成的两个示例消息。我创建了具有以下配置的连接器:

name=file-sink
connector.class=FileStreamSink
tasks.max=1
file=/root/sink.test
topics=meetups
key.converter=org.apache.kafka.connect.storage.StringConverter
value.converter=org.apache.kafka.connect.storage.StringConverter

我可以看到消息被推送到文件/root/sink.test。下一件事,我想去过滤邮件的基础上“地点”。我只想在“地点”=“纽约”的地方推送消息。实现这一点的确切配置文件是什么?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题