Data Access
Also available as:
loading table of contents...


1. What's New
Apache Hive
Apache HBase
Apache Phoenix
Content Updates
2. Data Warehousing with Apache Hive
Content Roadmap
Features Overview
Temporary Tables
Optimized Row Columnar (ORC) Format
SQL Optimization
SQL Compliance
Streaming Data Ingestion
Query Vectorization
Beeline versus Hive CLI
Hive JDBC and ODBC Drivers
Moving Data into Apache Hive
Using an External Table
Using Sqoop
Incrementally Updating a Table
Enabling security through Row-Level Filtering and Column Masking
Configuring HiveServer2
Configuring HiveServer2 for Transactions (ACID Support)
Configuring HiveServer2 for LDAP and for LDAP over SSL
Managing and Using Hive
Configuring SQL Standard-based Authorization
Required Privileges for Hive Operations
Configuring SQL Standard-Based Authorization
Storage-Based Authorization
Configuring Storage-based Authorization
Configuring authorization for Apache Hive using Apache Ranger
Permissions for Apache Hive Operations
3. Enabling Efficient Execution with Apache Pig and Apache Tez
4. Managing Metadata Services with Apache HCatalog
HCatalog Community Information
WebHCat Community Information
Security for WebHCat
5. Persistent Read/Write Data Access with Apache HBase
Content Roadmap
Deploying Apache HBase
Installation and Setup
Cluster Capacity and Region Sizing
Enabling Multitenancy with Namepaces
Security Features Available in Technical Preview
Managing Apache HBase Clusters
Monitoring Apache HBase Clusters
Optimizing Apache HBase I/O
Importing Data into HBase with Bulk Load
Using Snapshots
Backing up and Restoring Apache HBase Datasets
Planning a Backup-and-Restore Strategy for Your Environment
Best Practices for Backup-and-Restore
Running the Backup-and-Restore Utility
Medium Object (MOB) Storage Support in Apache HBase
Enabling MOB Storage Support
Testing the MOB Storage Support Configuration
Tuning MOB Storage Cache Properties
6. Orchestrating SQL and APIs with Apache Phoenix
Enabling Phoenix and Interdependent Components
Thin Client Connectivity with Phoenix Query Server
Securing Authentication on the Phoenix Query Server
Selecting and Obtaining a Client Driver
Mapping Phoenix Schemas to HBase Namespaces
Enabling Namespace Mapping
Creating New Schemas and Tables with Namespace Mapping
Associating Tables of a Schema to a Namespace