-
显示集群下所有的表: list
-
创建表 create ‘tablename’,‘cloumnfamily’
-
表中添加数据 put ‘tablename’,‘rowkey’,‘cloumnfamily:cell’,‘value’
-
查询表中数据 get ‘tablename’,‘rowkey’,‘cloumnfamily:cell’
-
根据列簇查询: get ‘tablename’,‘rowkey’
-
根据列名查询: scan ‘scores’,{COLUMNS=>‘cloumnfamily:cell’}
-
删除表: disable ‘tablename’ drop ‘tablename’
-
扫描整张表的数据: scan ‘tablename’
-
查询指定列簇的数据 : scan ‘tablename’,{COLUMN => ‘columnfamily’}
-
条件查询 : scan ‘Treacher’, {COLUMNS=> ‘terinfo:tername’,STARTROW => ‘row2’,STOPROW => ‘row3’,LIMIT=>1, VERSIONS=>3}
-
添加列族 : alter ‘表名’, ‘列族名’
10.删除列族 : alter ‘表名’, {NAME => ‘列族名’, METHOD => ‘delete’}
11.值包含数据查询 scan ‘Treacher’, FILTER=>“ValueFilter(=,‘substring:Li’)”