Compare Amazon Redshift and Hive Software

At a Glance
Amazon Redshift
Amazon Redshift
Star Rating
(400)4.3 out of 5
Market Segments
Mid-Market (40.0% of reviews)
Information
Pros & Cons
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plans
Hive
Hive
Star Rating
(60)4.2 out of 5
Market Segments
Enterprise (54.4% of reviews)
Information
Pros & Cons
Not enough data
Entry-Level Pricing
No pricing available
Learn more about Hive

Amazon Redshift vs Hive

When assessing the two solutions, reviewers found Amazon Redshift easier to use, set up, and administer. Reviewers also preferred doing business with Amazon Redshift overall.

  • Reviewers felt that Amazon Redshift meets the needs of their business better than Hive.
  • When comparing quality of ongoing product support, reviewers felt that Amazon Redshift is the preferred option.
  • For feature updates and roadmaps, our reviewers preferred the direction of Amazon Redshift over Hive.
Pricing
Entry-Level Pricing
Amazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
Browse all 6 pricing plans
Hive
No pricing available
Free Trial
Amazon Redshift
Free Trial is available
Hive
No trial information available
Ratings
Meets Requirements
8.7
284
8.2
52
Ease of Use
8.7
284
8.4
52
Ease of Setup
8.6
141
7.8
20
Ease of Admin
8.4
129
7.5
19
Quality of Support
8.5
267
7.7
46
Has the product been a good partner in doing business?
8.7
128
8.2
16
Product Direction (% positive)
8.9
255
7.6
48
Features by Category
8.4
150
8.3
12
Data Management
8.8
135
|
Verified
9.2
10
|
Verified
8.4
125
|
Verified
8.0
11
|
Verified
8.8
131
|
Verified
8.2
11
|
Verified
8.0
127
|
Verified
8.3
11
|
Verified
7.6
102
|
Verified
7.1
8
|
Verified
8.3
119
|
Verified
8.1
9
|
Verified
Integration
7.9
101
|
Verified
Feature Not Available
8.7
129
|
Verified
7.8
9
|
Verified
8.6
119
|
Verified
Feature Not Available
Deployment
8.1
102
8.0
11
|
Verified
8.9
131
|
Verified
9.2
6
|
Verified
Performance
8.9
136
|
Verified
7.9
11
|
Verified
Security
8.7
126
|
Verified
9.0
10
|
Verified
8.8
128
|
Verified
8.8
11
|
Verified
Generative AI
7.3
20
Not enough data
7.2
19
Not enough data
8.3
63
Not enough data
Storage
8.4
53
Not enough data
8.4
56
Not enough data
Availability
8.6
47
Not enough data
8.2
50
Not enough data
8.4
48
Not enough data
Performance
8.2
48
Not enough data
Security
8.7
47
Not enough data
8.4
52
Not enough data
8.1
47
Not enough data
8.5
48
Not enough data
Support
7.9
43
Not enough data
8.5
47
Not enough data
Categories
Categories
Shared Categories
Amazon Redshift
Amazon Redshift
Hive
Hive
Amazon Redshift and Hive are categorized as Data Warehouse
Unique Categories
Amazon Redshift
Amazon Redshift is categorized as Columnar Databases and Big Data Integration Platforms
Hive
Hive has no unique categories
Reviews
Reviewers' Company Size
Amazon Redshift
Amazon Redshift
Small-Business(50 or fewer emp.)
20.8%
Mid-Market(51-1000 emp.)
40.0%
Enterprise(> 1000 emp.)
39.2%
Hive
Hive
Small-Business(50 or fewer emp.)
10.5%
Mid-Market(51-1000 emp.)
35.1%
Enterprise(> 1000 emp.)
54.4%
Reviewers' Industry
Amazon Redshift
Amazon Redshift
Information Technology and Services
15.3%
Computer Software
12.6%
Financial Services
7.7%
Retail
5.2%
Marketing and Advertising
4.7%
Other
54.5%
Hive
Hive
Computer Software
19.3%
Internet
19.3%
Information Technology and Services
14.0%
Higher Education
7.0%
Retail
3.5%
Other
36.8%
Alternatives
Amazon Redshift
Amazon Redshift Alternatives
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
Snowflake
Snowflake
Add Snowflake
OpenText Vertica
OpenText Vertica
Add OpenText Vertica
Cloudera
Cloudera
Add Cloudera
Hive
Hive Alternatives
Snowflake
Snowflake
Add Snowflake
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
Teradata Vantage
Teradata Vantage
Add Teradata Vantage
Oracle Exadata Cloud Service
Oracle Exadata Cloud Service
Add Oracle Exadata Cloud Service
Discussions
Amazon Redshift
Amazon Redshift Discussions
Should I use with a data mart for a frontend tool that make request on it ?
3 Comments
NM
Hi Mehdi Can you elaborate your question? AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases. You can...Read more
When can I use Amazon redshift?
3 Comments
Prakash G.
PG
Redshift is big data warehousing solution to handle petabytes of data and also for real time decisions. If you want highly optimized data warehousing...Read more
What are the characteristics of redshift?
2 Comments
Anil K.
AK
Redshift is mainly used for Big data and analytics to store the data in columner format. Retrieve the data is very fast and parallel processing also most...Read more
Hive
Hive Discussions
Monty the Mongoose crying
Hive has no discussions with answers