一、关于此次实践

1、实战简介

Hive数据定义语言（Date Definition Language）包括 Create/Drop/Alter数据库、Create/Drop/Truncate表、Alter 表/分区/列、Create/Drop/Alter视图、Create/Drop/Alter索引、Create/Drop函数、Create/Drop/Grant/Revoke角色和权限等内容。

2、全部任务

在这里插入图片描述

二、实践详解

1、第1关：Create/Drop/Alter 视图

在这里插入图片描述

#********* Begin *********#
echo "
CREATE DATABASE IF NOT EXISTS test1;
CREATE TABLE IF NOT EXISTS test1.student(
Sno INT,
name STRING,
age INT,
sex STRING,
score STRUCT<Chinese:FLOAT,Math:FLOAT,English:FLOAT>)
;
CREATE VIEW student_view(
Sno,
name_length,
age,
sex
) 
AS SELECT Sno,length(name),age,sex FROM student;
alter view student_view rename to student_info_views;
drop view if exists student_info_views;
"
#********* End *********#

评测
在这里插入图片描述

2、第2关：Create/Drop/ALTER 索引

在这里插入图片描述
按照以上要求填写命令。每个要求对应一条命令，共5条命令，以;隔开。由于hive启动时间较长，测评时请耐心等待，大概需要时间：1-3分钟。

#********* Begin *********#
echo "
CREATE DATABASE IF NOT EXISTS test2
LOCATION '/hive/test2'
WITH DBPROPERTIES('creator'='Floret','date'='2020-11-16');
CREATE TABLE IF NOT EXISTS test2.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')
COMMENT 'students information table'
row format delimited fields terminated by ',' 
collection items terminated by '-'
TBLPROPERTIES ('creator'='Floret','date'='2020-11-16');
load data local inpath '/home/student.txt'
overwrite into table student;
create index student_index on table student(Sno)
as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler'
with deferred rebuild
IN TABLE student_index_table;
drop index if exists student_index on student;
"
#********* End *********#