CREATE TABLE tbl
(
c1
datetime NOT NULL COMMENT “”,
c2
datetime NOT NULL COMMENT “”,
c3
varchar(65533) NULL COMMENT “”,
c4
varchar(65533) NULL COMMENT “”,
c5
varchar(65533) NULL COMMENT “”,
c6
varchar(65533) NULL COMMENT “”,
c7
varchar(65533) NULL COMMENT “”,
c8
varchar(65533) NULL COMMENT “”,
c9
varchar(65533) NULL COMMENT “”,
c10
varchar(65533) NULL COMMENT “”,
c11
varchar(65533) NULL COMMENT “”,
c12
varchar(65533) NULL COMMENT “”,
c13
varchar(65533) NULL COMMENT “”,
c14
varchar(65533) NULL COMMENT “”,
c15
varchar(65533) NULL COMMENT “”,
c16
varchar(65533) NULL COMMENT “”,
c17
varchar(65533) NULL COMMENT “”,
c18
hll HLL_UNION NULL COMMENT “”,
c19
hll HLL_UNION NULL COMMENT “”,
c20
hll HLL_UNION NULL COMMENT “”,
c21
hll HLL_UNION NULL COMMENT “”,
c22
hll HLL_UNION NULL COMMENT “”,
c23
hll HLL_UNION NULL COMMENT “”
) ENGINE=OLAP
AGGREGATE KEY(c1
, c2
, c3
, c4
, c5
, c6
, c7
, c8
, c9
, c10
, c11
, c12
, c13
, c14
, c15
, c16
, c17
)
COMMENT “hdp_lbg_ectech_lego_ods_req_dsp_new”
PARTITION BY date_trunc(‘hour’, c1)
DISTRIBUTED BY HASH(c2
, c3
, c4
) BUCKETS 10
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“partition_live_number” = “336”,
“compression” = “LZ4”
);
表结构