hive建表语句

create table dwd.tmp_table (
    ti tinyint,
    sl smallint,
    i  int,
    bi bigint,
    bl boolean,
    fl float,
    db double,
    st string,
    ts timestamp,
    ba binary comment '字节数组',
    ar array<string>,
    mp map<string, float>,
    su struct<f1:string, f2:float, f3:string, f4:int>)
comment '表名称'
partitioned by (dt string)
--分隔符
row format delimited
fields terminated by '\001'
collection items terminated by '\002'
map keys terminated by '\003'
lines terminated by '\n'
--输入输出
stored as parquet
--位置
location "hdfs://localhost:8020/Users/duhongliu/hadoopinstall/hive-2.3.8/warehouse/dwd.db/tmp_table"
--表额外信息
tblproperties ('creator'='DUDU')