Hbase查询[转]

shell命令
查看所有表
list
查看某个表结构
desc 'lf:lf_t_result_room_online_min_user_stat'
添加数据
put 'lf:lf_t_result_room_online_min_user_stat' ,'rowkey1111','room','111'
扫描全表
scan 'lf:lf_t_result_room_online_min_user_stat'

过滤以某个字符开头的数据
scan 'lf:lf_t_result_platform_min_event_stat' , {FILTER => org.apache.hadoop.hbase.filter.PrefixFilter.new(Bytes.toBytes('1000-1lf_youku_home_eightAddone_12016-03-09'))}

根据开始rowkey 和 结束rowkey 发送
scan 'lf:lf_t_result_platform_min_event_stat' , {STARTROW=>"1000-1lf_youku_home_eightAddone_12016-03-09 09:10",STOPROW=>"1000-1lf_youku_home_eightAddone_12016-03-09 09:30"}

scan 'lf:lf_t_result_room_online_min_user_stat' , {STARTROW=>"54590\x092016-03-15\x092016-03-15 00:09:00\x09-1",STOPROW=>"54590\x092016-03-15\x092016-03-15 12:09:00\x09-1"}

------------------------------------------

alter 'lf:lf_t_result_room_online_min_user_stat',NAME=>'appid',TTL=>'8640000'
alter 'lf:lf_t_result_room_online_min_user_stat',NAME=>'min',TTL=>'8640000'
alter 'lf:lf_t_result_room_online_min_user_stat',NAME=>'pv',TTL=>'8640000'
alter 'lf:lf_t_result_room_online_min_user_stat',NAME=>'room',TTL=>'8640000'
alter 'lf:lf_t_result_room_online_min_user_stat',NAME=>'stat_date',TTL=>'8640000'
alter 'lf:lf_t_result_room_online_min_user_stat',NAME=>'uv',TTL=>'8640000'

hbase(main):014:0> desc 'lf:lf_t_result_room_online_min_user_stat'
Table lf:lf_t_result_room_online_min_user_stat is ENABLED
lf:lf_t_result_room_online_min_user_stat
COLUMN FAMILIES DESCRIPTION
{NAME => 'appid', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => '8640000 SECONDS (100 DAYS)', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE
=> '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
{NAME => 'min', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => '8640000 SECONDS (100 DAYS)', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE =>
'65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
{NAME => 'pv', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => '8640000 SECONDS (100 DAYS)', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE =>
'65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
{NAME => 'room', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => '8640000 SECONDS (100 DAYS)', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE =
> '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
{NAME => 'stat_date', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => '8640000 SECONDS (100 DAYS)', KEEP_DELETED_CELLS => 'FALSE', BLOCKS
IZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
{NAME => 'uv', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => '8640000 SECONDS (100 DAYS)', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE =>
'65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}