首先虚拟机要安装好hbase环境,其次主机要能ping通虚拟机否则会报错
txt文件如下
hbase表结构如下,列簇info下还会有多行列
插入数据的代码如下,txt文件要在py文件的同级目录下。首先要创建一个hbase表,需要注意的是txt文件有几列,hbase对应也要有几列
import pandas as pd
import matplotlib.pyplot as plt
import happybase
connect=happybase.Connection(host='10.101.1.28',port=9090)
connect.open();
def createtable(connect):
table = happybase.Table("h6WBNR", connect)
families = {
"info": dict(),
}
connect.create_table("h6WBNR", families)
file_name = 'WBNR.txt'
columns = [
'info:SEQ',
'info:hotel',
'info:countr