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

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

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

答案
复制点击测评

1. 代码块：
2. #********* Begin *********#
3. echo "
4. CREATE DATABASE IF NOT EXISTS test1 
5.  LOCATION '/hive/test1'
6.  WITH DBPROPERTIES('creator'='John','date'='2019-02-25');
7. ALTER DATABASE test1 SET DBPROPERTIES('creator'='Marry');
8. DROP DATABASE test1;
9. "
10. #创建数据库test1，位于HDFS的/hive/test1下，创建人creator为John，创建日期date为2019-02-25
11. #修改数据库test1的创建人为Marry
12. #删除数据库test1
13.  
14. #********* End *********#

复制代码

 第2关：Create/Drop/Truncate 表


答案
复制点击测评

1. #********* Begin *********#
2. echo "
3. CREATE DATABASE IF NOT EXISTS test2;
4.  
5. CREATE TABLE IF NOT EXISTS test2.student(
6. Sno INT COMMENT 'student sno',
7. name STRING COMMENT 'student name',
8. age INT COMMENT 'student age',
9. sex STRING COMMENT 'student sex',
10. score STRUCT <Chinese:FLOAT,Math:FLOAT,English:FLOAT> COMMENT 'student score');
11.  
12. CREATE TABLE IF NOT EXISTS student_info LIKE student;
13. DROP TABLE  student;
14. "
15. #********* End *********#

复制代码

 第3关：Alter 表/列

答案
复制点击测评

1. #********* Begin *********#
2. echo "
3. CREATE DATABASE IF NOT EXISTS test3;
4. CREATE TABLE IF NOT EXISTS test3.student(
5. Sno INT COMMENT 'student sno',
6. name STRING COMMENT 'student name',
7. age INT COMMENT 'student age',
8. sex STRING COMMENT 'student sex',
9. score STRUCT <Chinese:FLOAT,Math:FLOAT,English:FLOAT> COMMENT 'student score');
10. ALTER TABLE student RENAME TO student_info;
11.  
12. ALTER TABLE student_info CHANGE age student_age INT COMMENT 'student age';
13.  
14. ALTER TABLE student_info ADD COLUMNS (birthday STRING COMMENT 'student birthday');
15. "
16. #********* End *********#

复制代码

第4关：表分区

答案
复制点击测评

1. #********* Begin *********#
2. echo "
3. CREATE DATABASE IF NOT EXISTS test4;
4.  
5. CREATE TABLE IF NOT EXISTS test4.student(
6. Sno INT COMMENT 'student sno',
7. name STRING COMMENT 'student name',
8. age INT COMMENT 'student age',
9. sex STRING COMMENT 'student sex',
10. score STRUCT <Chinese:FLOAT,Math:FLOAT,English:FLOAT> COMMENT 'student score')
11. PARTITIONED BY (stu_year STRING,subject STRING);
12.  
13.  
14.  
15. ALTER TABLE student ADD PARTITION (subject='Chinese',stu_year='2018')
16. LOCATION '/hive/test4/student/2018/Chinese'
17. PARTITION (subject='Math',stu_year='2018')
18. LOCATION '/hive/test4/student/2018/Math';
19.  
20. ALTER TABLE student PARTITION (subject='Math',stu_year='2018') 
21. RENAME TO PARTITION (subject='English',stu_year='2018');
22.  
23. ALTER TABLE student DROP IF EXISTS PARTITION (subject='Chinese',stu_year='2018');
24. "
25. #********* End *********#

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。