Compare - Hive VS Redshift

Here’s the difference between Hive and Redshift. The comparison is based on pricing, deployment, business model, and other important factors.

About Hive

The Apache Hive ™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive.

About Redshift

Amazon Redshift is a fully managed petabyte scale data warehouse service. Redshift is designed for analytic workloads and connects to standard SQL based clients and business intelligence tools. Redshift delivers fast query and I/O performance for virtually any size dataset by using columnar storage technology and parallelizing and distributing queries across multiple nodes. Most common administrative tasks associated with provisioning, configuring, monitoring, backing up, and securing a data warehouse are automated.

Comparison Table

Overview
CategoriesData WarehousesData Warehouses
StageLate StageLate Stage
Target SegmentMid Size, EnterpriseEnterprise
DeploymentOn PremSaaS
Business ModelOpen SourceCommercial
PricingFreemiumFreemium
LocationUSSeattle,WA, US
Companies using it
QuintoAndar logoCircleUp logoInfoPrice logo
Zoom logoInstacart logoShopify logoHomeToGo logoAXS logoClearcover logoMattermost logoStriim logoProposify logo1mg logoHotjar logoToo Good To Go logoFOX logoUproad logoAngellist Talent logoCraft logoFanatics Inc logoinstamojo logoinvision logoJobber logoJMAN Group logoDecisionTree Analytics logoDecisionTree Analytics and Services logoDecisionTree Analytics & Services logocoral logozippi logoMatillion logoDashlane logoAstrato Analytics logo
Contact info
twitter icon
linkedin icon
twitter icon

Add to compare

Similar Companies
Databricks logo
Databricks
Data Warehouses, Data Lakes
Oracle
Data Warehouses
Dremio
Data Warehouses, Data Lakes
SAP business warehouse
Data Warehouses