HBase Table
Create Table
Creating a Table using HBase Shell
create ‘<table name>’,’<column family>’
Example:
hbase(main):002:0> create 'emp', 'personal data', 'professional data'
Verification:
list
Creating a Table Using java API
CreateTable
AdminExample
$javac CreateTable.java
$java CreateTable
Tips
HADOOP_HOME
dir\hadoop-common-2.2.0-bin-master
Path
%HADOOP_HOME%\bin;
compile group: 'org.apache.hbase', name: 'hbase-client', version: '1.4.9'
compile group: 'org.apache.hadoop', name: 'hadoop-hdfs', version: '2.9.2'
compile group: 'org.apache.hadoop', name: 'hadoop-common', version: '2.9.2'
vi /etc/hosts
192.168.100.210 tc210
tail -f -n 99 /usr/local/hbase-1.4.9/logs/hbase-hadoop-master-tc210.log
Listing Table
Listing a Table using HBase Shell
list
Listing Tables Using Java API
ListTables
Disabling a Table
Disabling a Table using HBase Shell
disable 'emp'
Verification:
scan 'emp'
is_disabled:
is_disabled 'emp'
disable_all:
disable_all 'r.*'
Disable a Table Using Java API
DisableTable
Enabling a Table
Enabling a Table using HBase Shell
enable 'emp'
Verification:
scan 'emp'
is_enabled:
is_enabled 'emp'
Enable a Table Using Java API
EnableTable
Describe & Alter
describe
describe 'emp'
alter
Changing the Maximum Number of Cells of a Column Family:
alter 'emp', NAME => 'personal data', VERSIONS => 5
Setting Read Only:
alter 'emp', READONLY
Removing Table Scope Operators:
alter 't1', METHOD => 'table_att_unset', NAME => 'MAX_FILESIZE'
Deleting a Column Family:
alter 'table name', 'delete' => 'column family'
Adding a Column Family Using Java API
AddColumn
Deleting a Column Family Using Java API
DeleteColumn
Exists
Existence of Table using HBase Shell
exists 'emp'
Verifying the Existence of Table Using Java API
TableExists
Drop a Table
Dropping a Table using HBase Shell
disable 'emp'
drop 'emp'
Verification:
exists 'emp'
drop_all:
disable_all 'raj.*'
,drop_all 'raj.*'
Deleting a Table Using Java API
DeleteTable