栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 前沿技术 > 大数据 > 大数据系统

实验三数据库创建表

实验三数据库创建表

现有以下关系型数据库中的表和数据,要求将其转换为适合于Hbase存储的表并插入数据:
学生表(Student)

学号(S_No)姓名(S_Name)性别(S_Sex)年龄(S_Age)
2015001Zhangsanmale23
2015002Maryfemale22
2015003Lisimale24

  • 学生表(Student)
    创建表
create 'Student','S_No','S_Name','S_Sex','S_Age'

插入数据
第一行数据:

put 'Student','s001','S_No','2015001'
put 'Student','s001','S_Name','Zhangsan'
put 'Student','s001','S_Sex','male'
put 'Student','s001','S_Age','23'


第二行数据:

put 'Student','s002','S_No','2015002'
put 'Student','s002','S_Name','Mary'
put 'Student','s002','S_Sex','female'
put 'Student','s002','S_Age','22'


第三行数据:

put 'Student','s003','S_No','2015003'
put 'Student','s003','S_Name','Lisi'
put 'Student','s003','S_Sex','male'
put 'Student','s003','S_Age','24'


课程表(Course)

课程号(C_No)课程名(C_Name)学分(C_Credit)
123001Math2.0
123002Computer Science5.0
123003English3.0

  • 课程表(Course)
    创建表
create 'Course','C_No','C_Name','C_Credit'

插入数据

put 'Course','c001','C_No','123001'
put 'Course','c001','C_Name','Math'
put 'Course','c001','C_Credit','2.0'
put 'Course','c002','C_No','123002'
put 'Course','c002','C_Name','Computer'
put 'Course','c002','C_Credit','5.0'
put 'Course','c003','C_No','123003'
put 'Course','c003','C_Name','English'
put 'Course','c003','C_Credit','3.0'


选课表(SC)

学号(SC_No)课程号(SC_Cno)成绩(SC_Score)
201500112300186
201500112300369
201500212300277
201500212300399
201500312300198
201500312300295

  • 选课表(SC)
    创建表
create 'SC','SC_No','SC_Cno','SC_Score'

插入数据

put 'SC','sc001','SC_No','2015001'
put 'SC','sc001','SC_Cno','123001'
put 'SC','sc001','SC_Score','86'
put 'SC','sc002','SC_No','2015001'
put 'SC','sc002','SC_Cno','123003'
put 'SC','sc002','SC_Score','69'
put 'SC','sc003','SC_No','2015002'
put 'SC','sc003','SC_Cno','123002'
put 'SC','sc003','SC_Score','77'
put 'SC','sc004','SC_No','2015002'
put 'SC','sc004','SC_Cno','123003'
put 'SC','sc004','SC_Score','99'
put 'SC','sc005','SC_No','2015003'
put 'SC','sc005','SC_Cno','123001'
put 'SC','sc005','SC_Score','98'
put 'SC','sc006','SC_No','2015003'
put 'SC','sc006','SC_Cno','123002'
put 'SC','sc006','SC_Score','95'

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/285773.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号