1CREATE TABLE `students` (
2  `id` INT NULL, 
3  `name` VARCHAR(256) NULL,
4  `age` INT NULL
5) ENGINE=OLAP
6UNIQUE KEY(`id`)      
7COMMENT 'OLAP' 
8DISTRIBUTED BY HASH(`id`) BUCKETS 1  
9PROPERTIES (                                                         
10"replication_allocation" = "tag.location.default: 1"
11); 

1CREATE TABLE student_sink (
2    id INT,
3    name STRING,
4    age INT
5    ) 
6    WITH (
7      'connector' = 'doris',
8      'fenodes' = '10.16.10.6:28737',
9      'table.identifier' = 'test.students',
10      'username' = 'root',
11      'password' = '',
12      'sink.label-prefix' = 'doris_label'
13);
14
15INSERT INTO student_sink values(1,'zhangsan',123)

1select * from test.students;                                                                                                                        
2+------+----------+------+      
3| id   | name     | age  |    
4+------+----------+------+                                                                                                                             
5|  1   | zhangsan |  123 |   
6+------+----------+------+