使用有location 和无location创建HIVE数据库(DataGrip)
–创建无location的数据库 默认路径:/user/hive/warehouse
create database if not exists hive_Zhangyue_nolocation
comment "class 5"
with dbproperties ('createby'='lucy');
–创建一个有location的数据库
create database if not exists hive_Zhangyue_location
comment "指定location"
location "/class_5_hive_db"
with dbproperties ('createby'='linda');