Use of the HBase query engine--phoenix

Description: The Phoenix query engine translates SQL queries into one or more hbase scan and orchestrates execution to produce a standard JDBC result set. Directly using the HBase API, the co-processor and the custom filter, the performance magnitude is milliseconds for simple queries, and the performance magnitude is seconds for millions. More Reference website: http://phoenix.apache.org/
command line: Sqlline installation:

1. Install phoenix-3.0.0-incubating.tar.gz to Linux

2. Copy the Phoenix-3.0.0-incubating\common\phoenix-core-3.0.0-incubating.jar package to the HBase cluster Lib

3. Restart HBase

4. Start sqlline: Enter/home/hadoop/app/phoenix-3.0.0-incubating/bin directory, run: sqlline.py [zookeeper]

For example: sqlline.py datanode1:2181

Note: [zookeeper] refers to zookeeper server address

client: squirrelsql. Install

1. Download

http://www.squirrelsql.org/

2, installation, process slightly

Click to install

3, jar package supplement, need to add the following jar to the Squirrel installation directory/lib

Description: HBase-related packages are available from hbase-0.94.6-cdh4.3.0/lib and I use the hbase version of hbase-0.94.6-cdh4.3.0,

Phoenix Two related packages can be obtained from Phoenix-3.0.0-incubating\common, I use the Phoenix version of Phoenix-3.0.0-incubating,

You can download http://phoenix.apache.org/download.html#SQL-Client from

4, configuration drive, run squirrel, click Drivers

Click Add Driver, follow the steps to fill out the error, and finally click OK

5., configure the connection, click Add Alias

Remarks: My hbase zookeeperer configuration

6, connect, you can see the following image page