CREATE TABLE table_a
(
aa
varchar(65533) NOT NULL COMMENT “”,
bb
varchar(65533) NOT NULL COMMENT “”,
bb
varchar(65533) NOT NULL COMMENT “”,
dd
int(11) NULL COMMENT “”,
ee
int(11) NULL COMMENT “”,
ff
varchar(65533) NULL COMMENT “”,
gg
varchar(65533) NULL COMMENT “”,
hh
varchar(65533) NULL COMMENT “”,
ii
varchar(65533) NULL COMMENT “”,
jj
varchar(65533) NULL COMMENT “”,
kk
float NULL COMMENT “”,
ll
float NULL COMMENT “”,
mm
float NULL COMMENT “”,
nn
int(11) NULL COMMENT “”,
oo
varchar(65533) NULL COMMENT “”,
pp
int(11) NULL COMMENT “”,
qq
int(11) NULL COMMENT “”,
rr
int(11) NULL COMMENT “”,
ss
float NULL COMMENT “”,
tt
int(11) NULL COMMENT “”,
uu
varchar(65533) NULL COMMENT “”,
vv
float NULL COMMENT “”,
ww
float NULL COMMENT “”,
xx
float NULL COMMENT “”,
yy
int(11) NULL COMMENT “”,
zz
varchar(65533) NULL COMMENT “”,
aaa
float NULL COMMENT “”,
bbb
varchar(65533) NULL COMMENT “”,
ccc
bigint(20) NULL COMMENT “”,
ddd
varchar(65533) NULL COMMENT “”,
eee
varchar(65533) NULL COMMENT “”,
fff
int(11) NULL COMMENT “”,
ggg
int(11) NULL COMMENT “”
) ENGINE=OLAP
PRIMARY KEY(aa
,bb
)
DISTRIBUTED BY HASH(bb
) BUCKETS 2000
PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“enable_persistent_index” = “true”,
“replicated_storage” = “true”,
“storage_medium” = “SSD”,
“compression” = “LZ4”
);