Data Access

Also available as:

PDF

Contents

Hortonworks Data Platform

Data Access

Copyright © 2012-2016 Hortonworks, Inc.

Except where otherwise noted, this document is licensed under Creative Commons Attribution ShareAlike 4.0 License

http://creativecommons.org/licenses/by-sa/4.0/legalcode

The Hortonworks Data Platform, powered by Apache Hadoop, is a massively scalable and 100% open source platform for storing, processing and analyzing large volumes of data. It is designed to deal with data from many sources and formats in a very quick, easy and cost-effective manner. The Hortonworks Data Platform consists of the essential set of Apache Hadoop projects including YARN, Hadoop Distributed File System (HDFS), HCatalog, Pig, Hive, HBase, ZooKeeper and Ambari. Hortonworks is the major contributor of code and patches to many of these projects. These projects have been integrated and tested as part of the Hortonworks Data Platform release process and installation and configuration tools have also been included.

Unlike other providers of platforms built using Apache Hadoop, Hortonworks contributes 100% of our code back to the Apache Software Foundation. The Hortonworks Data Platform is Apache-licensed and completely open source. We sell only expert technical support, training and partner-enablement services. All of our technology is, and will remain, free and open source.

Please visit the Hortonworks Data Platform page for more information on Hortonworks technology. For more information on Hortonworks services, please visit either the Support or Training page. Feel free to Contact Us directly to discuss your specific needs.

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

Troubleshooting

JIRAs

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

List of Figures

2.1. Example: Moving .CSV Data into Hive
2.2. Using Sqoop to Move Data into Hive
2.3. Data Ingestion Lifecycle
2.4. Dataset after the UNION ALL Command Is Run
2.5. Dataset in the View
5.1. HBase Read/Write Operations
5.2. Relationship among Different BlockCache Implementations and MemStore
5.3. Diagram of Configuring BucketCache
5.4. Intracluster Backup
5.5. Backup-Dedicated HDFS Cluster
5.6. Backup to Vendor Storage Solutions
5.7. Tables Composing the Backup Set

List of Tables

2.1. Hive Content roadmap
2.2. CBO Configuration Parameters
2.3. Configuration Parameters for Standard SQL Authorization
2.4. HiveServer2 Command-Line Options
2.5. Hive Compaction Types
2.6. Hive Transaction Configuration Parameters
2.7. Trailing Whitespace Characters on Various Databases
2.8. Beeline Modes of Operation
2.9. HiveServer2 Transport Modes
2.10. Authentication Schemes with TCP Transport Mode
2.11. Most Common Methods to Move Data into Hive
2.12. Sqoop Command Options for Importing Data into Hive
5.1. HBase Content Roadmap in Other Sources
5.2. MOB Cache Properties

List of Examples

5.1. Simple Example of Namespace Usage