In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Enter the hbase command line
. / hbase shell
Show tables in hbase
List
Create a user table that contains two column families, info and data
Create 'users',' info', 'data'
/ / you can also use this command:
/ / create 'users', {NAME = >' info', VERSIONS = >'3'}
Insert information into the table with row key as rk0001 and column family info with name column identifier with a value of zhangsan
Put 'users',' rk0001', 'info:name',' zhangsan'
Insert information into the table with row key as rk0001 and column family info with gender column identifier with a value of female
Put 'user',' rk0001', 'info:gender',' female'
Insert information into the table with row key as rk0001 and add an age column identifier with a value of 20 to the column family info
Put 'user',' rk0001', 'info:age', 21
Get all the information in the table whose row key is rk0001
Get 'user',' rk0001'
Get all the information in the table where row key is the rk0001,info column family
Get 'user',' rk0001', 'info'
Get the information of the name and age column identifiers in the user table where row key is the rk0001,info column family
Get 'user',' rk0001', 'info:name',' info:age'
Get the information that row key is rk0001,info and data column family in user table
Get 'USERS',' rk0001', 'INFO',' DATA'
Get 'user',' rk0001', {COLUMN = > ['info',' data']}
Get 'user',' rk0001', {COLUMN = > ['info:name',' data:pic']}
Get the information that the row key is rk0001, the column family is info and the version number is the latest 5 in the user table
Get 'user',' rk0001', {COLUMN = > 'info', VERSIONS = > 2}
Get 'user',' rk0001', {COLUMN = > 'info:name', VERSIONS = > 5}
Get 'user',' rk0001', {COLUMN = > 'info:name', VERSIONS = > 5, TIMERANGE = > [1392368783980,1392380169184]}
Get the information in the user table that row key is rk0001,cell and the value is zhangsan
Get 'people',' rk0001', {FILTER = > "ValueFilter (=, 'binary: picture')"}
Get the information that row key is rk0001 and column identifier contains an in the user table
Get 'people',' rk0001', {FILTER = > "(QualifierFilter (=, 'substring:a'))"}
Put 'user',' rk0002', 'info:name',' fanbingbing'
Put 'user',' rk0002', 'info:gender',' female'
Put 'user',' rk0002', 'info:nationality',' China'
Get 'user',' rk0002', {FILTER = > "ValueFilter (=, 'binary: China')"}
Query all the information in the user table
Scan 'user'
Query the information of the column family info in the user table
Scan 'user', {COLUMNS = >' info'}
Scan 'user', {COLUMNS = >' info', RAW = > true, VERSIONS = > 5}
Scan 'persion', {COLUMNS = >' info', RAW = > true, VERSIONS = > 3}
Query the information that the column families in the user table are info and data
Scan 'user', {COLUMNS = > [' info', 'data']}
Scan 'user', {COLUMNS = > [' info:name', 'data:pic']}
Query the information in the user table where the column family is info and the column identifier is name
Scan 'user', {COLUMNS = >' info:name'}
Query the information in the user table with the column family of info, the column identifier of name, and the latest version of 5
Scan 'user', {COLUMNS = >' info:name', VERSIONS = > 5}
Query the information in the user table where the column families are info and data and the column identifier contains the a character
Scan 'user', {COLUMNS = > [' info', 'data'], FILTER = > "(QualifierFilter (=,' substring:a'))"}
Query the data in the user table whose column family is info,rk and the range is [rk0001, rk0003)
Scan 'people', {COLUMNS = >' info', STARTROW = > 'rk0001', ENDROW = >' rk0003'}
Query the row key that begins with the rk character in the user table
Scan 'user', {FILTER= > "PrefixFilter (' rk')"}
Query the specified range of data in the user table
Scan 'user', {TIMERANGE = > [1392368783980,1392380169184]}
Delete data
Delete the data whose row key is rk0001 and column identifier is info:name in the user table
Delete 'people',' rk0001', 'info:name'
Delete the data whose row key is rk0001 and column identifier is 1392383705316 in user table
Delete 'user',' rk0001', 'info:name', 1392383705316
Clear the data in the user table
Truncate 'people'
Modify table structure
First deactivate the user table (not in the new version)
Disable 'user'
Add two column families F1 and f2
Alter 'people', NAME = >' F1'
Alter 'user', NAME = >' f2'
Enable tabl
Enable 'user'
Disable 'user' (not used in the new version)
Delete a column family:
Alter 'user', NAME = >' F1', METHOD = > 'delete' or alter' user', 'delete' = >' F1'
Add column family F1 and delete column family f2
Alter 'user', {NAME = >' f1'}, {NAME = >'f2', METHOD = > 'delete'}
Change the F1 column family version number of user to 5
Alter 'people', NAME = >' info', VERSIONS = > 5
Enable tabl
Enable 'user'
Delete tabl
Disable 'user'
Drop 'user'
Get 'person',' rk0001', {FILTER = > "ValueFilter (=, 'binary: China')"}
Get 'person',' rk0001', {FILTER = > "(QualifierFilter (=, 'substring:a'))"}
Scan 'person', {COLUMNS = >' info:name'}
Scan 'person', {COLUMNS = > [' info', 'data'], FILTER = > "(QualifierFilter (=,' substring:a'))"}
Scan 'person', {COLUMNS = >' info', STARTROW = > 'rk0001', ENDROW = >' rk0003'}
Scan 'person', {COLUMNS = >' info', STARTROW = > '201402011', ENDROW = >' 20140301'}
Scan 'person', {COLUMNS = >' info:name', TIMERANGE = > [13959782336361395987769587]}
Delete 'person',' rk0001', 'info:name'
Alter 'person', NAME = >' ffff'
Alter 'person', NAME = >' info', VERSIONS = > 10
Get 'user',' rk0002', {COLUMN = > ['info:name',' data:pic']}
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.