第1關：計算每個班的語文總成績和數學總成績

---------- 禁止修改 ----------drop database if exists mydb cascade;set hive.auto.convert.join = false;
set hive.ignore.mapjoin.hint=false;
---------- 禁止修改 ----------
---------- begin ----------
---創建mydb數據庫
create database if not exists mydb;
---使用mydb數據庫
use mydb;
---創建表score
create table if not exists score(
name string comment '姓名',
chinese string comment '語文成績',
maths string comment '數學成績'
)
row format delimited fields terminated by ','
stored as textfile;
---導入數據：/root/data/step1_files/score.txt
load data local inpath '/root/data/step1_files/score.txt' into table score;
--創建表class
create table if not exists class(
stuname string comment '姓名',
classname string comment '所在班級'
)
row format delimited fields terminated by ','
stored as textfile;
---導入數據：/root/data/step1_files/class.txt
load data local inpath '/root/data/step1_files/cl