starrocks版本3.1.9,doris 2.1,x2doris 1.0.3
表结构:
CREATE TABLE `T1` (
  `field1` varchar(255) NULL COMMENT "",
  `field2` varchar(255) NULL COMMENT "",
  `field3` varchar(255) NULL COMMENT "",
  `field4` varchar(255) NULL COMMENT "",
  `field5` varchar(255) NULL COMMENT "",
  `field6` varchar(255) NULL COMMENT "",
  `field7` varchar(255) NULL COMMENT "",
  `field8` varchar(255) NULL COMMENT "",
  `field9` varchar(255) NULL COMMENT "",
  `field10` varchar(255) NULL COMMENT ""
) ENGINE=OLAP 
DUPLICATE KEY(`field1`)
DISTRIBUTED BY HASH(`field1`) BUCKETS 1 
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"enable_persistent_index" = "false",
"replicated_storage" = "true",
"compression" = "LZ4"
);
x2doris识别为:
CREATE TABLE `T1` (
  `field1` string, NULL COMMENT "",
  `field2` string, NULL COMMENT "",
  `field3` string, NULL COMMENT "",
  `field4` string, NULL COMMENT "",
  `field5` string, NULL COMMENT "",
  `field6` string, NULL COMMENT "",
  `field7` string, NULL COMMENT "",
  `field8` string, NULL COMMENT "",
  `field9` string, NULL COMMENT "",
  `field10` string, NULL COMMENT ""
) ENGINE=OLAP 
DUPLICATE KEY(`field1`)
DISTRIBUTED BY HASH(`field1`) BUCKETS 1 
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"compression" = "LZ4"
);
string后面会多个 , 并且建表失败,key里列不能为string


