Apache Phoenix 4.8.1 + HBase 1.2.3 整合

步骤如下：

1. 下载Phoenix 4.8.1：

https://mirrors.tuna.tsinghua.edu.cn/apache/phoenix/apache-phoenix-4.8.1-HBase-1.2/bin/

2. 解压后，配置环境变量。

3. 拷贝根目录下phoenix-4.8.1-HBase-1.2-server.jar文件到$HBASE_HOME/lib目录下，然后重启hbase

4. 运行如下命令：

sqlline.py 127.0.0.1    // 127.0.0.1 是zookeeper的地址

Bins-MacBook-Pro:~ bin.shen$ sqlline.py 127.0.0.1

Setting property: [incremental, false]

Setting property: [isolation, TRANSACTION_READ_COMMITTED]

issuing: !connect jdbc:phoenix:127.0.0.1 none none org.apache.phoenix.jdbc.PhoenixDriver

Connecting to jdbc:phoenix:127.0.0.1

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/Users/bin.shen/BigData/phoenix-4.8.1/phoenix-4.8.1-HBase-1.2-client.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/Users/bin.shen/BigData/hadoop-2.7.3/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

16/10/28 16:43:56 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

Connected to: Phoenix (version 4.8)

Driver: PhoenixEmbeddedDriver (version 4.8)

Autocommit status: true

Transaction isolation: TRANSACTION_READ_COMMITTED

Building list of tables and columns for tab-completion (set fastconnect to true to skip)...

86/86 (100%) Done

Done

sqlline version 1.1.9

0: jdbc:phoenix:127.0.0.1> !table

+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+---+

| TABLE_CAT  |TABLE_SCHEM  |TABLE_NAME  |  TABLE_TYPE   |REMARKS  |TYPE_NAME  |SELF_REFERENCING_COL_NAME  |REF_GENERATION  | INDEX_STATE  |IMMUTABLE_ROWS  |SALT_BUCKETS  |MULTI_TENANT  |V |

+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+---+

|            |SYSTEM       |CATALOG     |SYSTEM TABLE  |          |            |                            |                 |              |false           |null          |false         |  |

|            |SYSTEM       |FUNCTION    |SYSTEM TABLE  |          |            |                            |                 |              |false           |null          |false         |  |

|            |SYSTEM       |SEQUENCE    |SYSTEM TABLE  |          |            |                            |                 |              |false           |null          |false         |  |

|            |SYSTEM       |STATS       |SYSTEM TABLE  |          |            |                            |                 |              |false           |null          |false         |  |

+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+---+

0: jdbc:phoenix:127.0.0.1> 

参考资料: http://blog.csdn.net/dingyuanpu/article/details/52618172