HBase Shell

Create

创建表命令

create 'book' , 'info'

Alter修改表命令

alter 'book' ,  {NAME=>'chapters',VERSIONS=>5}

Put添加、修改数据

put 'book', '001_ISBN9781491941959','info:date', 12345678put 'book', '001_ISBN9781491941959','info:author','Caleb Doxsey'put 'book', '001_ISBN9781491941959','info:name','Introducing Go'put 'book', '001_ISBN9781491941959','chapters:subject_001', 'Introduction'put 'book', '001_ISBN9781491941959','chapters:subject_002', 'Getting Started'put 'book', '001_ISBN9781491941959','chapters:subject_003', 'Types'put 'book', '001_ISBN9781491941959','chapters:subject_004', 'Variables'put 'book', '002_ISBN9781491940747','info:date', 12345679put 'book', '002_ISBN9781491940747','info:author','Jon Manning,Paris Buttfield-Addison, Tim Nugent'put 'book', '002_ISBN9781491940747','info:name','Learning Swift'put 'book', '002_ISBN9781491940747','chapters:subject_001', 'Swift Basics'put 'book', '002_ISBN9781491940747','chapters:subject_001', 'An OS X App'put 'book', '002_ISBN9781491940747','chapters:subject_003', 'An IOS App'put 'book', '002_ISBN9781491940747','chapters:subject_004', 'Extending Your App'put 'book', '003_ISBN9781491915813','info:date', 12345680put 'book', '003_ISBN9781491915813','info:author','Jean-Marc Spaggiari, Kevin O\'Dell'put 'book', '003_ISBN9781491915813','info:name','Architecting HBase Applications'put 'book', '003_ISBN9781491915813','chapters:subject_001', 'Introduction to Hbase'put 'book', '003_ISBN9781491915813','chapters:subject_002', 'User Cases'put 'book', '003_ISBN9781491915813','chapters:subject_003', 'Troubleshooting'put 'book', '003_ISBN9781491915813','chapters:subject_004', 'Extending Your App'```##San查询PrefixFilterColumnPrefixFilterFamilyFilterQualifierFilter```scan 'book', {FILTER => " PrefixFilter ('001')", LIMITS=>2}scan 'book', {FILTER => " (PrefixFilter ('00')) AND (FamilyFilter (=,'binary:info')) "}scan 'book', {FILTER => "(PrefixFilter ('001')) AND (FamilyFilter (=,'binary:chapters')) AND(ColumnPrefixFilter ('subject'))"}scan 'book', {FILTER => "(PrefixFilter ('003')) AND (FamilyFilter (=,'binary:chapters')) AND (QualifierFilter (>,'binary:subject_001'))"}scan 'book', {FILTER => "(PrefixFilter ('003')) AND (FamilyFilter (=,'binary:chapters')) AND (QualifierFilter (>,'binary:subject_001')) AND (QualifierFilter (<=,'binary:subject_003'))"}```##Truncate 清空表数据```shell truncate 'book'```