【doris】doris测试表

-- mysql
drop table if exists student;
-- 学生表
CREATE TABLE student(
s_id bigint comment '主键',
s_name VARCHAR(20) NOT NULL DEFAULT '' comment '姓名',
s_age int DEFAULT 0 comment '年龄',
s_sex VARCHAR(10) DEFAULT 'unknow' comment '性别',
s_part  varchar(10) NOT NULL comment '分区字段',
ts datetimev2 NOT NULL comment '创建时间'
)
UNIQUE KEY(s_id)
DISTRIBUTED BY HASH(s_id)
PROPERTIES(
'replication_num'='1'
);

truncate table student;

insert into student values
(1,'zhangsan',20,'male','2020/04/30',timestamp '2024-12-01 18:01:01.666'),
(2,'lisi',44,'male','2020/04/30',timestamp '2024-06-01 18:01:01.666'),
(3,'wangwu',88,'male','2020/04/30',timestamp '2024-12-01 18:01:01.666'),
(4,'zhaoliu',31,'male','2020/04/30',timestamp '2024-12-01 22:33:01.666'),
(5,'maba',33,'male','2020/04/30',timestamp '2024-12-01 18:01:01.666');