Data import
./hbase org.apache.hadoop.hbase.mapreduce.Driver Import table name data file location
Hdfs
The data file location can be prefixed file:///
Otherwise, the HDFs address is accessed.
Data export
./hbase org.apache.hadoop.hbase.mapreduce.Driver Export table name data file location
Enter the shell command.
cd/hbasehome/bin/
CD./hbase Shell
2016-05-20 15:36:32,370 INFO [main] Configuration.deprecation:hadoop.native.lib is deprecated. Instead, use io.native.lib.available
HBase Shell; Enter ' help<return> ' for list of supported commands.
Type "exit<return>" to leave the HBase Shell
Version 0.98.6-zdh2.1.0-snapshot, r112581, Mon Jan 05:25:14 CST 2016
HBase (Main):001:0>
HBase (Main):001:0>
Create an HBase table
Create ' table name ', ' column name 1 ', ' Column Name 2 ', ' Column name n '
HBase (Main): 001:0>create ' Test ', ' name ', ' value '
View Test Table Construction
Enter describe ' table name ' in the shell
HBase (main):003:0> desc ' test '
DESCRIPTION ENABLED
' Test ', {NAME = ' course ', data_block_encoding = ' NONE ', REPL true
Ication = ' 0 ', bloomfilter = ' ROW ', Replication_scope = ' 0 '
, COMPRESSION = ' NONE ', VERSIONS = ' 1 ', min_versions = ' 0 ',
TTL = ' FOREVER ', keep_deleted_cells = ' false ', BLOCKSIZE =
' 65536 ', Encode_on_disk = ' true ', in_memory = ' false ', BLOC
Kcache = ' true '}, {name ' = ' name ', data_block_encoding = ' NO '
NE ', REPLICATION = ' 0 ', bloomfilter = ' ROW ', Replication_sco
PE = ' 0 ', COMPRESSION = ' NONE ', VERSIONS = ' 1 ', min_version
S = ' 0 ', TTL = ' FOREVER ', keep_deleted_cells = ' false ', BLO
cksize = ' 65536 ', Encode_on_disk = ' true ', in_memory = ' fal
Se ', Blockcache = ' true '}
1 row (s) in 0.0820 seconds
HBase (Main):004:0>
Add data
Enter in the shell: Put ' table name ', ' Row name ', ' Column name: ', ' value '
HBase (Main): 005:0>put ' Test ', ' Tom ', ' value:scores ', ' 80 '
0 row (s) in 0.1420 seconds
View data
Enter in the shell: Get ' table name ', ' Row name '
HBase (main):010:0> get ' test ', ' Tom '
COLUMN CELL
Course:math timestamp=1463730444304, value=90
1 row (s) in 0.0140 seconds
HBase (Main):006:0>
View Total Data
Enter: Scan ' table name ' in the shell
HBase (Main): 006:0>scan ' Test '
ROW Column+cell
Tom Column=course:math, timestamp=1463730322512, value=80
1 row (s) in 0.0750 seconds
modifying data
Input in Shell: Put ' table name ', ' Row name ', ' Column name: ', ' Value ' (modified for original value)
HBase (Main): 007:0>put ' Test ', ' Tom ', ' Course:math ', ' 90 '
Put ' test ', ' Tom ', ' Course:math ', ' 90 '
HBase (Main): 007:0>scan ' Test '
ROW Column+cell
Tom Column=course:math, timestamp=1463730444304, value=90
1 row (s) in 0.0140 seconds
There is also a list method. View all the tables.
Count ' table name ' to see the total number of records.
Get here first.
The end
HBase Import Export, hbase shell basic commands.