Hbase query engine-Use of Phoenix

Description: The Phoenix query engine converts an SQL query to one or more hbase scans and orchestrates the execution to generate a standard JDBC result set. Using hbase APIs, coprocessor, and custom filters directly, the performance of a simple query is millisecond. For millions of rows, the performance is second. More reference Official Website: http://phoenix.apache.org/

Command Line: sqlline installation:

1, SetPhoenix-3.0.0-incubating.tar.gzInstallLinuxLower

2, SetPhoenix-3.0.0-incubating \ common \ phoenix-core-3.0.0-incubating.jarPackageCopyToHbaseClusterLibMedium

3RestartHbase

4,Start sqlline: Enter/Home/hadoop/APP/Phoenix-3.0.0-incubating/binDirectory, run:Sqlline. py [zookeeper]

For example, sqlline. py datanode1: 2181

Note: [zookeeper] indicates the address of the zookeeper server.

 

Client: squirrelsql.Install

1. Download

Http://www.squirrelsql.org/

2. Installation Process

Click to install

3. JarPackage supplement, the followingJarAddSquirrelInstallation Directory/Lib

Note:HbaseRelated package fromHbase-0.94.6-cdh4.3.0/libYou can get it.HbaseVersion:Hbase-0.94.6-cdh4.3.0,

PhoenixTwo related packages fromPhoenix-3.0.0-incubating \ commonYou can get it.PhoenixVersion:Phoenix-3.0.0-incubating,

Can be downloaded fromHttp://phoenix.apache.org/download.html#SQL-Client

4. Configure the driver and runSquirrel, ClickDrivers

Click AddDriverIn the left-side navigation pane.OK

5. Configure the connection and click Add.Alias

Note: MyHbase zookeepererConfiguration

6. connection. The page is displayed.

Hbase query engine-Use of Phoenix