常用的HBASE操作----(一)---shell

    技术2022-07-15  38

    一、目的

    理解HBase在Hadoop体系结构中的角色,熟练使用HBase操作常用的Shell命令,熟悉HBase操作常用的Java API。

    二、设备

    计算机:CPU四核i7 6700处理器;内存8G; SATA硬盘2TB硬盘; Intel芯片主板;集成声卡、千兆网卡、显卡; 20寸液晶显示器。 编译环境:(1)操作系统:Linux (2)Hadoop版本:2.7.2 机器:虚拟机3台 (3)HBase版本:1.6.0(4)Eclipse 4.7

    三、内容

    3.1依次启动zookeeper、hdfs、hbase

    3.2进入hbase1.2.6,启动 ./bin/hbase shell,建表,插数据。

    cd /opt/module/hbase-1.2.6/ cd bin Hbase shell hbase(main):004:0> create 'student','info' 0 row(s) in 2.8580 seconds => Hbase::Table - student hbase(main):005:0> put'student','1001','info:sex','male' 0 row(s) in 0.2920 seconds hbase(main):002:0> put 'student','1001','info:age','18' 0 row(s) in 0.6410 seconds hbase(main):003:0> put'student','1002','info:name','Janna' 0 row(s) in 0.0210 seconds hbase(main):004:0> put'student','1002','info:sex','female' 0 row(s) in 0.0840 seconds hbase(main):005:0> put 'student','1002','info:age','20' 0 row(s) in 0.0830 seconds

    3.3列出表相关信息–list

    hbase(main):008:0> list

    3.4终端打印指定的表的记录数据-scan

    hbase(main):006:0> scan 'student'

    3.5向已经创建好的表添加和删除指定的列族或列;

    hbase(main):030:0> alter 'student',NAME => 'hobby' hbase(main):031:0> desc 'student'

    hbase(main):032:0> alter 'student',NAME => 'hobby',METHOD => 'delete'

    hbase(main):009:0> put 'student','1001','info:name','hfl'

    hbase(main):011:0> deleteall 'student','1001'

    hbase(main):013:0> delete 'student','1002','info:age'

    3.6清空指定的表的所有记录数据-truncate

    hbase(main):021:0> truncate 'student' hbase(main):022:0> scan 'student'

    hbase(main):035:0> disable 'student' hbase(main):036:0> drop 'student'

    3.7统计表的行数-count

    hbase(main):016:0> count 'student' 1 row(s) in 0.0700 seconds

    Processed: 0.011, SQL: 9