© Shakil Akhtar and Ravi Magham 2017

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

3. CRUD with Phoenix

Shakil Akhtar and Ravi Magham2

(1)Bangalore, Karnataka, India

(2)Santa Clara, California, USA

Now that we have installed Phoenix and HBase, let’s get started with performing the basic operations of CREATE, UPDATE, DELETE and SELECT using SQL. Let’s also take a dive into the data types and perform CRUD operations from the “Sqlline” CLI available in Phoenix.

3.1 Data Types in Phoenix

Unlike HBase which is data-type agnostic, Phoenix provides a set of data types that specify the type of data that the column holds. Each data type is internally mapped to a corresponding data type of either Java or SQL. There are Unsigned ...

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.