create table test_01(
name string,
friends array<string>,
children map<string,int>,
address struct<street:string,city:string>)
row format delimited fields terminated by ','
collection items terminated by '_'
map keys terminated by ':'
lines terminated by '\n';
create table student01(id int ,name string)
> row format delimited fields terminated by ','
> stored as textfile location '/user/hive/warehouse/';
create table if not exists student2 (id int ,name string)
row format delimited fields terminated by ',' stored as textfile
location '/user/hive/warehouse/student2'
hive 建表 分区语句(仅供参考)
最新推荐文章于 2024-05-25 11:32:41 发布