Apache Doris

Apache Doris

The Apache Software Foundation
+
+

Related Products

  • Google Cloud BigQuery
    2,017 Ratings
    Visit Website
  • Teradata VantageCloud
    1,122 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • Denodo
    387 Ratings
    Visit Website
  • Couchbase
    412 Ratings
    Visit Website
  • AnalyticsCreator
    46 Ratings
    Visit Website
  • ChatD&B
    Visit Website
  • QuantaStor
    6 Ratings
    Visit Website
  • DbVisualizer
    583 Ratings
    Visit Website
  • Synchredible
    30 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
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

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
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Pricing

Free
Open source
Free Version
Free Trial

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
Free Trial

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
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

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

Categories

Categories

Data Warehouse Features

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

Database Features

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

ETL Features

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

Integrations

OpenMetadata
AWS Marketplace
Alex Solutions
Castled
ChartMogul
Claude Opus 4
Cube
Cuckoo
Dataplane
ER/Studio Data Architect
Inte Q Genesis
Io-Tahoe
Kater.ai
Lightdash
Lightup
Luzmo
Mesh Security
NextBillion.ai
Polytomic
Sisense

Integrations

OpenMetadata
AWS Marketplace
Alex Solutions
Castled
ChartMogul
Claude Opus 4
Cube
Cuckoo
Dataplane
ER/Studio Data Architect
Inte Q Genesis
Io-Tahoe
Kater.ai
Lightdash
Lightup
Luzmo
Mesh Security
NextBillion.ai
Polytomic
Sisense
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