Skip to main content
  • Book
  • © 2017

Pro Apache Phoenix

An SQL Driver for HBase

Apress
  • Democratization of data with a quick and simpler SQL language to data stored in HBase

  • Deep insights into data modeling for storing and querying data in the NoSQL data store HBase

  • Best practices to be followed to build a scalable data store on Hadoop and HBase

  • Integration with other BI tools

Buy it now

Buying options

eBook USD 19.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 29.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (9 chapters)

  1. Front Matter

    Pages i-xv
  2. Introduction

    • Shakil Akhtar, Ravi Magham
    Pages 1-14
  3. Using Phoenix

    • Shakil Akhtar, Ravi Magham
    Pages 15-35
  4. CRUD with Phoenix

    • Shakil Akhtar, Ravi Magham
    Pages 37-49
  5. Querying Data

    • Shakil Akhtar, Ravi Magham
    Pages 51-61
  6. Advanced Querying

    • Shakil Akhtar, Ravi Magham
    Pages 63-77
  7. Transactions

    • Shakil Akhtar, Ravi Magham
    Pages 79-90
  8. Advanced Phoenix Concepts

    • Shakil Akhtar, Ravi Magham
    Pages 91-109
  9. Integrating Phoenix with Other Frameworks

    • Shakil Akhtar, Ravi Magham
    Pages 111-122
  10. Tools & Tuning

    • Shakil Akhtar, Ravi Magham
    Pages 123-135
  11. Back Matter

    Pages 137-140

About this book

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.







Authors and Affiliations

  • Bangalore, India

    Shakil Akhtar

  • Santa Clara, USA

    Ravi Magham

About the authors

Shakil Akhtar is TOGAF 9 Certified Enterprise Architect passionate about Digital Transformation, Cloud Computing, Big Data and Internet of Things technologies. He holds many certifications including Oracle Certified Master Java Enterprise Architect (OCMJEA). He worked with Cisco, Oracle, CA Technologies and various other organizations. Where he developed and architected large-scale complex enterprise software, creating frameworks and scaling systems to petabyte datasets. He is an enthusiastic open source user and longtime fan. When not working, he can be found playing guitar and doing some jamming sessions with his friends.

Ravi Mugham, an engineer passionate about data and data-driven engineering, experienced with working and scaling solutions to petabyte datasets. In his past experience, he has worked with CA Technologies, Bazaarvoice and various other startups. Actively involved in open source projects and is a PMC member to Apache Phoenix. Currently, his interests are in Distributed Data stream processing

Bibliographic Information

  • Book Title: Pro Apache Phoenix

  • Book Subtitle: An SQL Driver for HBase

  • Authors: Shakil Akhtar, Ravi Magham

  • DOI: https://doi.org/10.1007/978-1-4842-2370-3

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books

  • Copyright Information: Shakil Akhtar and Ravi Magham 2017

  • Softcover ISBN: 978-1-4842-2369-7Published: 30 December 2016

  • eBook ISBN: 978-1-4842-2370-3Published: 29 December 2016

  • Edition Number: 1

  • Number of Pages: XV, 140

  • Number of Illustrations: 13 b/w illustrations, 95 illustrations in colour

  • Topics: Open Source

Buy it now

Buying options

eBook USD 19.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 29.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access