Introducing G2.ai, the future of software buying.Try now
Compare Amazon Redshift and Hive Software 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Starburst
Visit Website
At a Glance
Market Segments
Mid-Market (39.5% of reviews)
Enterprise (54.4% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
No pricing available
Amazon Redshift
Star Rating
(397)4.3 out of 5
Market Segments
Mid-Market (39.5% of reviews)
Pros & Cons
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansHive
Star Rating
(60)4.2 out of 5
Market Segments
Enterprise (54.4% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about HiveSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Hive excels in data integration with a score of 9.2, allowing seamless connections with various data sources, while Amazon Redshift, with a score of 8.8, is slightly less flexible in this area.
- Reviewers mention that Hive's built-in data analytics feature scores 8.3, providing robust analytical capabilities, whereas Amazon Redshift's score of 8.1 indicates it may not be as comprehensive in this aspect.
- G2 users highlight that Hive's data lake integration is rated at 9.0, making it a strong choice for organizations utilizing data lakes, while Amazon Redshift's score of 8.6 suggests it may not be as optimized for this use case.
- Users on G2 report that Amazon Redshift shines in scalability with a score of 8.9, making it suitable for growing data needs, while Hive's score of 7.9 indicates it may face challenges in scaling efficiently.
- Reviewers mention that both products have similar data security ratings, with Hive at 8.8 and Amazon Redshift also at 8.8, indicating that both platforms provide robust security features, but specific user experiences may vary.
- Users say that Hive's ease of setup is rated at 7.8, which some find challenging compared to Amazon Redshift's higher score of 8.6, suggesting that Redshift may offer a more user-friendly onboarding experience.
Pricing
Entry-Level Pricing
Amazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
On-demand, 1-Year, or 3-Year Terms
- Commit to save up to 34%
Hive
No pricing availableFree Trial
Amazon Redshift
Free Trial is available
Hive
No trial information availableRatings
Meets Requirements
8.7
281
8.2
52
Ease of Use
8.7
281
8.4
52
Ease of Setup
8.6
138
7.8
20
Ease of Admin
8.4
128
7.5
19
Quality of Support
8.5
264
7.7
46
Has the product been a good partner in doing business?
8.7
127
8.2
16
Product Direction (% positive)
8.8
252
7.6
48
Features by Category
Data Management
8.8
133
|
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
118
|
Verified
8.1
9
|
Verified
Integration
7.9
101
|
Verified
Feature Not Available
8.7
128
|
Verified
7.8
9
|
Verified
8.6
119
|
Verified
Feature Not Available
Deployment
8.1
102
8.0
11
|
Verified
8.9
130
|
Verified
9.2
6
|
Verified
Performance
8.9
134
|
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
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 and Hive are categorized as Data Warehouse
Unique Categories
Amazon Redshift is categorized as Columnar Databases and Big Data Integration Platforms
Hive has no unique categories
Reviews
Reviewers' Company Size
Amazon Redshift
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Hive
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
15.5%
Computer Software
12.7%
Financial Services
7.7%
Retail
5.2%
Telecommunications
4.7%
Other
54.1%
Internet
19.3%
Computer Software
19.3%
Information Technology and Services
14.0%
Higher Education
7.0%
Retail
3.5%
Other
36.8%
Alternatives
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
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
Hive has no discussions with answers
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
