HBase Data#

Create Data#

Inserting Data using HBase Shell#

put 'emp','1','personal data:name','raju'
put 'emp','1','personal data:city','hyderabad'
put 'emp','1','professional data:designation','manager'
put 'emp','1','professional data:salary','50000'
scan 'emp'

Inserting Data Using Java API#

  • InsertData

Update Data#

Updating Data using HBase Shell#

put 'emp','1','personal data:city','Delhi'
scan 'emp'

Updating Data Using Java API#

  • UpdateData

Read Data#

Reading Data using HBase Shell#

  • get 'emp', '1'

Reading a Specific Column#

  • get 'emp', '1', {COLUMN => 'personal data:name'}

Reading Data Using Java API#

  • RetriveData

Delete Data#

Deleting a Specific Cell in a Table#

  • delete 'emp', '1', 'personal data:city', 1558927088517

Deleting All Cells in a Table#

deleteall 'emp','1'
scan 'emp'

Deleting Data Using Java API#

  • DeleteData

Scan#

Scaning using HBase Shell#

  • scan 'emp'

Scanning Using Java API#

  • ScanTable

Count & Truncate#

count#

  • count 'emp'

truncate#

  • truncate 'emp'

Security#

grant#

grant <user> <permissions> [<table> [<column family> [<column; qualifier>]]
grant 'Tutorialspoint', 'RWXCA'

revoke#

revoke <user>
revoke 'Tutorialspoint'

user_permission#

user_permission 'tablename'
user_permission 'emp'

References#