Apache Doris

Apache Doris

The Apache Software Foundation
+
+

Related Products

  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • Couchbase
    417 Ratings
    Visit Website
  • ChatD&B
    Visit Website
  • QuantaStor
    6 Ratings
    Visit Website
  • DbVisualizer
    593 Ratings
    Visit Website
  • Proton Drive
    3,602 Ratings
    Visit Website
  • IONOS Cloud Object Storage
    45,199 Ratings
    Visit Website
  • Synchredible
    30 Ratings
    Visit Website
  • PeerGFS
    28 Ratings
    Visit Website

About

Apache Doris is a modern data warehouse for real-time analytics. It delivers lightning-fast analytics on real-time data at scale. Push-based micro-batch and pull-based streaming data ingestion within a second. Storage engine with real-time upsert, append and pre-aggregation. Optimize for high-concurrency and high-throughput queries with columnar storage engine, MPP architecture, cost based query optimizer, vectorized execution engine. Federated querying of data lakes such as Hive, Iceberg and Hudi, and databases such as MySQL and PostgreSQL. Compound data types such as Array, Map and JSON. Variant data type to support auto data type inference of JSON data. NGram bloomfilter and inverted index for text searches. Distributed design for linear scalability. Workload isolation and tiered storage for efficient resource management. Supports shared-nothing clusters as well as separation of storage and compute.

About

Snowflake is a comprehensive AI Data Cloud platform designed to eliminate data silos and simplify data architectures, enabling organizations to get more value from their data. The platform offers interoperable storage that provides near-infinite scale and access to diverse data sources, both inside and outside Snowflake. Its elastic compute engine delivers high performance for any number of users, workloads, and data volumes with seamless scalability. Snowflake’s Cortex AI accelerates enterprise AI by providing secure access to leading large language models (LLMs) and data chat services. The platform’s cloud services automate complex resource management, ensuring reliability and cost efficiency. Trusted by over 11,000 global customers across industries, Snowflake helps businesses collaborate on data, build data applications, and maintain a competitive edge.

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Developers interested in an open source, real-time data warehouse

Audience

Organizations interested in a powerful and comprehensive cloud data platform

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Not Supported

Support

Phone Support Not Supported
24/7 Live Support Supported
Online Supported

API

Offers API Not Supported

API

Offers API Not Supported

Screenshots and Videos

Screenshots and Videos

Pricing

Free
Open source
Free Version Supported
Free Trial Not Supported

Pricing

$2/credit
Pay for the compute and storage you actually use.
- Turn compute resources on and off, so you only pay for what you use
- Store near-unlimited amounts of data at affordable cloud rates
- Grow your analytics infrastructure with linear cost scalability
Free Version Not Supported
Free Trial Supported

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 4.8 / 5
ease 4.8 / 5
features 5.0 / 5
design 4.8 / 5
support 4.8 / 5

Pros & Cons from Real Users

Pros

  • Snowflake is being used across our whole organization. It addresses the need to combine disparate data sources into one single data source and discover insights into our business that would not be easily possible with lots of disconnected data sources. It has great SQL features like LISTAGG or Count Distinct, which go above and beyond Oracle and MS SQL. - Reporting queries run in a fraction of the time that they would in our production systems - We can run simple SQL queries. - Scales up and down seamlessly - Optimized table structures under the hood - Sharing data between accounts - Easy if use - Continuous data pipelines - Snowflake also includes caching at various levels to help speed up your queries and minimum costs. - Support members are very good.
  • Snowflake is acting as a company-wide Data Repository. With its cloud architecture and scalability, it addresses our storage, warehouse, and computation problem at the same time. Snowflake has powerful group roles and policy, which makes it beneficial for enterprise edition and usage. Snowflake acts as a single platform for both data storage and warehousing needs. For deployment purposes, it has the best group policy management and the best UI I've encountered personally. It also accommodates direct connection with AWS and Azure, which is another advantage. - Hosted on cloud: Helps with scalability. - Handling large data scale and ingestion - Separation of compute and storage - Community is active and ever-growing: You will have someone from the community to help whenever you need it.
  • Simple & clean interface Great querying performance Integration with all the major cloud providers Easy to learn querying language Good documentation
  • (+) Easy to adapt and easy to use. (+) The run time of queries is much faster compared to other products in the market. (+) One can select a part of a query for execution. (+) Integration with S3 and other data storage platforms makes snowflake more compatible. (+) One may run concurrent queries without giving up on speed.

Cons

  • Nothing to dislike in Snowflake. Awesome data warehouse for huge data set.
  • - Very expensive - Indexing by primary key is non performant
  • Web based IDE is not suitable for writing complex queries, it feels sluggish when heavily used.
  • (-) Performance drops in the case of multiple users. (-) No option for scheduling of a task or a query. (-) The coding syntax has some restrictions like the case-sensitivity issue.

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Company Information

The Apache Software Foundation
Founded: 1999
United States
doris.apache.org

Company Information

Snowflake
Founded: 2012
United States
www.snowflake.com

Alternatives

Alternatives

Denodo

Denodo

Denodo Technologies

Categories

Categories

AI Cloud Providers Supported
AI Infrastructure Supported
Big Data Supported
Columnar Databases Supported
Data Clean Room Supported
Data Exchange Supported
Data Governance Supported
Data Lake Supported
Data Management Supported
Data Marketplaces Supported
Data Monetization Supported
Data Preparation Supported
Data Science Supported
Data Warehouse Supported
Database Supported
ETL Supported
LLM API Supported
Machine Learning Supported
OLAP Databases Supported
Query Engines Supported
SQL Databases Supported

Data Warehouse Features

Ad hoc Query Not Supported
Analytics Supported
Data Integration Not Supported
Data Migration Supported
Data Quality Control Not Supported
ETL - Extract / Transfer / Load Not Supported
In-Memory Processing Not Supported
Match & Merge Not Supported

Database Features

Backup and Recovery Not Supported
Creation / Development Not Supported
Data Migration Not Supported
Data Replication Not Supported
Data Search Not Supported
Data Security Not Supported
Database Conversion Not Supported
Mobile Access Not Supported
Monitoring Not Supported
NOSQL Not Supported
Performance Analysis Supported
Queries Not Supported
Relational Interface Not Supported
Virtualization Not Supported

ETL Features

Data Analysis Supported
Data Filtering Not Supported
Data Quality Control Not Supported
Job Scheduling Not Supported
Match & Merge Not Supported
Metadata Management Not Supported
Non-Relational Transformations Not Supported
Version Control Not Supported

Integrations

OpenMetadata Supported
Baidu Palo Supported
Causal Not Supported
DataBahn Not Supported
DeepSeek Not Supported
Dema Not Supported
Eppo Not Supported
GPT-4.1 mini Not Supported
Gravity Data Not Supported
Nucleon Database Master Not Supported
SSIS Integration Toolkit Not Supported
Select Star Not Supported
Signara Not Supported
Supaflow Not Supported
Tokern Not Supported
Yogi Not Supported
actiondesk Not Supported
erwin Data Intelligence Not Supported
iDerive Not Supported

Integrations

OpenMetadata Supported
Baidu Palo Not Supported
Causal Supported
DataBahn Supported
DeepSeek Supported
Dema Supported
Eppo Supported
GPT-4.1 mini Supported
Gravity Data Supported
Nucleon Database Master Supported
SSIS Integration Toolkit Supported
Select Star Supported
Signara Supported
Supaflow Supported
Tokern Supported
Yogi Supported
actiondesk Supported
erwin Data Intelligence Supported
iDerive Supported
Claim Apache Doris and update features and information
Claim Apache Doris and update features and information
Claim Snowflake and update features and information
Claim Snowflake and update features and information