Pro Apache Phoenix: An SQL Driver for HBase

Leverage Phoenix as an ANSI SQL engine built on top of the highly distributed and scalable NoSQL framework HBase. Learn the basics and best practices that are being adopted in Phoenix to enable a high write and read throughput in a big data space.

This book includes real-world cases such as Internet of Things devices that send continuous streams to Phoenix, and the book explains how key features such as joins, indexes, transactions, and functions help you understand the simple, flexible, and powerful API that Phoenix provides. Examples are provided using real-time data and data-driven businesses that show you how to collect, analyze, and act in seconds.

Pro Apache Phoenix covers the nuances of setting up a distributed HBase cluster with Phoenix libraries, running performance benchmarks, configuring parameters for production scenarios, and viewing the results. The book also shows how Phoenix plays well with other key frameworks in the Hadoop ecosystem such as Apache Spark, Pig, Flume, and Sqoop.

You will learn how to

• Handle a petabyte data store by applying familiar SQL techniques
• Store, analyze, and manipulate data in a NoSQL Hadoop echo system with HBase
• Apply best practices while working with a scalable data store on Hadoop and HBase
• Integrate popular frameworks (Apache Spark, Pig, Flume) to simplify big data analysis
• Demonstrate real-time use cases and big data modeling techniques

Who This Book Is For

Data engineers, Big Data administrators, and architects.

Table of Contents

Chapter 1: Introduction
Chapter 2: Using Phoenix
Chapter 3: CRUD with Phoenix
Chapter 4: Querying Data
Chapter 5: Advanced Querying
Chapter 6: Transactions
Chapter 7: Advanced Phoenix Concepts
Chapter 8: Integrating Phoenix with Other Frameworks
Chapter 9: Tools & Tuning