Best Columnar Databases for Medium-Sized Businesses

Shalaka Joshi
SJ
Researched and written by Shalaka Joshi

Products classified in the overall Columnar Databases category are similar in many regards and help companies of all sizes solve their business problems. However, medium-sized business features, pricing, setup, and installation differ from businesses of other sizes, which is why we match buyers to the right Medium-Sized Business Columnar Databases to fit their needs. Compare product ratings based on reviews from enterprise users or connect with one of G2's buying advisors to find the right solutions within the Medium-Sized Business Columnar Databases category.

In addition to qualifying for inclusion in the Columnar Databases category, to qualify for inclusion in the Medium-Sized Business Columnar Databases category, a product must have at least 10 reviews left by a reviewer from a medium-sized business.

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.

1 filter applied
Clear All
6 Listings in Columnar Databases Available
(1,096)4.5 out of 5
2nd Easiest To Use in Columnar Databases software
View top Consulting Services for Google Cloud BigQuery
Save to My Lists
Entry Level Price:Free
  • Overview
    Expand/Collapse Overview
  • Product Description
    How are these determined?Information
    This description is provided by the seller.

    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

    Users
    • Data Engineer
    • Data Analyst
    Industries
    • Information Technology and Services
    • Computer Software
    Market Segment
    • 38% Enterprise
    • 32% Mid-Market
  • Pros and Cons
    Expand/Collapse Pros and Cons
  • Google Cloud BigQuery Pros and Cons
    How are these determined?Information
    Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
    Pros
    Ease of Use
    344
    Speed
    191
    Fast Querying
    171
    Querying
    162
    Performance
    160
    Cons
    Expensive
    153
    Query Issues
    139
    Learning Curve
    109
    Cost Issues
    86
    Cost Management
    84
  • User Satisfaction
    Expand/Collapse User Satisfaction
  • Google Cloud BigQuery features and usability ratings that predict user satisfaction
    8.9
    Data Model
    Average: 8.8
    8.8
    Data Types
    Average: 8.5
    8.7
    Has the product been a good partner in doing business?
    Average: 8.5
    8.7
    Integrated Cache
    Average: 8.5
  • Seller Details
    Expand/Collapse Seller Details
  • Seller Details
    Seller
    Google
    Company Website
    Year Founded
    1998
    HQ Location
    Mountain View, CA
    Twitter
    @google
    32,581,844 Twitter followers
    LinkedIn® Page
    www.linkedin.com
    301,875 employees on LinkedIn®
Product Description
How are these determined?Information
This description is provided by the seller.

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

Users
  • Data Engineer
  • Data Analyst
Industries
  • Information Technology and Services
  • Computer Software
Market Segment
  • 38% Enterprise
  • 32% Mid-Market
Google Cloud BigQuery Pros and Cons
How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Ease of Use
344
Speed
191
Fast Querying
171
Querying
162
Performance
160
Cons
Expensive
153
Query Issues
139
Learning Curve
109
Cost Issues
86
Cost Management
84
Google Cloud BigQuery features and usability ratings that predict user satisfaction
8.9
Data Model
Average: 8.8
8.8
Data Types
Average: 8.5
8.7
Has the product been a good partner in doing business?
Average: 8.5
8.7
Integrated Cache
Average: 8.5
Seller Details
Seller
Google
Company Website
Year Founded
1998
HQ Location
Mountain View, CA
Twitter
@google
32,581,844 Twitter followers
LinkedIn® Page
www.linkedin.com
301,875 employees on LinkedIn®
(584)4.5 out of 5
Optimized for quick response
1st Easiest To Use in Columnar Databases software
View top Consulting Services for Snowflake
Save to My Lists
Entry Level Price:$2 Compute/Hour
  • Overview
    Expand/Collapse Overview
  • Product Description
    How are these determined?Information
    This description is provided by the seller.

    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

    Users
    • Data Engineer
    • Software Engineer
    Industries
    • Computer Software
    • Information Technology and Services
    Market Segment
    • 47% Enterprise
    • 40% Mid-Market
  • Pros and Cons
    Expand/Collapse Pros and Cons
  • Snowflake Pros and Cons
    How are these determined?Information
    Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
    Pros
    Ease of Use
    131
    Features
    75
    Data Management
    63
    Efficiency Improvement
    61
    Database Management
    58
    Cons
    Expensive
    55
    Feature Limitations
    46
    Limited Features
    33
    Missing Features
    28
    Query Issues
    28
  • User Satisfaction
    Expand/Collapse User Satisfaction
  • Snowflake features and usability ratings that predict user satisfaction
    9.1
    Data Model
    Average: 8.8
    9.1
    Data Types
    Average: 8.5
    9.0
    Has the product been a good partner in doing business?
    Average: 8.5
    9.2
    Integrated Cache
    Average: 8.5
  • Seller Details
    Expand/Collapse Seller Details
  • Seller Details
    Company Website
    Year Founded
    2012
    HQ Location
    San Mateo, CA
    Twitter
    @SnowflakeDB
    55,922 Twitter followers
    LinkedIn® Page
    www.linkedin.com
    8,874 employees on LinkedIn®
Product Description
How are these determined?Information
This description is provided by the seller.

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

Users
  • Data Engineer
  • Software Engineer
Industries
  • Computer Software
  • Information Technology and Services
Market Segment
  • 47% Enterprise
  • 40% Mid-Market
Snowflake Pros and Cons
How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Ease of Use
131
Features
75
Data Management
63
Efficiency Improvement
61
Database Management
58
Cons
Expensive
55
Feature Limitations
46
Limited Features
33
Missing Features
28
Query Issues
28
Snowflake features and usability ratings that predict user satisfaction
9.1
Data Model
Average: 8.8
9.1
Data Types
Average: 8.5
9.0
Has the product been a good partner in doing business?
Average: 8.5
9.2
Integrated Cache
Average: 8.5
Seller Details
Company Website
Year Founded
2012
HQ Location
San Mateo, CA
Twitter
@SnowflakeDB
55,922 Twitter followers
LinkedIn® Page
www.linkedin.com
8,874 employees on LinkedIn®

This is how G2 Deals can help you:

  • Easily shop for curated – and trusted – software
  • Own your own software buying journey
  • Discover exclusive deals on software
(399)4.3 out of 5
3rd Easiest To Use in Columnar Databases software
View top Consulting Services for Amazon Redshift
Save to My Lists
Entry Level Price:$1.22 - $3.26 Per hour
  • Overview
    Expand/Collapse Overview
  • Product Description
    How are these determined?Information
    This description is provided by the seller.

    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

    Users
    • Data Engineer
    • Senior Data Engineer
    Industries
    • Information Technology and Services
    • Computer Software
    Market Segment
    • 40% Enterprise
    • 37% Mid-Market
  • Pros and Cons
    Expand/Collapse Pros and Cons
  • Amazon Redshift Pros and Cons
    How are these determined?Information
    Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
    Pros
    Ease of Use
    17
    Fast Querying
    10
    Speed
    10
    Fast Processing
    8
    Large Datasets
    8
    Cons
    Expensive
    8
    Feature Limitations
    6
    Query Issues
    6
    Slow Queries
    5
    Performance Issues
    4
  • User Satisfaction
    Expand/Collapse User Satisfaction
  • Amazon Redshift features and usability ratings that predict user satisfaction
    8.4
    Data Model
    Average: 8.8
    8.4
    Data Types
    Average: 8.5
    8.7
    Has the product been a good partner in doing business?
    Average: 8.5
    8.3
    Integrated Cache
    Average: 8.5
  • Seller Details
    Expand/Collapse Seller Details
  • Seller Details
    Year Founded
    2006
    HQ Location
    Seattle, WA
    Twitter
    @awscloud
    2,232,026 Twitter followers
    LinkedIn® Page
    www.linkedin.com
    136,383 employees on LinkedIn®
    Ownership
    NASDAQ: AMZN
Product Description
How are these determined?Information
This description is provided by the seller.

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

Users
  • Data Engineer
  • Senior Data Engineer
Industries
  • Information Technology and Services
  • Computer Software
Market Segment
  • 40% Enterprise
  • 37% Mid-Market
Amazon Redshift Pros and Cons
How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Ease of Use
17
Fast Querying
10
Speed
10
Fast Processing
8
Large Datasets
8
Cons
Expensive
8
Feature Limitations
6
Query Issues
6
Slow Queries
5
Performance Issues
4
Amazon Redshift features and usability ratings that predict user satisfaction
8.4
Data Model
Average: 8.8
8.4
Data Types
Average: 8.5
8.7
Has the product been a good partner in doing business?
Average: 8.5
8.3
Integrated Cache
Average: 8.5
Seller Details
Year Founded
2006
HQ Location
Seattle, WA
Twitter
@awscloud
2,232,026 Twitter followers
LinkedIn® Page
www.linkedin.com
136,383 employees on LinkedIn®
Ownership
NASDAQ: AMZN
(216)4.3 out of 5
4th Easiest To Use in Columnar Databases software
Save to My Lists
Entry Level Price:Free
  • Overview
    Expand/Collapse Overview
  • Product Description
    How are these determined?Information
    This description is provided by the seller.

    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

    Users
    • Senior Software Engineer
    • Data Engineer
    Industries
    • Computer Software
    • Information Technology and Services
    Market Segment
    • 44% Enterprise
    • 39% Mid-Market
  • Pros and Cons
    Expand/Collapse Pros and Cons
  • OpenText Vertica Pros and Cons
    How are these determined?Information
    Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
    Pros
    Analytics
    13
    Ease of Use
    12
    Fast Processing
    12
    Performance
    11
    Features
    10
    Cons
    Expensive
    11
    Difficulty
    7
    Learning Curve
    6
    Complexity
    4
    Complex Setup
    4
  • User Satisfaction
    Expand/Collapse User Satisfaction
  • OpenText Vertica features and usability ratings that predict user satisfaction
    8.4
    Data Model
    Average: 8.8
    8.0
    Data Types
    Average: 8.5
    8.3
    Has the product been a good partner in doing business?
    Average: 8.5
    8.5
    Integrated Cache
    Average: 8.5
  • Seller Details
    Expand/Collapse Seller Details
  • Seller Details
    Seller
    OpenText
    Year Founded
    1991
    HQ Location
    Waterloo, ON
    Twitter
    @OpenText
    21,932 Twitter followers
    LinkedIn® Page
    www.linkedin.com
    22,114 employees on LinkedIn®
    Ownership
    NASDAQ:OTEX
Product Description
How are these determined?Information
This description is provided by the seller.

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

Users
  • Senior Software Engineer
  • Data Engineer
Industries
  • Computer Software
  • Information Technology and Services
Market Segment
  • 44% Enterprise
  • 39% Mid-Market
OpenText Vertica Pros and Cons
How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Analytics
13
Ease of Use
12
Fast Processing
12
Performance
11
Features
10
Cons
Expensive
11
Difficulty
7
Learning Curve
6
Complexity
4
Complex Setup
4
OpenText Vertica features and usability ratings that predict user satisfaction
8.4
Data Model
Average: 8.8
8.0
Data Types
Average: 8.5
8.3
Has the product been a good partner in doing business?
Average: 8.5
8.5
Integrated Cache
Average: 8.5
Seller Details
Seller
OpenText
Year Founded
1991
HQ Location
Waterloo, ON
Twitter
@OpenText
21,932 Twitter followers
LinkedIn® Page
www.linkedin.com
22,114 employees on LinkedIn®
Ownership
NASDAQ:OTEX
  • Overview
    Expand/Collapse Overview
  • Product Description
    How are these determined?Information
    This description is provided by the seller.

    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.

    Users
    No information available
    Industries
    • Computer Software
    • Information Technology and Services
    Market Segment
    • 48% Mid-Market
    • 30% Small-Business
  • Pros and Cons
    Expand/Collapse Pros and Cons
  • Apache Parquet Pros and Cons
    How are these determined?Information
    Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
    Pros
    Data Storage
    12
    Efficiency
    4
    Integrations
    3
    Speed
    3
    Cost Efficiency
    2
    Cons
    Performance Issues
    4
    Complexity
    2
    Learning Curve
    2
    Limited Data Support
    2
    Scalability Issues
    2
  • User Satisfaction
    Expand/Collapse User Satisfaction
  • Apache Parquet features and usability ratings that predict user satisfaction
    9.0
    Data Model
    Average: 8.8
    8.8
    Data Types
    Average: 8.5
    7.5
    Has the product been a good partner in doing business?
    Average: 8.5
    8.6
    Integrated Cache
    Average: 8.5
  • Seller Details
    Expand/Collapse Seller Details
  • Seller Details
    Year Founded
    1999
    HQ Location
    Wakefield, MA
    Twitter
    @TheASF
    66,224 Twitter followers
    LinkedIn® Page
    www.linkedin.com
    2,291 employees on LinkedIn®
Product Description
How are these determined?Information
This description is provided by the seller.

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.

Users
No information available
Industries
  • Computer Software
  • Information Technology and Services
Market Segment
  • 48% Mid-Market
  • 30% Small-Business
Apache Parquet Pros and Cons
How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Data Storage
12
Efficiency
4
Integrations
3
Speed
3
Cost Efficiency
2
Cons
Performance Issues
4
Complexity
2
Learning Curve
2
Limited Data Support
2
Scalability Issues
2
Apache Parquet features and usability ratings that predict user satisfaction
9.0
Data Model
Average: 8.8
8.8
Data Types
Average: 8.5
7.5
Has the product been a good partner in doing business?
Average: 8.5
8.6
Integrated Cache
Average: 8.5
Seller Details
Year Founded
1999
HQ Location
Wakefield, MA
Twitter
@TheASF
66,224 Twitter followers
LinkedIn® Page
www.linkedin.com
2,291 employees on LinkedIn®
(114)4.2 out of 5
5th Easiest To Use in Columnar Databases software
Save to My Lists
  • Overview
    Expand/Collapse Overview
  • Product Description
    How are these determined?Information
    This description is provided by the seller.

    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.

    Users
    • Software Engineer
    • Big Data Engineer
    Industries
    • Information Technology and Services
    • Computer Software
    Market Segment
    • 52% Enterprise
    • 27% Mid-Market
  • User Satisfaction
    Expand/Collapse User Satisfaction
  • Hbase features and usability ratings that predict user satisfaction
    8.1
    Data Model
    Average: 8.8
    7.2
    Data Types
    Average: 8.5
    8.0
    Has the product been a good partner in doing business?
    Average: 8.5
    7.0
    Integrated Cache
    Average: 8.5
  • Seller Details
    Expand/Collapse Seller Details
  • Seller Details
    Year Founded
    1999
    HQ Location
    Wakefield, MA
    Twitter
    @TheASF
    66,224 Twitter followers
    LinkedIn® Page
    www.linkedin.com
    2,291 employees on LinkedIn®
Product Description
How are these determined?Information
This description is provided by the seller.

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.

Users
  • Software Engineer
  • Big Data Engineer
Industries
  • Information Technology and Services
  • Computer Software
Market Segment
  • 52% Enterprise
  • 27% Mid-Market
Hbase features and usability ratings that predict user satisfaction
8.1
Data Model
Average: 8.8
7.2
Data Types
Average: 8.5
8.0
Has the product been a good partner in doing business?
Average: 8.5
7.0
Integrated Cache
Average: 8.5
Seller Details
Year Founded
1999
HQ Location
Wakefield, MA
Twitter
@TheASF
66,224 Twitter followers
LinkedIn® Page
www.linkedin.com
2,291 employees on LinkedIn®