Best Columnar Databases
Columnar databases store data by columns rather than by rows. The data storage format in these solutions makes them faster and more efficient for instant analytical queries. These databases are used mainly in data warehouses to handle and process massive volumes of data from multiple sources by serving as a basis for business intelligence tools. These databases support document creation, retrieval via query, updating and editing, and deletion of information. Columnar stores, because of their data storage format, help minimize resource usage related to queries on big data sets. Businesses interested in implementing a database for data warehousing and big data processing may opt for a columnar database.
There are other database types similar but slightly different than columnar databases software including object-oriented databases software, graph databases, key-value databases, and more.
To qualify for inclusion in the Columnar Databases category, a product must:
Featured Columnar Databases At A Glance
G2 takes pride in showing unbiased reviews on user satisfaction in our ratings and reports. We do not allow paid placements in any of our ratings, rankings, or reports. Learn about our scoring methodologies.
- Overview
- Pros and Cons
- User Satisfaction
- Seller Details
BigQuery is a fully managed, AI-ready data analytics platform that helps you maximize value from your data and is designed to be multi-engine, multi-format, and multi-cloud. Store 10 GiB of data and
- Data Engineer
- Data Analyst
- Information Technology and Services
- Computer Software
- 38% Enterprise
- 35% Mid-Market
32,788,922 Twitter followers
- Overview
- Pros and Cons
- User Satisfaction
- Seller Details
Snowflake makes enterprise AI easy, efficient and trusted. Thousands of companies around the globe, including hundreds of the world’s largest, use Snowflake’s AI Data Cloud to share data, build applic
- Data Engineer
- Data Analyst
- Information Technology and Services
- Computer Software
- 45% Enterprise
- 43% Mid-Market
130 Twitter followers
- Overview
- Pros and Cons
- User Satisfaction
- Seller Details
Tens of thousands of customers use Amazon Redshift, a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your
- Data Engineer
- Senior Data Engineer
- Information Technology and Services
- Computer Software
- 40% Enterprise
- 38% Mid-Market
2,234,689 Twitter followers
- Overview
- Pros and Cons
- User Satisfaction
- Seller Details
MariaDB frees companies from the costs, constraints and complexity of proprietary databases, enabling them to reinvest in what matters most – rapidly developing innovative, customer-facing application
- Software Engineer
- Senior Software Engineer
- Information Technology and Services
- Computer Software
- 43% Small-Business
- 33% Mid-Market
456,290 Twitter followers
- Overview
- Pros and Cons
- User Satisfaction
- Seller Details
An Open-Source Database System
- Computer Software
- 56% Small-Business
- 38% Mid-Market
- Overview
- User Satisfaction
- Seller Details
Vertica is the unified analytics platform, based on a massively scalable architecture with a broad set of analytical functions spanning event and time series, pattern matching, geospatial, and built-i
- Senior Software Engineer
- Data Engineer
- Computer Software
- Information Technology and Services
- 44% Enterprise
- 39% Mid-Market
21,735 Twitter followers
- Overview
- Pros and Cons
- User Satisfaction
- Seller Details
ClickHouse is the fastest and most resource efficient real-time database and data warehouse. ClickHouse is optimized to serve a wide range of data-intensive workloads, from powering interactive user-f
- Information Technology and Services
- 47% Small-Business
- 47% Mid-Market
12,587 Twitter followers
- Overview
- Pros and Cons
- User Satisfaction
- Seller Details
The real-time database for analytics, search, and AI. Store any type of data and combine the simplicity of SQL with the scalability of NoSQL. CrateDB is an open source, multi-model, distributed and co
- Data Engineer
- Software Engineer
- Computer Software
- Consulting
- 54% Small-Business
- 33% Mid-Market
4,222 Twitter followers
- Overview
- User Satisfaction
- Seller Details
Apache Parquet is a columnar storage format available to any project in the Hadoop ecosystem, regardless of the choice of data processing framework, data model or programming language.
- Computer Software
- Information Technology and Services
- 48% Mid-Market
- 30% Small-Business
66,146 Twitter followers
- Overview
- Pros and Cons
- User Satisfaction
- Seller Details
We power the time-aware data-driven decisions that enable fast-moving organizations to realize the full potential of their AI investments and outpace competitors. Our technology delivers transforma
- Financial Services
- Banking
- 57% Enterprise
- 25% Small-Business
4,203 Twitter followers
- Overview
- Pros and Cons
- User Satisfaction
- Seller Details
StarTree Cloud is a fully-managed user-facing real-time analytics Database-as-a-Service (DBaaS) designed for OLAP at massive speed and scale. Based on Apache Pinot™, StarTree Cloud provides enterprise
- Computer Software
- Financial Services
- 35% Mid-Market
- 35% Small-Business
2,243 Twitter followers
- Overview
- User Satisfaction
- Seller Details
A scalable, distributed database that supports structured data storage for large tables. Use HBase when you need random, realtime read/write access to Big Data.
- Software Engineer
- Big Data Engineer
- Computer Software
- Information Technology and Services
- 52% Enterprise
- 27% Mid-Market
66,146 Twitter followers
- Overview
- User Satisfaction
- Seller Details
Apache Kudu is a free and open source column-oriented data store of the Apache Hadoop ecosystem.
- 54% Enterprise
- 46% Mid-Market
66,146 Twitter followers
- Overview
- User Satisfaction
- Seller Details
Apache Druid is an open source real-time analytics database. Druid combines ideas from OLAP/analytic databases, timeseries databases, and search systems to create a complete real-time analytics soluti
- Computer Software
- 52% Enterprise
- 29% Mid-Market
4 Twitter followers
- Overview
- User Satisfaction
- Seller Details
Apache ORC is a self-describing type-aware columnar file format for Hadoop workloads.
- 45% Enterprise
- 36% Mid-Market
66,146 Twitter followers