Data Access

Cloudera Data Platform Runtime includes Apache Hive 3 and Apache Impala for storing and accessing data in the Hive metastore database. Hive 3 addresses enterprise data warehouse demands for transactional data in the ORC file format. Impala performs high-performance, low-latency SQL queries on data in Parquet and other formats. Hue is a web-based interactive editor for querying the Hive metastore that also creates Oozie workflows. DAS is a web application for performing operations on Hive tables and also provides recommendations for optimizing the performance of your queries.

Using Data Analytics Studio
Describes how to work with queries, manage databases and tables, and generate reports.
Starting Apache Hive
Describes how to launch Hive, execute Hive commands, and issue Hive queries from Beeline.
Using Hive
Covers how to use Hive 3 to query flat and transactional data using SQL statements.
Managing Apache Hive
Includes information about mature ACID v2 operations on transactions.
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 set up Hive to generate statistics and control the number of concurrent connections to Hive.
Configuring Apache Hive Metastore
Covers how to configure Hive metastore (HMS) to access metadata of multiple services, such as Hive, Impala, and Spark.
Securing Apache Hive
Discusses how to choose an authorization model based on how your organization uses Hive.
Integrating Apache Hive with Apache Spark and BI
Covers accessing Spark data to and from Hive and using the JdbcStorageHandler to access an external data source, such as Business Intelligence (BI) tools.
Migrating Data to Apache Hive
Explains how to move data from relational databases directly to Hive or to the file system or object store and how to move data back to Hive.
Integrating with Apache Impala
Provides examples on how to use Impala to insert, query, update, and delete data from Kudu tablets using Impala's SQL syntax.
Managing Apache Impala
Presents the task topics for configuring and managing Impala.
Using Hue
Describes how to use Hue to query Apache Impala data sets and how to use it to browse metadata in Apache Atlas.
Administering Hue
Describes how to configure Hue, customize its web UI, and to enable integration with Apache Atlas.
Securing Hue
Describes how to set Hue user and application permissions, configure SSL connections, LDAP authentication, and integration with Apache Ranger and Knox.
Tuning Hue
Describes how to add a load balancer and configure high availability for Hue and between Hue and other components, such as Hive, Impala, and HDFS.