Overview
What is Apache Hive?
Apache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.
Best Distributed Database in the market
Help your dev team !
Spectacular SQL-like interface for accessing Hadoop
This system makes active data of value.
Best query platform for ETL.
It is an advance to the ease of the processes
Capabilities of Apache Hive
Excellent bigdata warehouse solution
Our use …
very useful for OLTP
Apache Hive
Walk into the World of Big Data with Apache Hive
Reliable and Cheaper one stop Data warehouse solution
Big Data the SQL way
Apache Hive: Big data querying tool w/SQL interface, but slower, more costly computation
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
What is Apache Hive?
Apache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
22 people also want pricing
Alternatives Pricing
What is ClicData?
ClicData is a 100% cloud-based business intelligence platform that allows users to connect, process, blend, visualize and share data from a single place. As an automated platform, users are able to rely on the latest version of company data, to ensure users make the right decisions. Hundreds of…
What is retailMetrix?
RetailMetrix is a data analytics platform for retailers with the mission of enabling retailers to get value from their data. RetailMatrix processes and stores sales, labor and customer data using data warehouse technologies. Its dashboards and reports allows team to find the data that matters to…
Product Demos
Apache Hive Hadoop Ecosystem - Big Data Analytics Tutorial by Mahesh Huddar
Connecting Microsoft Power BI to Apache Hive using Simba Hive ODBC driver
Discover HDP 2.1: Interactive SQL Query in Hadoop with Apache Hive
Product Details
- About
- Tech Details
- FAQs
What is Apache Hive?
Apache Hive Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(97)Attribute Ratings
Reviews
(1-25 of 32)Best Distributed Database in the market
Help your dev team !
It enables querying and analyzing large amounts of data stored in HDFS, on the petabyte scale. It has a query language called HQL that transforms SQL queries into MapReduce jobs that run on Hadoop, and it is wonderful for the devs team that love it.
Spectacular SQL-like interface for accessing Hadoop
This system makes active data of value.
- ACES (Automated Compliance and Evaluation System) Web Audit Technology, APARAVI and data intelligence & automation platform
Best query platform for ETL.
It is an advance to the ease of the processes
Capabilities of Apache Hive
Excellent bigdata warehouse solution
very useful for OLTP
Apache Hive
- Azure Synapse Analytics (Azure SQL Data Warehouse) and Databricks Lakehouse Platform (Unified Analytics Platform)
Walk into the World of Big Data with Apache Hive
Reliable and Cheaper one stop Data warehouse solution
Amazon Redshift is the another product, I used in my recent organisation.
Both Redshift and BigQuery are managed solution whereas Hive needs to be managed
Big Data the SQL way
Hive: When SQL marries with Hadoop
Manage data for your warehouse as strong as a beehive using Apache HIve!
Reliable, cheap and trustworthy!
My Apache Hive Review
Hive is solid data analytical tool
Hive - SQL-like query engine for big data platform
One of the first SQL on Hadoop tools. Perhaps not the best.
- Apache Impala, Apache Spark and PostgreSQL
Apache Hive Faster and Can handle large sets of data
- Faster response time and also can handle complex analytical queries
- Can able to write custom function using python and hive
- Able to connect using hadoop components and also using R
- Can handle different data formats
- Can use Structured Query language to access the data
Bringing Structure to your Unstructured Data
For storing bulk amount of data in a tabular manner, and where there's no need need of primary key, or just in case, if redundant data is received, it will not cause a problem. For small amounts of data, it does run MR, so beware. If your intention is to use it as a transactional records, then do not go with it. Explore other tools like Spark also as many of the features that Hive does is now supported by Spark.