Shulou(Shulou.com)06/01 Report--

I. purpose of the experiment

1. Master the method of connecting HADOOP cluster

2. Enter and exit HBASE

3. Create and delete tables

4. Insert record

5. Modify the record

6. Delete the record

7. Basic SCHEMA design

Second, the experimental environment

1. HADOOP cluster

2. HBASE client

III. Content of the experiment

The private key file putty generated under LinuxVPS is unknown, and putty only knows its own ppk format. To convert between these two formats, PuTTYgen is needed.

Puttygen is a companion program for putty, which is included in both the putty installation package and the winscp installation package. Of course, you can also download puttygen separately from http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html.

1. Run puttygen

2. Click Import key in the Conversions menu item

3. Select the id_rsa file generated under Linux VPS

4. Click the Save private key button on the interface of puttygen to convert the private key to ppk format.

Then set up PUTTY to log in automatically using the PPK file, as follows

Set up Proxy

Set the login method

After connecting, type userid in login as, and then enter ssh node51 to jump to the HADOOP cluster

At this point, you have logged in to the HADOOP cluster and can use various services of HADOOP

HBASE experiment

1. Enter and exit HBASE

Enter hbase shell

Enter exit when exiting

2. Create a table

Create'student012','name','address'

3. Insert record (or update)

Put'student012','1','name','tom'

Put'student012','1','address','szu'

Put 'student012','1','name','john' (update)

Put'student012','1','address:school','huaqiangbei street'

Put 'student012','1','address:home','shenzhen street'

4. Query records

Full table query: scan'student012'

Record query: get'student012','1'

Get'student012','1', {COLUMN= > 'address'}

Get'student012','1', {COLUMN= > 'address:home'}

5. Add columns

Alter 'student012',NAME= >' birth'

Put 'student012','1','birth','1990-02-03'

Count rows

Count 'student012'

6. Delete the record

Delete 'student012','1','name'

7. Delete columns

All data in the column must be cleared first.

Alter'student012', {NAME= > 'birth',METHOD= >' delete'}

8. Disable the meter

Disable 'student012'

9. Delete the table

Disable before deleting

Drop 'student012'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.