作业题目:

E843B1A09BC1ACEF32F6DEFB29A8CCFA.png

创建表,shell命令如下

  1. create 'student','info1','info2'
  2. put 'student','1001','info1:name','zhangsan'
  3. put 'student','1001','info1:sex','female'
  4. put 'student','1001','info1:age','20'
  5. put 'student','1001','info2:phone','123123123'
  6. put 'student','1001','info2:add','luoyang'
  7. put 'student','1002','info1:name','lisi'
  8. put 'student','1002','info1:sex','male'
  9. put 'student','1002','info1:age','21'
  10. put 'student','1002','info2:phone','123123124'
  11. put 'student','1002','info2:add','zhengzhou'
  12. put 'student','1003','info1:name','wangwu'
  13. put 'student','1003','info1:sex','male'
  14. put 'student','1003','info1:age','19'
  15. put 'student','1003','info2:phone','123123125'
  16. put 'student','1003','info2:add','xuchang'

操作

1. 获取student表中1001同学的姓名

get 'student','1001','info1:name'

image.png

2.将1002同学的姓名修改为“lisili”

put 'student','1002','info1:name','lisili'

image.png

3. 将student表info1列族修改为5个版本

alter 'student',NAME=>'info1',VERSION=>5

image.png

4. 扫描表中所有的数据

scan 'student'

image.png

5. 获取1003同学前面所有同学的信息(不包括1003)

scan 'student',{STARTROW=>'1001',STOPROW=>'1003'}
或者
scan 'student',{STOPROW=>'1003'}

image.png
或者
image.png

6. 删除1003同学add列数据

delete 'student','1003','info2:add'

image.png
image.png

7. 获取student表多个版本的数据,可以查看到修改表和删除的学生的信息

scan 'student',{RAW=>true,VERSIONS=>5}
#解释,RAW=true表示返回已经删除的数据

image.png
image.png