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