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_4

4. Querying Data

Shakil Akhtar and Ravi Magham2

(1)Bangalore, Karnataka, India

(2)Santa Clara, California, USA

In the previous chapter, we discussed basic Phoenix commands for CRUD operations. In this chapter we will be digging deep into working with tables (creating, altering, and dropping tables), Phoenix available clauses (LIMIT, WHERE, GROUP BY, HAVING, and ORDER BY), data constraints (NOT NULL) and conditional operators (AND, OR, IN, LIKE, and BETWEEN) for data retrieval.

4.1 Constraints

Constraints are rules applied on the values, structure or result set. You can enforce constraints on columns and tables, such as PRIMARY KEY, ...

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