Software Alternatives, Accelerators & Startups
Register | Login

Apache Doris VS Presto DB

Compare Apache Doris VS Presto DB and see what are their differences

Electe
Discover Electe, our data analytics platform dedicated to SMEs. Don't let your data go unused, take your business into the future! featured
Note: These products don't have any matching categories. If you think this is a mistake, please edit the details of one of the products and suggest appropriate categories.
Contents:
  1. » Base Details
  2. » Reviews
  3. » Alternatives

Apache Doris logo Apache Doris

Apache Doris is an open-source real-time data warehouse for big data analytics.

Presto DB logo Presto DB

Distributed SQL Query Engine for Big Data (by Facebook)
  • Apache Doris Apache Doris
    Apache Doris //
    2024-01-10
  • Presto DB Landing page
    Landing page //
    2023-03-18

Apache Doris features and specs

  • High Performance
    Apache Doris is designed to deliver high query performance, especially for aggregate queries, due to its columnar storage and vectorized execution engine.
  • Real-time Analytics
    Supports real-time data analytics with low latency, thanks to its efficient data ingestion processes and real-time data update capabilities.
  • Unified Analytics
    Provides a unified platform that supports both real-time and batch data processing, offering flexibility for different analytical workloads.
  • Ease of Use
    Features a SQL-like interface, which makes it accessible for users familiar with SQL, reducing the learning curve.
  • Scalability
    Can scale out horizontally, allowing it to handle increasing volumes of data and user queries by adding more nodes to the cluster.

Possible disadvantages of Apache Doris

  • Ecosystem Integration
    While improving, the ecosystem isn't as mature as older database management systems, which might pose integration challenges with certain tools.
  • Community Support
    Being a relatively newer project, it may not have as large a community or as extensive third-party support as more established databases.
  • Complexity in Setup
    Initial setup and configuration can be complex, especially for users not already familiar with similar distributed systems.
  • Limited Use Cases
    Optimized specifically for online analytical processing (OLAP), it may not be suitable for all types of databases or transactional use cases.
  • Features Maturity
    Some features may lack the maturity and robustness found in more mature and widely adopted database systems, requiring careful evaluation based on project needs.

Presto DB features and specs

  • High-Performance Query Engine
    Presto is designed for high-performance querying, capable of performing complex analytics and large-scale data processing at interactive speeds.
  • Distributed SQL Query Engine
    Presto can scale out to large clusters of machines, allowing for efficient distribution of queries over multiple servers to handle big data workloads.
  • Versatility
    Supports querying data from multiple data sources such as Hadoop, relational databases, NoSQL databases, and cloud object storage within a single query.
  • ANSI-SQL Compatibility
    Presto supports ANSI SQL, making it easier for users familiar with SQL to adapt and write queries without a steep learning curve.
  • Open Source
    Presto is an open-source project, which means it benefits from continuous community contributions and improvements, keeping it up-to-date and robust.
  • Extensible
    Presto's architecture is designed to be extensible, allowing users to add custom functions and connectors, tailored to specific needs.

Possible disadvantages of Presto DB

  • Resource Intensive
    High performance comes with significant resource requirements, necessitating robust infrastructure to realize its full potential.
  • Complex Configuration
    Setting up and configuring Presto can be complex and time-consuming, often requiring expertise and an understanding of its various components.
  • Limited Support for Transactions
    Presto is primarily designed for reading data and performing analytics, and it has limited support for transactional processing compared to traditional relational databases.
  • Community Support
    While it has a vibrant open-source community, users may find the support less comprehensive than that provided by commercial enterprise solutions.
  • Latency for Small Queries
    Designed for big data and complex queries, Presto may exhibit higher latency for small, simple queries compared to specialized databases optimized for such use cases.
  • Maintenance Overhead
    Managing and maintaining a Presto cluster can be labor-intensive, requiring ongoing tuning and maintenance to ensure optimal performance and reliability.

Category Popularity

0-100% (relative to Apache Doris and Presto DB)

Apache Doris

Presto DB

Databases
65 65%
Databases
35% 35
Data Dashboard
0 0%
Data Dashboard
100% 100
Relational Databases
100 100%
Relational Databases
0% 0
Database Tools
0 0%
Database Tools
100% 100

User comments

Share your experience with using Apache Doris and Presto DB. For example, how are they different and which one is better?
Log in or Post with

Reviews

These are some of the external sources and on-site user reviews we've used to compare Apache Doris and Presto DB

Apache Doris Reviews

Log analysis: Elasticsearch vs Apache Doris
If you are looking for an efficient log analytic solution, Apache Doris is friendly to anyone equipped with SQL knowledge; if you find friction with the ELK stack, try Apache Doris provides better schema-free support, enables faster data writing and queries, and brings much less storage burden.
Source: doris.apache.org

Presto DB Reviews

We have no reviews of Presto DB yet.
Be the first one to post

Social recommendations and mentions

Based on our record, Presto DB should be more popular than Apache Doris. It has been mentiond 10 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

Apache Doris mentions (6)

  • Evolution of Data Sharding Towards Automation and Flexibility
    Like in many databases, Apache Doris shards data into partitions, and then a partition is further divided into buckets. Partitions are typically defined by time or other continuous values. This allows query engines to quickly locate the target data during queries by pruning irrelevant data ranges. - Source: dev.to / 8 months ago
  • Steps to industry-leading query speed: evolution of the Apache Doris execution engine
    What makes a modern database system? The three key modules are query optimizer, execution engine, and storage engine. Among them, the role of execution engine to the DBMS is like the chef to a restaurant. This article focuses on the execution engine of the Apache Doris data warehouse, explaining the secret to its high performance. - Source: dev.to / 9 months ago
  • Apache Doris for log and time series data analysis in NetEase, why not Elasticsearch and InfluxDB?
    For most people looking for a log management and analytics solution, Elasticsearch is the go-to choice. The same applies to InfluxDB for time series data analysis. These were exactly the choices of NetEase, one of the world's highest-yielding game companies but more than that. As NetEase expands its business horizons, the logs and time series data it receives explode, and problems like surging storage costs and... - Source: dev.to / 10 months ago
  • Multi-tenant workload isolation in Apache Doris: a better balance between isolation and utilization
    This is an in-depth introduction to the workload isolation capabilities of Apache Doris. But first of all, why and when do you need workload isolation? If you relate to any of the following situations, read on and you will end up with a solution:. - Source: dev.to / 11 months ago
  • SQL Convertor for Easy Migration from Presto, Trino, ClickHouse, and Hive to Apache Doris
    Apache Doris is an all-in-one data platform that is capable of real-time reporting, ad-hoc queries, data lakehousing, log management and analysis, and batch data processing. As more and more companies have been replacing their component-heavy data architecture with Apache Doris, there is an increasing need for a more convenient data migration solution. That's why the Doris SQL Convertor is made. - Source: dev.to / 11 months ago
View more

Presto DB mentions (10)

  • Data Warehouses and Data Lakes: Understanding Modern Data Storage Paradigms 📦
    Follow Presto at Official Website, Linkedin, Youtube, and Slack channel to join the community. - Source: dev.to / 12 days ago
  • Introduction to Presto: Open Source SQL Query Engine that's changing Big Data Analytics
    In today's data-driven world, organizations face a constant challenge: how to analyse massive datasets quickly and efficiently without moving data between disparate systems. Presto, an open-source distributed SQL query engine that's revolutionizing how we approach big data analytics. - Source: dev.to / 12 days ago
  • Twitter's 600-Tweet Daily Limit Crisis: Soaring GCP Costs and the Open Source Fix Elon Musk Ignored
    Presto: Presto is an open-source distributed SQL query engine that enables querying data from various sources. It provides fast and interactive analytics capabilities, supporting a wide range of data formats and integration with different storage systems. - Source: dev.to / 27 days ago
  • Using IRIS and Presto for high-performance and scalable SQL queries
    The rise of Big Data projects, real-time self-service analytics, online query services, and social networks, among others, have enabled scenarios for massive and high-performance data queries. In response to this challenge, MPP (massively parallel processing database) technology was created, and it quickly established itself. Among the open-source MPP options, Presto (https://prestodb.io/) is the best-known... - Source: dev.to / 4 months ago
  • Parsing logs from multiple data sources with Ahana and Cube
    Presto is an open-source distributed SQL query engine, originally developed at Facebook, now hosted under the Linux Foundation. It connects to multiple databases or other data sources (for example, Amazon S3). We can use a Presto cluster as a single compute engine for an entire data lake. - Source: dev.to / almost 3 years ago
View more

What are some alternatives?

When comparing Apache Doris and Presto DB, you can also consider the following products

ClickHouse - ClickHouse is an open-source column-oriented database management system that allows generating analytical data reports in real time.

Looker - Looker makes it easy for analysts to create and curate custom data experiences—so everyone in the business can explore the data that matters to them, in the context that makes it truly meaningful.

StarRocks - StarRocks offers the next generation of real-time SQL engines for enterprise-scale analytics. Learn how we make it easy to deliver real-time analytics.

Google BigQuery - A fully managed data warehouse for large-scale data analytics.

Apache Hive - Apache Hive data warehouse software facilitates querying and managing large datasets residing in distributed storage.

Jupyter - Project Jupyter exists to develop open-source software, open-standards, and services for interactive computing across dozens of programming languages. Ready to get started? Try it in your browser Install the Notebook.

Loading...