hbase基础语句练习

创建表

创建一张表：person，有两个列簇（student，teacher）
第一个列簇的版本保留三份，第二个两份。

create 'person',{NAME=>'student',VERSIONS=>3},{NAME=>'teacher',VERSIONS=>2}

put数据：笨拙的方法

插入10行数据姓名，性别，年龄，成绩；姓名，所教科目等等。

# 学生姓名
put 'person','1001','student:name','xiao1'
put 'person','1002','student:name','xiao2'
put 'person','1003','student:name','xiao3'
put 'person','1004','student:name','xiao4'
put 'person','1005','student:name','xiao5'
put 'person','1006','student:name','xiao6'
put 'person','1007','student:name','xiao7'
put 'person','1008','student:name','xiao8'
put 'person','1009','student:name','xiao9'
put 'person','1010','student:name','xiao10'

# 学生性别 1代表男，0代表女
put 'person','1001','student:sex','0'
put 'person','1002','student:sex','1'
put 'person','1003','student:sex','0'
put 'person','1004','student:sex','0'
put 'person','1005','student:sex','0'
put 'person','1006','student:sex','1'
put 'person','1007','student:sex','1'
put 'person','1008','student:sex','0'
put 'person','1009','student:sex','1'
put 'person','1010','student:sex','0'

# 学生年龄
put 'person','1001','student:age','12'
put 'person','1002','student:age','13'
put 'person','1003','student:age','12'
put 'person','1004','student:age','11'
put 'person','1005','student:age','14'
put 'person','1006','student:age','12'
put 'person','1007','student:age','14'
put 'person','1008','student:age','12'
put 'person','1009','student:age','13'
put 'person','1010','student:age','12'

# 学生成绩
put 'person','1001','student:grade','89'
put 'person','1002','student:grade','78'
put 'person','1003','student:grade','97'
put 'person','1004','student:grade','95'
put 'person','1005','student:grade','64'
put 'person','1006','student:grade','78'
put 'person','1007','student:grade','79'
put 'person','1008','student:grade','86'
put 'person','1009','student:grade','87'
put 'person','1010','student:grade','89'

# 老师姓名
put 'person','1001','teacher:name','lao1'
put 'person','1002','teacher:name','lao2'
put 'person','1003','teacher:name','lao3'
put 'person','1004','teacher:name','lao4'
put 'person','1005','teacher:name','lao5'
put 'person','1006','teacher:name','lao6'
put 'person','1007','teacher:name','lao7'
put 'person','1008','teacher:name','lao8'
put 'person','1009','teacher:name','lao9'
put 'person','1010','teacher:name','lao10'

# 老师姓名
put 'person','1001','teacher:subject','math'
put 'person','1002','teacher:subject','english'
put 'person','1003','teacher:subject','chinese'
put 'person','1004','teacher:subject','chinese'
put 'person','1005','teacher:subject','art'
put 'person','1006','teacher:subject','art'
put 'person','1007','teacher:subject','chinese'
put 'person','1008','teacher:subject','math'
put 'person','1009','teacher:subject','math'
put 'person','1010','teacher:subject','english'

查看数据

# 查看第4行到第8行全部内容
# STARTROW是包括当前行数
# STOPROW是不包括当前行数
scan 'person',{STARTROW=>'1004',STOPROW=>'1009'}

# 查看第10行全部内容
# STOPROW可以是10也可以是11
scan 'person',{STARTROW=>'1010',STOPROW=>'1010'}

# 查看第7行数据的学生列簇的姓名。
scan 'person',{STARTROW=>'1007',STOPROW=>'1007',COLUMNS=>'student:name'}

删除表

# 删除变先将表变为disable状态
# 查看变是否为disable
is_disabled 'person'

# 显示false，则运行以下命令将其变成disable状态
disable 'person'

# 然后就能删除了
drop 'person'