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”
);