educoder（头歌）实训平台大数据作业答案-Hive表DDL操作（一）

Hive表DDL操作（一）

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

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;  

第2关：Create/Drop/Truncate 表

CREATE DATABASE IF NOT EXISTS test2  
LOCATION '/hive/test2'  
WITH DBPROPERTIES('creator'='John','date'='2022-04-20');  

CREATE TABLE IF NOT EXISTS test2.student(  
Sno INT COMMENT 'student sno',  
name ST