doris SQL建表语句 CREATE TABLE [IF NOT EXISTS] [database.]table

建表语句

CREATE TABLE [IF NOT EXISTS] [database.]table ( column_definition_list [, index_definition_list] ) [engine_type] [keys_type] [table_comment] [partition_info] distribution_desc [rollup_list] [properties] [extra_properties]

#### column_definition_list列的表定义

column_definition，column_definition，column_definition

每个列的定义column_definition

column_name column_type [KEY] [aggr_type] [NULL] [AUTO_INCREMENT(auto_inc_start_value)] [default_value] [on update current_timestamp] [column_comment]

举例：

k1 TINYINT,  
k2 DECIMAL(10,2) DEFAULT "10.5",  
k4 BIGINT NULL DEFAULT "1000" COMMENT "This is column k4",  
v1 VARCHAR(10) REPLACE NOT NULL,  
v2 BITMAP BITMAP_UNION,  
v3 HLL HLL_UNION,  
v4 INT SUM NOT NULL DEFAULT "1" COMMENT "This is column v4"  
dt datetime(6) default current_timestamp(6) on update current_timestamp(6)`

完美例子：

(
    `createtime` DATETIME NOT NULL COMMENT "日志时间",
    `type` INT NOT NULL COMMENT "日志类型",
    `error_code` INT COMMENT "错误码",
    `error_msg` VARCHAR(1024) COMMENT "错误详细信息",
    `op_id` BIGINT COMMENT "负责人 id",
    `op_time` DATETIME COMMENT "处理时间"
)engine=olap
DUPLICATE key (createtime,type)
COMMENT "doris_ts.example_log table"
partItion by range (createtime)
(
PARTITION p1  VALUES less than ("2022-12-13"),
PARTITION p2 VALUES less than ("2023-12-13"),
PARTITION p3 VALUES less than ("2024-12-13")
)
distributed by hash (createtime) buckets 10
PROPERTIES(
"replication_num"="1"
);