HIVE and HBASE

Overview

Hive and HBase are distributed databases from Apache and included in Cloudera CDH that are highly scalable and designed to manage huge amounts of structured data.

Course Objective

Skills learned on the course include: The use cases and usage occasions for HBase, Hadoop, and RDBMS Using the HBase shell to directly manipulate HBase tables Designing optimal HBase schemas for efficient data storage and recovery How to connect to HBase using the Java API, configure the HBase cluster, and administer an HBase cluster Best practices for identifying and resolving performance bottlenecks.

Who Should Attend

• Big Data Developer / Administrator / Architect / Analyst / Engineer
• Software Architect / Engineer/Developer
• Solution Delivery Consultant
• Senior BI / ETL Developer
• NoSQL Big Data Developer.

Prerequisites

Knowledge of Linux command line is preferred. Exposure to Java, Database or Data Warehouse concepts is a plus.
Analyzing Data with MS Excel

Training Calendar

Intake

Duration

Program Fees

Inquire further

2 Days

Contact us to find out more

Module


• What Is Big Data?
• Introducing Hadoop
• Hadoop Components
• What Is HBase?
• Why Use HBase?
• Strengths of HBase
• HBase in Production
• Weaknesses of HBase


• HBase Concepts
• HBase Table Fundamentals
• Thinking About Table Design


• Creating Tables with the HBase Shell
• Working with Tables
• Working with Table Data


• HBase Regions
• HBase Cluster Architecture
• HBase and HDFS Data Locality


• General Design Considerations
• Application-Centric Design
• Designing HBase Row Keys
• Other HBase Table Features


• Options to Access HBase Data
• Creating and Deleting HBase Tables
• Retrieving Data with Get
• Retrieving Data with Scan
• Inserting and Updating Data
• Deleting Data


• Filtering Scans
• Best Practices
• HBase Coprocessors


• How HBase Uses HDFS
• Compactions and Splits


• How HBase Writes Data
• How HBase Reads Data
• Block Caches for Reading


• Column Family Considerations
• Schema Design Considerations
• Configuring for Caching
• Dealing with Time Series and Sequential Data
• Pre-Splitting Regions


• HBase Daemons
• ZooKeeper Considerations
• HBase High Availability
• Using the HBase Balancer
• Fixing Tables with hbck
• HBase Security


• HBase Replication
• HBase Backup
• MapReduce and HBase Clusters


• Using Hive and Impala with HBase

FAQs

Q: What is the HIVE and HBASE course about?
This 2-day course introduces participants to Apache Hive and HBase, distributed databases designed to manage large amounts of structured data. Participants will explore the use cases for HBase, Hadoop, and RDBMS, and gain hands-on experience with HBase shell commands, schema design, Java API connections, and HBase cluster administration. The course also covers best practices for performance optimization.

Q: Who should attend this course?

  • Big Data Developer / Administrator / Architect / Analyst / Engineer

  • Software Architect / Engineer / Developer

  • Solution Delivery Consultant

  • Senior BI / ETL Developer

  • NoSQL Big Data Developer

Q: What are the prerequisites for this course?
Knowledge of the Linux command line is preferred. Exposure to Java, database, or data warehouse concepts is a plus.

Q: How long is the course?
The course spans 2 days.

Q: What key topics are covered in this course?

  • Introduction to Hadoop and HBase

  • HBase table fundamentals and design considerations

  • The HBase shell for creating and managing tables

  • HBase cluster architecture and data locality

  • HBase schema design and row key considerations

  • Accessing data with the HBase API

  • Advanced HBase API features like filtering scans and coprocessors

  • Performance tuning and schema design considerations

  • HBase administration, high availability, and security

  • Using Hive and Impala with HBase

Q: Will I receive a certification after completing the course?
Yes, participants will receive a certificate of completion, recognizing their skills in using HBase and Hive effectively.

Q: What foundational HBase and Hive concepts will I learn in this course?
You’ll explore the core principles of HBase and Hive, understanding how they manage large-scale structured data. Key topics include HBase tables, schema design, the HBase API, HBase cluster architecture, and how to integrate Hive with HBase for big data solutions.

Q: How does the course help me apply HBase and Hive to real-world data problems?
You’ll work with real-world datasets to design optimal HBase schemas, efficiently store and retrieve data, and integrate Hive queries with HBase for analysis. This practical approach equips you to handle big data challenges in various industries such as retail, healthcare, and finance.

Q: What skills will I develop in managing and optimizing HBase clusters?
You’ll learn to administer and tune HBase clusters for performance, including schema design considerations, caching configurations, and pre-splitting regions. You’ll also master best practices for troubleshooting performance bottlenecks and improving read/write efficiency in HBase.

Q: Will I learn how to handle different types of data in HBase?
Yes. The course covers working with both structured and time-series data in HBase, with hands-on exercises in data access, retrieval, and storage optimization to address different data types and use cases.

Q: How does this course prepare me for applying HBase and Hive in a professional context?
You’ll gain technical knowledge and practical skills to integrate HBase and Hive into big data applications, optimize performance, and leverage them for business solutions such as data analysis, real-time reporting, and automated decision-making in industries like e-commerce, finance, and healthcare.

Submit your interest today !

Contact us