Python通过Thrift插入Hbase实验

43tfwed

#python
from thrift import Thrift
from thrift.transport import TSocket
from thrift.transport import TTransport
from thrift.protocol import TBinaryProtocol
from hbase import Hbase
from hbase.ttypes import *
transport = TSocket.TSocket('192.168.137.101',9090)
transport = TTransport.TBufferedTransport(transport)
protocol = TBinaryProtocol.TBinaryProtocol(transport)
client = Hbase.Client(protocol)
transport.open()
mutations = [Mutation(column="tuser:b",value="1")]
#client.mutateRow('ttable0','rowkey1', mutations, None)
for l1 in range(10):
for l2 in range(10):
for l3 in range(10):
for l4 in range(10):
client.mutateRow('ttable0','%d'%l1+'%d'%l2+'%d'%l3+'%d'%l4, mutations, None)
print 'finished'


4台centos虚拟机
2.2Ghz CPU × 1
1.5GB内存
共享单硬盘
插入1000条用时93秒，平均一秒插入107条
复制0.py为1.py, 2.py ……8.py
开启9个进程分别插入ttable0, ttable1, ttable2 ……ttable8
其它条件不变，总共用时约220秒，平均一秒插入409条