Apache Phoenix Tutorial : SQL on HBase

[DataDotz DataDotz]

Hi Team,

What is Apache Phoenix?

Apache phoenix is another Top Level project from Apache Software Foundation. It provides an SQL interface to HBase. It is like an SQL layer on top of HBase architecture. It maps HBase data model to the relational world.

Phoenix is developed in java with a notion to put SQL back into NoSQL databases.

Need for Apache Phoenix:

Hive is added into Hadoop Eco-system to maintain and manage structured data in Hadoop and it also provide an SQL like dialect HiveQL to query the tables in Hive data warehouse. But hive doesn’t provide record level operations such as insert, update and delete operations.

To overcome this drawback of hive, HBase is brought into Hadoop eco-system to support record level operations. But HBase shell supports only HBase commands such as ‘scan’, ‘get’, ‘put’, ‘list’ to query entire table, to get a row, put a row and for listing tables etc. respectively. Thus HBase introduced its own set of commands and doesn’t support famous SQL interface. 

More Info  : - http://datadotz.com/apache-phoenix-tutorial-sql-on-hbase/

--

Thanks & regards

Saravanakumar

Data Engineer 

C

ontact:9095260692

www.linkedin.com/in/saravanasaro

http://chennaihug.org/knowledgebase/

 

--

-- --

Regards 

DATADOTZ Team
https://www.linkedin.com/in/datadotz
https://www.linkedin.com/in/senthilka
https://www.facebook.com/datadotz

http://datadotz.com/blog/