© Shakil Akhtar and Ravi Magham 2017

Shakil Akhtar and Ravi Magham, Pro Apache Phoenix, 10.1007/978-1-4842-2370-3_5

5. Advanced Querying

Shakil Akhtar and Ravi Magham2

(1)Bangalore, Karnataka, India

(2)Santa Clara, California, USA

Chapter 4 discussed more on generic querying where only one table is involved. We saw how to restrict values using constraints, a go through on table concepts and use of operators in phoenix query language. In chapter 5, we will look into more advanced querying like SQL joins, filters on the result set using subqueries and working with multiple tables. Let’s see how these advanced concepts work and their use in phoenix.

5.1 Joins

In general querying, we saw how to work with single table. Now let’s explore how to work with ...

Get Pro Apache Phoenix: An SQL Driver for HBase, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.