phoenixを使ってhbase(四)を操作します.

環境:Hadoop-2.5.1 hbase-1.1.2 phoenix-4.10.0  jdk 1.8 x 64
ダウンロードphoenix:http://archive.apache.org/dist/phoenix/apache-phoenix-4.10.0-HBase-1.1/bin/apache-phoenix-4.10.0-HBase-1.1-bin.tar.gz
phoenixディレクトリを作成します.mkdir/home/hadoop/phoenix-4
公式アーカイブからwgetを取得します.http://archive.apache.org/dist/phoenix/apache-phoenix-4.10.0-HBase-1.1/bin/apache-phoenix-4.10.0-HBase-1.1-bin.tar.gz
ストレス解消:tar xvzf apache-phoenix-4.10-HBase-1.1-bin.tar.gz
連続してjarをhbaseのlibディレクトリにコピーします.cp phoenix-coree-4.10-HBase-11.jar/home/hbase/hbase-1.12/lib/cp phoenix-42.10-HBase-1.1-client.jar/home/hbase/hbase/hbase-1.1.2/lib/lib
再起動hbase有効:hbase-1.1.2/bin/stop-hbase-51.2/bin/start-hbase.shはphoenixコマンドラインに入ります.インタラクティブ操作bin/sqlline.py 作成表:create table user(idvarhar(50)not priverica.harcury.テーブルはシステムのテーブルを見ます.

0: jdbc:phoenix:localhost:2181:/hbase> !tables
+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+---+
| TABLE_CAT  | TABLE_SCHEM  | TABLE_NAME  |  TABLE_TYPE   | REMARKS  | TYPE_NAME  | SELF_REFERENCING_COL_NAME  | REF_GENERATION  | I |
+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+---+
|            | SYSTEM       | CATALOG     | SYSTEM TABLE  |          |            |                            |                 |   |
|            | SYSTEM       | FUNCTION    | SYSTEM TABLE  |          |            |                            |                 |   |
|            | SYSTEM       | SEQUENCE    | SYSTEM TABLE  |          |            |                            |                 |   |
|            | SYSTEM       | STATS       | SYSTEM TABLE  |          |            |                            |                 |   |
|            |              | USER        | TABLE         |          |            |                            |                 |   |
+------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+---+
0: jdbc:phoenix:localhost:2181:/hbase> select * from user;
+-----+-------+-------+
| ID  | NAME  | ADDR  |
+-----+-------+-------+
+-----+-------+-------+
No rows selected (0.044 seconds)

データを挿入: (挿入はinsertではなく、アップセットです)

0: jdbc:phoenix:localhost:2181:/hbase> upsert into user (id,name,addr) values ('1','lisa','china');
1 row affected (0.011 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> select* from user;
+-----+-------+--------+
| ID  | NAME  |  ADDR  |
+-----+-------+--------+
| 1   | lisa  | china  |
+-----+-------+--------+
1 row selected (0.044 seconds)
0: jdbc:phoenix:localhost:2181:/hbase>