Python通过thrift连接Hbase(详细配置步骤)
试验环境为Win7上用VMware搭建三个虚拟机环境,系统为Red Hat Enterprise 5.三个节点的的IP、hostname分别为:192.168.1.220 biao.oracle.com biao192.168.1.221 biao1.oracle.com biao1192.168.1.222 biao2.oracle.comb
试验环境为Win7上用VMware搭建三个虚拟机环境,系统为Red Hat Enterprise 5.
三个节点的的IP、hostname分别为:
192.168.1.220 biao.oracle.com biao
192.168.1.221 biao1.oracle.com biao1
192.168.1.222 biao2.oracle.combiao2
biao节点RAM为3GB,biao1、biao2RAM为1GB其中biao2克隆于biao1。将biao设置为master,biao1、biao2为slaves
宿主环境:
CPU:Inter(R) Core(TM) i5 M5602.67GHz
RAM:6GB
ip:192.168.1.101
jdk版本为:jdk1.6.0_29
Hadoop版本为:hadoop-0.20.2.tar.gz
Hbase版本为:hbase-0.90.5.tar.gz
thrift版本为:thrift-0.9.0.tar.gz
如果Hbase没有安装,参考:
Hbase完全分布式安装http://f.dataguru.cn/forum.php?mod=viewthread&tid=33443&fromuid=4771
如果Python没安装好,参考:
Linux下Python环境搭建
http://f.dataguru.cn/forum.php?mod=viewthread&tid=36405&fromuid=4771
Windows下Python环境搭建(包括Win764位下安装setuptools)
http://f.dataguru.cn/forum.php?mod=viewthread&tid=36396&fromuid=4771
1.下载所需文件:
thrift-0.9.0.tar.gz:http://thrift.apache.org/
2.上传文件至相应目录:
上传到hadoop用户home目录下
3.解压thrift-0.9.0.tar.gz
- [grid@biao ~]$ tar -zxf thrift-0.9.0.tar.gz

解压后目录结构:

4.配置/usr的权限控制
安装thrift 需要/usr 目录下相应的权限,否则安装会失败,如:
- /usr/bin/install: cannot create regular file `/usr/local/bin/thrift': Permission denied
- make[3]: *** [install-binPROGRAMS] Error 1
- make[3]: Leaving directory `/develop/hadoop/thrift-0.9.0/compiler/cpp'
- make[2]: *** [install-am] Error 2
- make[2]: Leaving directory `/develop/hadoop/thrift-0.9.0/compiler/cpp'
- make[1]: *** [install] Error 2
- make[1]: Leaving directory `/develop/hadoop/thrift-0.9.0/compiler/cpp'
- make: *** [install-recursive] Error 1
- [root@biao /]# chmod -R 777 /usr
5.安装thrift:
- [grid@biao thrift-0.9.0]$ ./configure
- [grid@biao thrift-0.9.0]$ make
- [grid@biao thrift-0.9.0]$ make install
- [grid@biao thrift-0.9.0]$ thrift -version
- Thrift version 0.9.0

如上一般表示安装OK 了。
6.接口文件:
- [grid@biao thrift-0.9.0]$ thrift --gen py ~/hbase-0.90.5/src/main/resources/org/apache/hadoop/hbase/thrift/Hbase.thrift

将接口文件复制到python 环境下:
- [grid@biao thrift-0.9.0]$ cp -r gen-py/hbase/ /usr/local/python2.7.3/lib/python2.7/site-packages/
7.启动集群:
启动hadoop :
- hadoop-0.20.2/bin/start-all.sh
- hbase-0.90.5/bin/start-hbase.sh



8.启动thrift服务:
- [grid@biao ~]$ hbase-0.90.5/bin/hbase thrift -p 9090 start
- [grid@biao ~]$ hbase-0.90.5/bin/hbase thrift -p 9090 start
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:zookeeper.version=3.3.2-1031432, built on 11/05/2010 05:32 GMT
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:host.name=biao.oracle.com
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:java.version=1.6.0_29
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:java.vendor=Sun Microsystems Inc.
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:java.home=/usr/local/jdk1.6.0_29/jre
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:java.class.path=/develop/hadoop/hbase-0.90.5/bin/../conf:/usr/local/jdk1.6.0_29/lib/tools.jar:/develop/hadoop/hbase-0.90.5/bin/..:/develop/hadoop/hbase-0.90.5/bin/../hbase-0.90.5.jar:/develop/hadoop/hbase-0.90.5/bin/../hbase-0.90.5-tests.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/activation-1.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/asm-3.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/avro-1.3.3.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/commons-cli-1.2.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/commons-codec-1.4.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/commons-el-1.0.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/commons-httpclient-3.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/commons-lang-2.5.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/commons-logging-1.1.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/commons-net-1.4.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/core-3.1.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/guava-r06.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/hadoop-0.20.2-core.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jackson-core-asl-1.5.5.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jackson-jaxrs-1.5.5.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jackson-mapper-asl-1.4.2.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jackson-xc-1.5.5.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jasper-compiler-5.5.23.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jasper-runtime-5.5.23.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jaxb-api-2.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jaxb-impl-2.1.12.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jersey-core-1.4.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jersey-json-1.4.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jersey-server-1.4.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jettison-1.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jetty-6.1.26.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jetty-util-6.1.26.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jruby-complete-1.6.0.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jsp-2.1-6.1.14.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jsp-api-2.1-6.1.14.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/jsr311-api-1.1.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/log4j-1.2.16.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/protobuf-java-2.3.0.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/servlet-api-2.5-6.1.14.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/slf4j-api-1.5.8.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/slf4j-log4j12-1.5.8.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/stax-api-1.0.1.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/thrift-0.2.0.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/xmlenc-0.52.jar:/develop/hadoop/hbase-0.90.5/bin/../lib/zookeeper-3.3.2.jar:/develop/hadoop/hadoop-0.20.2/conf
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:java.library.path=/usr/local/jdk1.6.0_29/jre/lib/i386/server:/usr/local/jdk1.6.0_29/jre/lib/i386:/usr/local/jdk1.6.0_29/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:java.io.tmpdir=/tmp
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:java.compiler=<NA>
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:os.name=Linux
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:os.arch=i386
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:os.version=2.6.18-128.el5
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:user.name=grid
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:user.home=/develop/hadoop
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Client environment:user.dir=/develop/hadoop
- 12/12/11 19:23:40 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=biao2:2181,biao1:2181,biao:2181 sessionTimeout=180000 watcher=hconnection
- 12/12/11 19:23:41 INFO zookeeper.ClientCnxn: Opening socket connection to server biao1/192.168.1.221:2181
- 12/12/11 19:23:41 INFO zookeeper.ClientCnxn: Socket connection established to biao1/192.168.1.221:2181, initiating session
- 12/12/11 19:23:41 INFO zookeeper.ClientCnxn: Session establishment complete on server biao1/192.168.1.221:2181, sessionid = 0x13b89b2eb220000, negotiated timeout = 180000
- 12/12/11 19:23:44 INFO ThriftServer: starting HBase ThreadPool Thrift server on /0.0.0.0:9090
9.登陆hbase shell并创建测试数据:
创建两张表:
- [grid@biao ~]$ hbase-0.90.5/bin/hbase shell
- HBase Shell; enter 'help<RETURN>' for list of supported commands.
- Type "exit<RETURN>" to leave the HBase Shell
- Version 0.90.5, r1212209, Fri Dec 9 05:40:36 UTC 2011
- hbase(main):001:0> create 'test_thrift','info'
- 0 row(s) in 5.3770 seconds
- hbase(main):002:0> create 'test_thrift2','info'
- 0 row(s) in 1.5680 seconds
- hbase(main):003:0> list
- TABLE
- test_thrift
- test_thrift2
- 2 row(s) in 0.1020 seconds
- hbase(main):004:0>

10.测试
编写python 文件: 复制以下代码保存为test.py 。 注意: 如果环境不支持中文,把中文注释删了。 如果出现ImportError: No module named hbase 之类的错误,表示python 找不到所需要的模块。最大的可能是所需的的模块没有安装在python 的site-packages 目录下。确保site-packages 目录中包含了hbase 模块和thrift 模块,如果缺少thrift 模块的话,可以使用easy_install 快速安装。
可以参考
Linux 下Python 环境搭建http://f.dataguru.cn/forum.php?mod=viewthread&tid=36405&fromuid=4771
Windows 下Python 环境搭建(包括Win764 位下安装setuptools )http://f.dataguru.cn/forum.php?mod=viewthread&tid=36396&fromuid=4771

- import sys
- #Hbase.thrift生成的py文件放在这里
- sys.path.append('/usr/local/python2.7.3/lib/python2.7/site-packages/hbase')
- from thrift import Thrift
- from thrift.transport import TSocket
- from thrift.transport import TTransport
- from thrift.protocol import TBinaryProtocol
- from hbase import Hbase
- #如ColumnDescriptor 等在hbase.ttypes中定义
- from hbase.ttypes import *
- # Make socket
- #此处可以修改地址和端口
- transport = TSocket.TSocket('192.168.1.220', 9090)
- # Buffering is critical. Raw sockets are very slow
- # 还可以用TFramedTransport,也是高效传输方式
- transport = TTransport.TBufferedTransport(transport)
- # Wrap in a protocol
- #传输协议和传输过程是分离的,可以支持多协议
- protocol = TBinaryProtocol.TBinaryProtocol(transport)
- #客户端代表一个用户
- client = Hbase.Client(protocol)
- #打开连接
- transport.open()
- #打印表名
- print(client.getTableNames())
运行

运行结果正确。
至此,Python通过thrift连接Hbase成功!
更多推荐










所有评论(0)