1、编程要求
在Begin - End
区域内进行sql
语句代码补充,具体任务如下: student
表结构:
- 创建数据库
test4
- 在数据库
tets4
中,创建分区表student
,表结构如上所示,和第二、三关相同,设置分区列为:stu_year
类型STRING
、subject
类型STRING
- 添加两个分区:
stu_year='2018',subject='Chinese'
和stu_year='2018',subject='Math'
- 重命名表分区:将
2018/Math
分区重命名为2018/English
- 删除表分区:将
2018/Chinese
分区删除
2、代码模块
#********* Begin *********#
echo "
CREATE DATABASE IF NOT EXISTS test4;
CREATE TABLE IF NOT EXISTS test4.student(
Sno INT COMMENT 'student sno',
name STRING COMMENT 'student name',
age INT COMMENT 'student age',
sex STRING COMMENT 'student sex',
score STRUCT <Chinese:FLOAT,Math:FLOAT,English:FLOAT> COMMENT 'student score') PARTITIONED BY (stu_year STRING,subject STRING);
ALTER TABLE student ADD PARTITION (stu_year='2018',subject='Chinese') PARTITION (stu_year='2018',subject='Math');
ALTER TABLE student PARTITION (stu_year='2018',subject='Math') RENAME TO PARTITION (stu_year='2018',subject='English');
ALTER TABLE student DROP IF EXISTS PARTITION (stu_year='2018',subject='Chinese');
"
#********* End *********#
3、执行输出结果