步骤如下:
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