Apache Hive
5.0 out of 5 starsAverage Ratings 1 Rating
Average Ratings 0 Ratings
Description
Apache Hive is a data warehouse solution that enables the efficient reading, writing, and management of substantial datasets stored across distributed systems using SQL. It allows users to apply structure to pre-existing data in storage. To facilitate user access, it comes equipped with a command line interface and a JDBC driver. As an open-source initiative, Apache Hive is maintained by dedicated volunteers at the Apache Software Foundation. Initially part of the Apache® Hadoop® ecosystem, it has since evolved into an independent top-level project. We invite you to explore the project further and share your knowledge to enhance its development. Users typically implement traditional SQL queries through the MapReduce Java API, which can complicate the execution of SQL applications on distributed data. However, Hive simplifies this process by offering a SQL abstraction that allows for the integration of SQL-like queries, known as HiveQL, into the underlying Java framework, eliminating the need to delve into the complexities of the low-level Java API. This makes working with large datasets more accessible and efficient for developers.
Description
Embedded Data Virtualization allows you to extend your applications with unified data connectivity. CData Query Federation Drivers are a universal data access layer that makes it easier to develop applications and access data. Through a single interface, you can write SQL and access data from 250+ applications and databases. The CData Query Federation Driver provides powerful tools such as: * A Single SQL Language and API: A common SQL interface to work with multiple SaaS and NoSQL, relational, or Big Data sources. * Combined Data Across Resources: Create queries that combine data from multiple sources without the need to perform ETL or any other data movement. * Intelligent Push-Down - Federated queries use intelligent push-down to improve performance and throughput. * 250+ Supported Connections: Plug-and–Play CData Drivers allow connectivity to more than 250 enterprise information sources.
API Access
Has API
No
API Access
Has API
Yes
Integrations
3forge
Yes
Airtool
Yes
Apache Doris
Yes
Apache Phoenix
Yes
Baidu Sugar
Yes
Chat2DB
Yes
Data Sentinel
Yes
DataClarity Unlimited Analytics
Yes
Datalogz
Yes
DbVisualizer
Yes
Integrations
3forge
No
Airtool
No
Apache Doris
No
Apache Phoenix
No
Baidu Sugar
No
Chat2DB
No
Data Sentinel
No
DataClarity Unlimited Analytics
No
Datalogz
No
DbVisualizer
No
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Pricing Details
No price information available.
Free Trial
Yes
Free Version
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Vendor Details
Company Name
Apache Software Foundation
Founded
1999
Country
United States
Website
hive.apache.org
Vendor Details
Company Name
CData Software
Founded
2014
Country
United States
Website
www.cdata.com/queryfederation/
Product Features
ETL
Data Analysis
No
Data Filtering
No
Data Quality Control
No
Job Scheduling
No
Match & Merge
No
Metadata Management
No
Non-Relational Transformations
No
Version Control
No
Product Features
Data Management
Customer Data
No
Data Analysis
No
Data Capture
Yes
Data Integration
No
Data Migration
No
Data Quality Control
No
Data Security
No
Information Governance
No
Master Data Management
No
Match & Merge
No