Amazon Redshift
6.6#9 in data warehouse softwareFrom $0.54 a monthWebAPI
VisitAmazon Redshift vs Apache Hive
Apache Hive
7.4#3 in query engine softwareFree planFree planAPILinuxmacOSSelf-hosted
VisitWhat both publish
| Fact | Amazon Redshift | Apache Hive |
|---|---|---|
| Deployment | It offers provisioned and serverless deployment options. | The official quickstart provides Docker instructions for running HiveServer2 and the Metastore in a container. |
| Security | Redshift supports encryption in transit and at rest, row- and column-level access controls, and dynamic data masking. | The site describes Kerberos authentication, fine-grained access control, and audit logging; HiveServer2 documentation also lists LDAP, PAM, and custom authentication options. |
Amazon Redshift plans
- Provisioned$0.54 a month
- Serverless$1.50 a month
- Provisioned on-demand$0.54 a month
- Redshift Serverless on-demand$1.50 a month
Apache Hive plans
- Apache HiveFree
Pick Amazon Redshift if…
Redshift suits teams running SQL analytics, dashboards, application development, data sharing, and ETL jobs. It may also suit organizations that need data lake queries, streaming ingestion, or separate storage and compute.
Pick Apache Hive if…
Hive suits teams managing large datasets with SQL that need a data warehouse with distributed storage and integrations. Its documentation lists Linux for production use and Mac for development, with Windows also among the listed platforms.