Hbase中常用命令用法

来源：互联网发布：ubuntu无法读取源列表编辑：程序博客网时间：2024/06/08 10:20

1.查询表数据记录条数

count 'tableName' , 例如: count 'opoms_order',统计opoms_order表中记录总条数

2.删除表记录

truncate 'tableName', 例如: truncate 'opoms_order' 就是删除opoms_order表中所有记录

3.插入数据

put 'tableName', 'rowKey', 'columnName','columnValue'

例如:

put 'opoms_order_router', '18547215000_8521510140000361_0','storage:shipping_sn','997581267124'

4.浏览(扫描)表

II, scan 'tableNAME', {columns=> ['column1', 'c2'], LIMIT => 10, STARTROW => 'xyz'}

例如[按时间戳方式扫描，查找指定时间段内的数据记录]:

scan 'opoms_order_router', {COLUMNS => ['infor:order_sn', 'infor:order_belong'], LIMIT => 10, STARTROW => '18551061772_9201512010000056'}

III, 待过滤器的方式扫描表

scan 'tableNAME', {columns=> ['column1', 'c2'], LIMIT => 10, STARTROW => 'xyz',FILTER => "(PrefixFilter ('row2')"}

例如:[可以用来查找指定列是否存在表中]

scan 'opoms_order_router', {COLUMNS => ['infor:order_sn', 'infor:order_belong'], LIMIT => 10, STARTROW => '18552253959_8201511170033562',FILTER => "(PrefixFilter ('18552253959_8201511170033562'))"}

0 0