Apache Phoenix Over HBase

Our HadoopTpoint App is now available in google play store,please rate and comment it in play store : W3Schools

Apache Phoenix Over HBase

 

Apache Phoenix is a SQL skin over HBase delivered as a client-embedded JDBC driver targeting low latency queries over HBase data(Apache Phoenix Over HBase). Apache Phoenix takes your SQL query, compiles it into a series of HBase scans, and orchestrates the running of those scans to produce regular JDBC result sets. The table metadata is stored in an HBase table and versioned, such that snapshot queries over prior versions will automatically use the correct schema.

Apache Phoenix Installation on Ubuntu:

1)Download phoenix-3.0.0-incubating.tar.gz from http://www.apache.org/dyn/closer.cgi/phoenix/
2)unzipped the downloaded Phoenix package
3)Go to phoenix folder and then open common folder in that we have to find a jars,select phoenix-3.0.0-incubating-client-minimal,phoenix-core-3.0.0-incubating jars
4)copy above two jars and paste into hbase/lib

 

Steps for creating table and insert values into given table:

1)create sql command should be writes in filename.sql

 

2)csv file

 

3)run below command

 

4)Finally connect to sqlline and hbase

connect to sqlline

 

 

 

connect to hbase

 

 JDBC driver program for Apache Phoenix

Speak Your Mind

*