Background Information

Suppose a user develops an application to manage users who use service A in an enterprise. The procedure of operating service A on the HBase client is as follows:

• Create the user_info table.
• Add users' educational backgrounds and titles to the table.
• Query user names and addresses by user ID.
• Query information by user name.
• Deregister users and delete user data from the user information table.
• Delete the user information table after service A ends.

Procedure

1. Create a cluster named cloudtable-demo.

   For details, see Creating a Cluster Quickly.

2. Prepare a Linux ECS.

   Assume that the ECS name is ecs_ 20170916. For details, see Preparing an ECS.

3. Install a client and start the shell to access the CloudTable cluster.

   For details about how to use the HBase shell to access the cluster, see Using HBase Shell to Access a Cluster.

4. Run the following commands on the HBase client to implement service A.
   1. Create the user_info user information table and populate it with related data according to Table 1.

      create 'user_info',{NAME => 'i'}

      For example, to add information about the user whose ID is 12005000201, run the following commands:

      put 'user_info','12005000201','i:name','A'
      put 'user_info','12005000201','i:gender','Male'
      put 'user_info','12005000201','i:age','19'
      put 'user_info','12005000201','i:address','Shenzhen, Guangdong'

   2. Add users' educational backgrounds and titles to the user_info table.

      For example, to add educational background and title information about user 12005000201, run the following commands:

      put 'user_info','12005000201','i:degree','master'
      put 'user_info','12005000201','i:pose','manager'

   3. Query user names and addresses by user ID.

      For example, to query the name and address of user 12005000201, run the following command:

      scan 'user_info',{STARTROW=>'12005000201',STOPROW=>'12005000201',COLUMNS=>['i:name','i:address']}

   4. Query information by user name.

      For example, to query information about user A, run the following command:

      scan 'user_info',{FILTER=>"SingleColumnValueFilter('i','name',=,'binary:A')"}

   5. Delete user data from the user information table.

      All user data needs to be deleted. For example, to delete data of user 12005000201, run the following command:

      delete 'user_info','12005000201','i'

   6. Run the following command to delete the user information table.

      disable 'user_info';drop 'user_info'

5. Delete the cluster.

   For details, see Deleting a Cluster.