# Hive vs SQL Server 2019 Comparison | | Hive | SQL Server 2019 | |---|---|---| | **Star Rating** | 4.2 out of 5 | 4.5 out of 5 | | **Total Reviews** | 60 | 83 | | **Largest Market Segment** | Enterprise (54.4% of reviews) | Mid-Market (36.4% of reviews) | | **Entry Level Price** | No pricing available | No pricing available | --- ## Top Pros & Cons ### Hive **Not enough data** ### SQL Server 2019 Pros: - Data Integration (1 reviews) - SQL Support (1 reviews) Cons: - Expensive (1 reviews) --- ## Ratings Comparison | Rating | Hive | SQL Server 2019 | |---|---|---| | **Meets Requirements** | 8.2 (52 reviews) | 9.0 (54 reviews) | | **Ease of Use** | 8.4 (52 reviews) | 9.0 (54 reviews) | | **Ease of Setup** | 7.8 (20 reviews) | 8.4 (22 reviews) | | **Ease of Admin** | 7.5 (19 reviews) | 8.3 (18 reviews) | | **Quality of Support** | 7.7 (46 reviews) | 8.8 (48 reviews) | | **Has the product been a good partner in doing business?** | 8.2 (16 reviews) | 8.3 (17 reviews) | | **Product Direction (% positive)** | 7.6 (48 reviews) | 9.3 (49 reviews) | --- ## Pricing ### Hive #### Entry-Level Pricing No pricing available #### Free Trial No information available ### SQL Server 2019 #### Entry-Level Pricing No pricing available #### Free Trial No information available --- ## Features Comparison By Category ### Data Warehouse | Product | Score | Reviews | |---|---|---| | **Hive** | 8.3/10 | 12 | | **SQL Server 2019** | 8.5/10 | 37 | #### Data Management | Feature | Hive | SQL Server 2019 | |---|---|---| | **Data Integration** | 9.2 (10 reviews) ✓ Verified | 9.1 (33 reviews) ✓ Verified | | **Data Compression** | 8.0 (11 reviews) ✓ Verified | 8.8 (30 reviews) ✓ Verified | | **Data Quality** | 8.2 (11 reviews) ✓ Verified | 8.9 (31 reviews) ✓ Verified | | **Built-In Data Analytics** | 8.3 (11 reviews) ✓ Verified | 8.4 (27 reviews) ✓ Verified | | **In-Database Machine Learning** | 7.1 (8 reviews) ✓ Verified | 7.8 (19 reviews) ✓ Verified | | **Data Lake Analytics** | 8.1 (9 reviews) ✓ Verified | 8.4 (19 reviews) ✓ Verified | #### Integration | Feature | Hive | SQL Server 2019 | |---|---|---| | **AI/ ML Integration** | Feature Not Available | 7.9 (20 reviews) ✓ Verified | | **BI Tool Integration** | 7.8 (9 reviews) ✓ Verified | 8.2 (25 reviews) ✓ Verified | | **Data lake Integration** | Feature Not Available | 8.2 (21 reviews) ✓ Verified | #### Deployment | Feature | Hive | SQL Server 2019 | |---|---|---| | **On-Premise** | 8.0 (11 reviews) ✓ Verified | 8.8 (26 reviews) ✓ Verified | | **Cloud** | 9.2 (6 reviews) ✓ Verified | 8.2 (29 reviews) ✓ Verified | #### Performance | Feature | Hive | SQL Server 2019 | |---|---|---| | **Scalability** | 7.9 (11 reviews) ✓ Verified | 8.8 (32 reviews) ✓ Verified | #### Security | Feature | Hive | SQL Server 2019 | |---|---|---| | **Data Governance** | 9.0 (10 reviews) ✓ Verified | 8.5 (31 reviews) ✓ Verified | | **Data Security** | 8.8 (11 reviews) ✓ Verified | 9.0 (27 reviews) ✓ Verified | #### Generative AI | Feature | Hive | SQL Server 2019 | |---|---|---| | **AI Text Generation** | Not enough data | Not enough data | | **AI Text Summarization** | Not enough data | Not enough data | --- ## Categories **Shared Categories (1):** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) --- ## Reviewer Demographics ### By Company Size | Segment | Hive | SQL Server 2019 | |---|---|---| | **Small-Business** | 10.5% | 31.2% | | **Mid-Market** | 35.1% | 36.4% | | **Enterprise** | 54.4% | 32.5% | ### By Industry #### Hive - **Computer Software:** 19.3% - **Internet:** 19.3% - **Information Technology and Services:** 14.0% - **Higher Education:** 7.0% - **Retail:** 3.5% - **Food & Beverages:** 3.5% - **Accounting:** 1.8% - **Apparel & Fashion:** 1.8% - **Banking:** 1.8% - **Computer & Network Security:** 1.8% - **Other:** 26.3% #### SQL Server 2019 - **Computer Software:** 28.2% - **Information Technology and Services:** 17.9% - **Banking:** 6.4% - **Financial Services:** 5.1% - **Computer & Network Security:** 3.8% - **Insurance:** 3.8% - **Construction:** 3.8% - **Accounting:** 2.6% - **Internet:** 2.6% - **Architecture & Planning:** 1.3% - **Other:** 24.4% --- ## Alternatives ### Alternatives to Hive - [Snowflake](https://www.g2.com/products/snowflake/reviews) — 4.5/5 stars (754 reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) — 4.5/5 stars (1225 reviews) - [Teradata Autonomous Knowledge Platform](https://www.g2.com/products/teradata-autonomous-knowledge-platform/reviews) — 4.3/5 stars (375 reviews) - [Oracle Exadata Cloud Service](https://www.g2.com/products/oracle-exadata-cloud-service/reviews) — 4.4/5 stars (44 reviews) - [OpenText Vertica](https://www.g2.com/products/opentext-vertica/reviews) — 4.3/5 stars (216 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) — 4.3/5 stars (402 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) — 4.1/5 stars (682 reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) — 4.6/5 stars (804 reviews) - [Dremio](https://www.g2.com/products/dremio/reviews) — 4.6/5 stars (70 reviews) - [VMware Greenplum](https://www.g2.com/products/vmware-greenplum/reviews) — 4.3/5 stars (61 reviews) ### Alternatives to SQL Server 2019 - [Databricks](https://www.g2.com/products/databricks/reviews) — 4.6/5 stars (804 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) — 4.5/5 stars (754 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) — 4.3/5 stars (402 reviews) - [Oracle Exadata Cloud Service](https://www.g2.com/products/oracle-exadata-cloud-service/reviews) — 4.4/5 stars (44 reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) — 4.5/5 stars (1225 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) — 4.1/5 stars (682 reviews) - [IBM Netezza Performance Server](https://www.g2.com/products/ibm-netezza-performance-server/reviews) — 4.1/5 stars (84 reviews) - [SAP BW/4HANA](https://www.g2.com/products/sap-bw-4hana/reviews) — 4.0/5 stars (19 reviews) - [Teradata Autonomous Knowledge Platform](https://www.g2.com/products/teradata-autonomous-knowledge-platform/reviews) — 4.3/5 stars (375 reviews) - [OpenText Vertica](https://www.g2.com/products/opentext-vertica/reviews) — 4.3/5 stars (216 reviews) --- ## Top Discussions ### Hive No discussions available for this product. ### SQL Server 2019 - Title: [What is SQL Server 2019 used for?](https://www.g2.com/discussions/what-is-sql-server-2019-used-for) — 1 comment > **Top comment:** "SQL Server 2019 is a popular relational database management system (RDBMS) developed by Microsoft. It is primarily used for managing and storing data in a..." --- **Source:** [G2.com](https://www.g2.com) | [Comparison Page](https://www.g2.com/compare/hive-vs-sql-server-2019)