create table person
(
id int,
name string,
hobbies array<string>,
address map<string,string>
)
partitioned by (spark_load_date STRING) 分区字段
row format delimited
fields terminated by ',' 字段之间分隔符
collection items terminated by '-' 数组之间分隔符
map keys terminated by ':' map之间分隔符
STORED AS textfile; 建表类型
hive建表
最新推荐文章于 2024-05-10 15:10:54 发布