# HBase

**Repository Path**: Mr-Nan05/hbase

## Basic Information

- **Project Name**: HBase
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-12-16
- **Last Updated**: 2021-12-16

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# README

宋超群 171860642

mr.nan0505@qq.com

### 安装过程记录

![image-20211214143108161](README.assets/image-20211214143108161.png)

![image-20211214143041704](README.assets/image-20211214143041704.png)

![image-20211214142823896](README.assets/image-20211214142823896.png)

![image-20211214142928878](README.assets/image-20211214142928878.png)

![image-20211214142944838](README.assets/image-20211214142944838.png)

### JAVA程序执行

具体内容见代码，运行结果截图如下：

![image-20211216161142527](README.assets/image-20211216161142527.png)

### SHELL执行过程

设计表格并插入数据

```shell
# 建表
create 'StuInfo','Student','Math','ComputerScience','English'

# 插入Li Lei的信息
put 'StuInfo','2015001','Student:S_No','2015001'
put 'StuInfo','2015001','Student:S_Name','Li Lei'
put 'StuInfo','2015001','Student:S_Sex','male'
put 'StuInfo','2015001','Student:S_Age','23'
# Han Meimei
put 'StuInfo','2015002','Student:S_No','2015002'
put 'StuInfo','2015002','Student:S_Name','Han Meimei'
put 'StuInfo','2015002','Student:S_Sex','female'
put 'StuInfo','2015002','Student:S_Age','22'
# Zhang San
put 'StuInfo','2015003','Student:S_No','2015003'
put 'StuInfo','2015003','Student:S_Name','Zhang San'
put 'StuInfo','2015003','Student:S_Sex','male'
put 'StuInfo','2015003','Student:S_Age','24'

# 添加15001选数学课
put 'StuInfo','2015001','Math:C_No','123001'
put 'StuInfo','2015001','Math:C_Name','Math'
put 'StuInfo','2015001','Math:C_Credit','2.0'
# 15001选了英语课
put 'StuInfo','2015001','English:C_No','123002'
put 'StuInfo','2015001','English:C_Name','English'
put 'StuInfo','2015001','English:C_Credit','3.0'

# 15002的选课信息
put 'StuInfo','2015002','English:C_No','123002'
put 'StuInfo','2015002','English:C_Name','English'
put 'StuInfo','2015002','English:C_Credit','3.0'

put 'StuInfo','2015002','ComputerScience:C_No','123003'
put 'StuInfo','2015002','ComputerScience:C_Name','ComputerScience'
put 'StuInfo','2015002','ComputerScience:C_Credit','5.0'

# 2015003的选课信息
put 'StuInfo','2015003','Math:C_No','123001'
put 'StuInfo','2015003','Math:C_Name','Math'
put 'StuInfo','2015003','Math:C_Credit','2.0'

put 'StuInfo','2015003','ComputerScience:C_No','123003'
put 'StuInfo','2015003','ComputerScience:C_Name','ComputerScience'
put 'StuInfo','2015003','ComputerScience:C_Credit','5.0'

# 2015001的选课成绩
put 'StuInfo','2015001','Math:SC_Score','86'
put 'StuInfo','2015001','English:SC_Score','69'

# 2015002学生所选课的成绩
put 'StuInfo','2015002','English:SC_Score','77'
put 'StuInfo','2015002','ComputerScience:SC_Score','99'

# 2015003选课成绩
put 'StuInfo','2015003','Math:SC_Score','98'
put 'StuInfo','2015003','ComputerScience:SC_Score','95'
```

![image-20211216145258600](README.assets/image-20211216145258600.png)![image-20211216145330592](README.assets/image-20211216145330592.png)![image-20211216145423169](README.assets/image-20211216145423169.png)

查询选修Computer Science的学生的成绩

```sh
# 查询选修Computer Science的学生的成绩
scan 'StuInfo',{COLUMN=>'ComputerScience:SC_Score'}
```

![image-20211216145744758](README.assets/image-20211216145744758.png)

增加新的列族和新列Contact:Email,并添加数据

```sh
# 增加新的列族和新列Contact:Email,并添加数据
alter 'StuInfo','Contact'
put 'StuInfo','2015001','Contact:Email','lilei@qq.com'
put 'StuInfo','2015002','Contact:Email','hmm@qq.com'
put 'StuInfo','2015003','Contact:Email','zs@qq.com'

describe 'StuInfo'
```

![image-20211216145931473](README.assets/image-20211216145931473.png)![image-20211216150111026](README.assets/image-20211216150111026.png)

删除学号为2015003的学生的选课记录并删除表格

```shell
# 删除学号为2015003的学生的选课记录
delete 'StuInfo','2015003','Math:C_No'
delete 'StuInfo','2015003','Math:C_Name'
delete 'StuInfo','2015003','Math:C_Credit'
delete 'StuInfo','2015003','Math:SC_Score'

delete 'StuInfo','2015003','ComputerScience:C_No'
delete 'StuInfo','2015003','ComputerScience:C_Name'
delete 'StuInfo','2015003','ComputerScience:C_Credit'
delete 'StuInfo','2015003','ComputerScience:SC_Score'

# 删除创建的表
disable 'StuInfo'
drop 'StuInfo'
```

![image-20211216150249445](README.assets/image-20211216150249445.png)![image-20211216150314644](README.assets/image-20211216150314644.png)