Data Access Documentation

Starting Apache Hive

Describes how to launch Hive, execute Hive commands, and issue Hive queries from Beeline

Using Apache Hive

Covers how to use Hive 3 revised semantics for querying flat and transactional data using SQL

Managing Apache Hive

Includes information about mature ACID v2 operations on transactions introduced in HDP 3.0

Managing Apache Hive Workloads

Summarizes and describes how to improve parallel query execution and share queries in a cluster that supports low-latency analytical processing (LLAP)

Configuring Apache Hive

Describes how to control the number of concurrent connections and parameters required by Hive 3

Securing Apache Hive

Covers security of low latency analytical processing (LLAP) operations and how to secure data using the storage-based authorization (SBA) model, table access limitations, light-weight directory access protocol (LDAP)

Integrating Apache Hive with Kafka, Spark, and BI

Covers accessing data in Kafka from Hive, accessing Spark data to and from Hive, using the JdbcStorageHandler to access an external data source, such as Business Intelligence (BI) tools, and setting up Superset for visualizing Hive data

Migrating Data

Explains how to move data from relational databases directly to Hive or to HDFS and how to move data from HDFS to Hive

Apache Hive Performance Tuning

Describes how you can tune the data warehouse infrastructure, interdependent components, and your client connection parameters to improve performance

Accessing Data Using Apache Druid

Introduces Apache Druid (incubating) capabilities and architecture, and explains the basics of setting up and using Druid

Using Apache Druid and Apache Hive

Discusses using Apache Druid (incubating) and Hive in tandem to index data from Hive into Druid and to query Druid from Hive

Using HBase to Store and Access Data

Describes HBase installation methods, cluster management details, backup and restore strategy, medium object (MOB) storage support, quota management details, and other best practices

Using Phoenix to Store and Access Data

Describes information about interoperability with HBase, user defined functions (UDFs), mapping Phoenix schemas to HBase namespaces, Phoenix connectors, indexes, and the Phoenix repair tool

Accessing Cloud Data

Provides the steps required for configuring access to data stored in Amazon S3, ADLS, WASB, and Google Cloud Storage, and for accessing that data