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”
);
表结构