We have seen how to do scripting in HBase. In this chapter, we will see some more scripting tips and tricks, which will enable an administrator to perform various tasks in HBase by automating. We can write scripts in Ruby, shell script, and a script that's a combination of HBase commands.

Now, let's consider a case where we need to create a table with two column families and two columns, and then insert some data. The script for the same is as follows:

vi hbasescript.script

create 'table','data',
for i in '0'..'2' do 
for j in '0'..'2' do 
for k in '0'..'2' do 
put 'table', "row-#{i}#{j}#{k}","data:column#{j}#{k}", "name#{j}#{k}" end end end

After saving this script, we can run the following script:

hbase shell hbasescript.script

We can also do the same thing by going to HBase shell:

hbase > for i in '0'..'5' do \
hbase >* put "utable", "rowKey_#{i}", "address:address", "address#{i}"\
hbase...