Apache Phoenix Over HBase

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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

HadoopTpoint © 2017 Frontier Theme