Can we consume the data from Kafka Stream with filters? From their docs, they claimed that we can apply our logics while consuming the data by using stream API. I can't find any samples regarding that.
Yes, filter is a literal method name in the Streams API DSL and examples are readily available in the Kafka Streams documentation pages.
If you want to use SQL for filtering, install KsqlDB or use SparkSQL, Flink, etc.