hive 创表语句:
create table student(id int,name string) partitioned by (ds string) row format dilimited fields terminated by ‘|’;
hive 创建压缩表语句:
create table student(id int,name string) partitioned by (ds string) stored as orc tblproperties (“orc.compress”=“SNAPPY”);
mysql创建表
create table student (id int,name varchar(100));