How to identify the right engine for SQL-based queries?¶
All SQL big data engines deal with large data sets and have a distributed computing architecture that provides scalability. These engines offer different degrees of support for speedy processing, interactivity, fault tolerance, and type of workload. The most common types of workloads are batch processing, streaming, and interactive queries.
Engines can be differentiated based on the type of workload, SLA Adherence (fault tolerance), and processing speed. Use the decision tree below to arrive at a SQL engine recommendation.