1、通过hbase shell的scan命令可以查看表中的所有数据,命令如下:
scan 'tablename'
查看emp中所有数据:
scan 'emp'
2、通过python thrift API扫描表数据,代码如下:
# coding=utf-8
from thrift.transport.TSocket import TSocket
from thrift.transport.TTransport import TBufferedTransport
from thrift.protocol import TBinaryProtocol
from hbase import Hbase
from hbase.ttypes import *
# 主机地址及端口号,端口号默认为9090
host = '192.168.83.135'
port = 9090
# 初始化链接
transport = TBufferedTransport(TSocket(host, port))
transport.open()
protocol = TBinaryProtocol.TBinaryProtocol(transport)
# 创建客户端
client = Hbase.Client(protocol)
scanid = client.scannerOpen('empbypy','1',['personal data'])
print client.scannerGet(scanid)
client.scannerClose(scanid)
scanid = client.scannerOpen('empbypy','1',['personal data:name'])
print client.scannerGet(scanid)
client.scannerClose(scanid)
scanid = client.scannerOpen('empbypy','1',['personal data','professional data'])
print client.scannerGet(scanid)
print client.scannerGetList(scanid,2) # 获取当前行之后的N行
client.scannerClose(scanid)
transport.close()
transport.close()
代码运行结果如下: