【头歌】Hive表DDL操作（一）答案

最新推荐文章于 2024-09-05 10:31:40 发布

CV大法好

最新推荐文章于 2024-09-05 10:31:40 发布

阅读量491

点赞数 12

分类专栏：头歌大数据实验答案文章标签： hive hadoop 大数据

本文链接：https://blog.csdn.net/gjw3037109961/article/details/140727349

版权

头歌大数据实验答案专栏收录该内容

17 篇文章 1 订阅

订阅专栏

本专栏已收集头歌大数据所有答案以供参考

第1关：Create/Alter/Drop 数据库

答案
复制点击测评

代码块：
#********* Begin *********#
echo "
CREATE DATABASE IF NOT EXISTS test1 
 LOCATION '/hive/test1'
 WITH DBPROPERTIES('creator'='John','date'='2019-02-25');
ALTER DATABASE test1 SET DBPROPERTIES('creator'='Marry');
DROP DATABASE test1;
"
#创建数据库test1，位于HDFS的/hive/test1下，创建人creator为John，创建日期date为2019-02-25
#修改数据库test1的创建人为Marry
#删除数据库test1
 
#********* End *********#

第2关：Create/Drop/Truncate 表

答案

复制点击测评

#********* Begin *********#
echo "
CREATE DATABASE IF NOT EXISTS test2;
 
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');
 
CREATE TABLE IF NOT EXISTS student_info LIKE student;
DROP TABLE  student;
"
#********* End *********#

第3关：Alter 表/列

答案
复制点击测评

#********* Begin *********#
echo "
CREATE DATABASE IF NOT EXISTS test3;
CREATE TABLE IF NOT EXISTS test3.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');
ALTER TABLE student RENAME TO student_info;
 
ALTER TABLE student_info CHANGE age student_age INT COMMENT 'student age';
 
ALTER TABLE student_info ADD COLUMNS (birthday STRING COMMENT 'student birthday');
"
#********* End *********#

第4关：表分区

答案
复制点击测评

#********* 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 (subject='Chinese',stu_year='2018')
LOCATION '/hive/test4/student/2018/Chinese'
PARTITION (subject='Math',stu_year='2018')
LOCATION '/hive/test4/student/2018/Math';
 
ALTER TABLE student PARTITION (subject='Math',stu_year='2018') 
RENAME TO PARTITION (subject='English',stu_year='2018');
 
ALTER TABLE student DROP IF EXISTS PARTITION (subject='Chinese',stu_year='2018');
"
#********* End *********#