phoenix 3.1 + hbase 0.94.21 的安装和使用
来源:互联网 发布:苹果电脑软件后缀 编辑:程序博客网 时间:2024/06/11 23:43
Apache Phoenix 是 HBase 的 SQL 驱动。Phoenix 使得 HBase 支持通过 JDBC 的方式进行访问,并将你的 SQL 查询转成 HBase 的扫描和相应的动作。
兼容性:
Phoenix 2.x - HBase 0.94.x
Phoenix 3.x - HBase 0.94.x
Phoenix 4.x - HBase 0.98.1+
1:hbase 0.94.21 的安装
参考http://blog.csdn.net/wind520/article/details/38614315
2:下载phoenix 3.1
[jifeng@jifeng02 ~]# wget http://mirrors.hust.edu.cn/apache/phoenix/phoenix-3.1.0/bin/phoenix-3.1.0-bin.tar.gz--2014-09-12 22:03:44-- http://mirrors.hust.edu.cn/apache/phoenix/phoenix-3.1.0/bin/phoenix-3.1.0-bin.tar.gz正在解析主机 mirrors.hust.edu.cn... 202.114.18.160正在连接 mirrors.hust.edu.cn|202.114.18.160|:80... 已连接。已发出 HTTP 请求,正在等待回应... 200 OK长度:55480477 (53M) [application/octet-stream]正在保存至: “phoenix-3.1.0-bin.tar.gz”2014-09-12 22:16:29 (70.8 KB/s) - 已保存 “phoenix-3.1.0-bin.tar.gz” [55480477/55480477])
3:解压
[jifeng@jifeng02 ~]$ tar zxf phoenix-3.1.0-bin.tar.gz [jifeng@jifeng02 ~]$ cd phoenix-3.1.0-bin[jifeng@jifeng02 phoenix-3.1.0-bin]$ lsCHANGES common examples hadoop1 hadoop2 LICENSE NOTICE README
4:配置
参考:http://phoenix.apache.org/download.html
我这里使用的是Phoenix 3.x
To install a pre-built phoenix, use these directions:
- Download and expand the latest phoenix-[version]-bin.tar. Use either hadoop1 and hadoop2 artifacts which match your HBase installation.
- 下载,根据安装的HBase选择hadoop1或hadoop2
- Add the phoenix-[version]-server.jar to the classpath of every HBase region server and remove any previous version. An easy way to do this is to copy it into the HBase lib directory (use phoenix-core-[version].jar for Phoenix 3.x)
- 把phoenix-core-3.1.0.jar复制到所有HBase region server的lib目录
- Restart all region servers.
- 重启所有的Hbase region servers.
- Add the phoenix-[version]-client.jar to the classpath of any Phoenix client.
- Phoenix client服务器的CLASSPATH加上phoenix-3.1.0-client-hadoop1.jar
[jifeng@jifeng02 phoenix-3.1.0-bin]$ cd common[jifeng@jifeng02 common]$ lsphoenix-3.1.0-client-minimal.jar phoenix-3.1.0-client-without-hbase.jar phoenix-core-3.1.0.jar[jifeng@jifeng02 common]$ cp ./phoenix-core-3.1.0.jar /home/jifeng/hbase-0.94.21/lib[jifeng@jifeng02 common]$ scp ./phoenix-core-3.1.0.jar jifeng@jifeng01:/home/jifeng/hbase-0.94.21/libphoenix-core-3.1.0.jar 100% 2178KB 2.1MB/s 00:00 [jifeng@jifeng02 common]$ cd ..
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:/home/jifeng/phoenix-3.1.0-bin/hadoop1/phoenix-3.1.0-client-hadoop1.jar
然后重启HBase
[jifeng@jifeng01 hbase-0.94.21]$ bin/stop-hbase.shstopping hbase................jifeng01: stopping zookeeper.jifeng02: stopping zookeeper.[jifeng@jifeng01 hbase-0.94.21]$ bin/start-hbase.shjifeng01: starting zookeeper, logging to /home/jifeng/hbase-0.94.21/bin/../logs/hbase-jifeng-zookeeper-jifeng01.outjifeng02: starting zookeeper, logging to /home/jifeng/hbase-0.94.21/bin/../logs/hbase-jifeng-zookeeper-jifeng02.outstarting master, logging to /home/jifeng/hbase-0.94.21/logs/hbase-jifeng-master-jifeng01.outjifeng01: starting regionserver, logging to /home/jifeng/hbase-0.94.21/bin/../logs/hbase-jifeng-regionserver-jifeng01.outjifeng02: starting regionserver, logging to /home/jifeng/hbase-0.94.21/bin/../logs/hbase-jifeng-regionserver-jifeng02.out
5:启动和简单操作
[jifeng@jifeng02 bin]$ sqlline.py localhostSetting property: [isolation, TRANSACTION_READ_COMMITTED]issuing: !connect jdbc:phoenix:localhost none none org.apache.phoenix.jdbc.PhoenixDriverConnecting to jdbc:phoenix:localhostConnected to: Phoenix (version 3.1)Driver: org.apache.phoenix.jdbc.PhoenixDriver (version 3.1)Autocommit status: trueTransaction isolation: TRANSACTION_READ_COMMITTEDBuilding list of tables and columns for tab-completion (set fastconnect to true to skip)...59/59 (100%) DoneDonesqlline version 1.1.20: jdbc:phoenix:localhost> select * from b_month. . . . . . . . . . . . .> ;Error: ERROR 1012 (42M03): Table undefined. tableName=B_MONTH (state=42M03,code=1012)0: jdbc:phoenix:localhost> create table test (a integer primary key, b integer) ;No rows affected (1.534 seconds)0: jdbc:phoenix:localhost> UPSERT INTO TEST VALUES (1, 1);1 row affected (0.018 seconds)0: jdbc:phoenix:localhost> UPSERT INTO TEST VALUES (2, 12);1 row affected (0.01 seconds)0: jdbc:phoenix:localhost> select * from test;+------------+------------+| A | B |+------------+------------+| 1 | 1 || 2 | 12 |+------------+------------+2 rows selected (0.056 seconds)0: jdbc:phoenix:localhost>
[jifeng@jifeng01 hbase-0.94.21]$ hbase shellHBase Shell; enter 'help<RETURN>' for list of supported commands.Type "exit<RETURN>" to leave the HBase ShellVersion 0.94.21, r83b4a1ee9b9a2fa4c7ae1739259e041cabe8edc2, Fri Jun 27 16:14:16 UTC 2014hbase(main):001:0> listTABLE SYSTEM.CATALOG SYSTEM.SEQUENCE TEST b_month mytable 5 row(s) in 0.6250 secondshbase(main):003:0> scan 'TEST'ROW COLUMN+CELL \x80\x00\x00\x01 column=0:B, timestamp=1410534991931, value=\x80\x00\x00\x01 \x80\x00\x00\x01 column=0:_0, timestamp=1410534991931, value= \x80\x00\x00\x02 column=0:B, timestamp=1410535001115, value=\x80\x00\x00\x0C \x80\x00\x00\x02 column=0:_0, timestamp=1410535001115, value= 2 row(s) in 0.0770 secondshbase(main):004:0>
0 0
- phoenix 3.1 + hbase 0.94.21 的安装和使用
- phoenix 3.1 + hbase 0.94.21 的安装和使用
- 【HBase】HBase上安装使用Phoenix来用sql语句更新操作数据,安装的过程各种坑和经验
- HBase和Phoenix的整合
- HBase + Phoenix 安装试用
- Phoenix+HBase使用心得
- Phoenix+HBase使用心得
- 使用Phoenix连接Hbase
- hbase使用Phoenix
- Phoenix和Hbase整合
- Phoenix安装使用及使用 SQuirrel客户端连接操作Hbase
- HBase-0.98.0和Phoenix-4.0.0分布式安装指南
- HBase-0.98.0和Phoenix-4.0.0分布式安装指南
- HBase-1.2.1和Phoenix-4.7.0分布式安装指南
- phoenix hbase 安装 eclipse 测试
- hadoop+hbase+zookeeper+phoenix安装
- CDH5.8 HBase安装Phoenix
- CDH5.8 HBase安装Phoenix
- log4j详细使用方法
- 什么是线程池
- 查找和二叉排序树
- Linux动态库(一)之同名符号
- Java对象的序列化与反序列化
- phoenix 3.1 + hbase 0.94.21 的安装和使用
- 将一个win32程序改成动态DLL
- 字符串的查找算法
- HTTP POST上传文件代码实现
- x的n次方求解 与 优化
- TCP/IP协议介绍之工作原理
- 程序员们 不要想一辈子靠技术混饭吃
- atitit.web 推送实现方案集合(2)---百度云,jpush 极光推送 ,个推的选型比较.o99
- Linux网络编程之socket:使用fork并发处理多个client的请求和对等通信P2P