2023学年完整公开课版hbase项目实战3

hbase项目实战2hbase项目实战3hbase项目实战在HbaseShell中创建表xiandian，向表xiandian中插入一组数据为xiandian，row1，info：name，xiaoming，插入后查询表xiandian中rowkey为row1的记录hbase(main):020:0>create'xiandian','info'0row(s)in2.2750seconds=>Hbase::Table-xiandianhbase(main):021:0>put'xiandian','row1','info:name','xiaoming'0row(s)in0.3210secondshbase(main):022:0>scan'xiandian'ROWCOLUMN+CELLrow1column=info:name,timestamp=1538309976013,value=xiaoming1row(s)in0.0270seconds4hbase项目实战在HbaseShell中创建表xiandian，向表xiandian中插入一组数据为xiandian，row1，info：name，xiaoming，插入后查询表xiandian中rowkey为row1的记录hbase(main):023:0>listTABLExiandian1row(s)in0.0070seconds=>["xiandian"]hbase(main):024:0>get'xiandian','row1'COLUMNCELLinfo:nametimestamp=1538309976013,value=xiaoming1row(s)in0.0280seconds5hbase项目实战在HbaseShell中创建表xiandian，列族为“info”然后查询表中所有的记录hbase(main):027:0>drop'xiandian'0row(s)in1.4290secondshbase(main):028:0>create'xiandian','info'0row(s)in1.2450seconds=>Hbase::Table-xiandianhbase(main):029:0>scan'xiandian'ROWCOLUMN+CELL0row(s)in0.0120seconds6hbase项目实战登录hbase数据库，使用命令创建一张表，列族为member_id'，'address'，'info'，创建完毕后查看该表的详细信息，后来发现列族'member_id'这个列族是多余的，需要删除，使用命令将该列族删除并查看详细信息，最后查看该表是否是enabled的hbase(main):030:0>create'test1','member_id','address','info'0row(s)in2.2580seconds=>Hbase::Table-test1hbase(main):049:0>desc'test1'Tabletest1isENABLEDtest1COLUMNFAMILIESDESCRIPTION{NAME=>'address',BLOOMFILTER=>'ROW',VERSIONS=>'1',IN_MEMORY=>'false',KEEP_DELETED_CELLS=>'FALSE',DATA_BLOCK_ENCODING=>'NONE',TTL=>'FOREVER',COMPRESSION=>'NONE',MIN_VERSIONS=>'0',BLOCKCACHE=>'true',BLOCKSIZE=>'65536',REPLICATION_SCOPE=>'0'}7hbase项目实战{NAME=>'info',BLOOMFILTER=>'ROW',VERSIONS=>'1',IN_MEMORY=>'false',KEEP_DELETED_CELLS=>'FALSE',DATA_BLOCK_ENCODING=>'NONE',TTL=>'FOREVER',COMPRESSION=>'NONE',MIN_VERSIONS=>'0',BLOCKCACHE=>'true',BLOCKSIZE=>'65536',REPLICATION_SCOPE=>'0'}{NAME=>'member_id',BLOOMFILTER=>'ROW',VERSIONS=>'1',IN_MEMORY=>'false',KEEP_DELETED_CELLS=>'FALSE',DATA_BLOCK_ENCODING=>'NONE',TTL=>'FOREVER',COMPRESSION=>'NONE',MIN_VERSIONS=>'0',BLOCKCACHE=>'true',BLOCKSIZE=>'65536',REPLICATION_SCOPE=>'0'}3row(s)in0.0260seconds8hbase项目实战hbase(main):050:0>alter'test1',{NAME=>'member_id',METHOD=>'delete'}Updatingallregionswiththenewschema...1/1regionsupdated.Done.0row(s)in3.3720secondshbase(main):051:0>desc'test1'Tabletest1isENABLEDtest1COLUMNFAMILIESDESCRIPTION{NAME=>'address',BLOOMFILTER=>'ROW',VERSIONS=>'1',IN_MEMORY=>'false',KEEP_DELETED_CELLS=>'FALSE',DATA_B9hbase项目实战LOCK_ENCODING=>'NONE',TTL=>'FOREVER',COMPRESSION=>'NONE',MIN_VERSIONS=>'0',BLOCKCACHE=>'true',BLOCKSIZE=>'65536',REPLICATION_SCOPE=>'0'}{NAME=>'info',BLOOMFILTER=>'ROW',VERSIONS=>'1',IN_MEMORY=>'false',KEEP_DELETED_CELLS=>'FALSE',DATA_BLOCK_ENCODING=>'NONE',TTL=>'FOREVER',COMPRESSION=>'NONE',MIN_VERSIONS=>'0',BLOCKCACHE=>'true',BLOCKSIZE=>'65536',REPLICATION_SCOPE=>'0'}2row(s)in0.0150secondshbase(main):029:0>is_enabled'test1'true10hbase项目实战登录hbase数据库，新建一张表，列族为'address'，'info'，创建完之后，向该表插入数据，插入之后查询这条信息，并修改信息，改完后，查询修改前和修改后的信息hbase(main):022:0>create'test3','address','info'0row(s)in2.2790seconds=>Hbase::Table-test3hbase(main):023:0>put'test3','row1','address','jn'0row(s)in0.0130secondshbase(main):025:0>scan'test3'ROWCOLUMN+CELLrow1column=address:,timestamp=1538313318391,value=jn1row(s)in0.0130secondshbase(main):026:0>put'test3','row1','address','hz'0row(s)in0.0270secondshbase(main):0