O'Reilly logo

Pro Apache Phoenix: An SQL Driver for HBase, First Edition by Ravi Magham, Shakil Akhtar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required