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

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.