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

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