siuba VS beam

I don't know what's best for you, but I can recommend Siuba, a tidy interface for Python to send queries to pandas and SQL-db.

You mean siuba?

For further inspiration, this is a pretty good-looking "dplyr for Python": https://github.com/machow/siuba

You should follow /u/the75th's advice. However, if you decide to buck that take, I'd look into siuba. I've never heard of those packages you've listed, and have doubts they'd be maintained.

Check out siuba

The "streaming systems" book answers your question and more: https://www.oreilly.com/library/view/streaming-systems/97814.... It gives you a history of how batch processing started with MapReduce, and how attempts at scaling by moving towards streaming systems gave us all the subsequent frameworks (Spark, Beam, etc.).

As for the framework called MapReduce, it isn't used much, but its descendant https://beam.apache.org very much is. Nowadays people often use "map reduce" as a shorthand for whatever batch processing system they're building on top of.

Apache Beam is one of many tools that you can use

Flexible runtime ☁️: Temporian programs can run seamlessly in-process in Python, on large datasets using Apache Beam.

To perform the tests I'm using a Kafka cluster on Kubernetes from the Beam repo (here).

Apache Beam: Streaming framework which can be run on several runner such as Apache Flink and GCP Dataflow

Apache Beam: Batch/streaming data processing 🔗Link

What you are looking for is Dataflow. It can be a bit tricky to wrap your head around at first, but I highly suggest leaning into this technology for most of your data engineering needs. It's based on the open source Apache Beam framework that originated at Google. We use an internal version of this system at Google for virtually all of our pipeline tasks, from a few GB, to Exabyte scale systems -- it can do it all.

That being said, there is a learning curve in understanding how Apache Beam works. Take a look at the beam website for more information.