3.3.12 alter table 增加字段 字段本来不存在 但是显示已经存在

💬 StarRocks 用户问答 功能使用相关
#22 
 CREATE TABLE `ods_api_lingmao_material_warehousing_query_info_du` (
  `dt` datetime NOT NULL COMMENT "日分区",
  `__id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "__id",
  `billCode` varchar(1048576) NULL COMMENT "物料入库单号",
  `pdtCodes` varchar(1048576) NULL COMMENT "款号",
  `billDate` varchar(1048576) NULL COMMENT "制单日期",
  `warehouseCode` varchar(1048576) NULL COMMENT "仓库编码",
  `warehouseName` varchar(1048576) NULL COMMENT "仓库名称",
  `supplierCode` varchar(1048576) NULL COMMENT "供应商编码",
  `supplierName` varchar(1048576) NULL COMMENT "供应商名称",
  `totalQty` varchar(1048576) NULL COMMENT "总数量",
  `totalAmt` varchar(1048576) NULL COMMENT "总金额",
  `statuz` varchar(1048576) NULL COMMENT "状态",
  `checkDate` varchar(1048576) NULL COMMENT "审核日期",
  `checkMan` varchar(1048576) NULL COMMENT "审核人",
  `accountDate` varchar(1048576) NULL COMMENT "会计日期",
  `linkCode` varchar(1048576) NULL COMMENT "来源单号",
  `supCodeNumber` varchar(1048576) NULL COMMENT "供应商码单编号",
  `remark` varchar(1048576) NULL COMMENT "备注",
  `modifyUser` varchar(1048576) NULL COMMENT "修改人",
  `createTime` varchar(1048576) NULL COMMENT "创建时间",
  `createUser` varchar(1048576) NULL COMMENT "创建人",
  `linkType` varchar(1048576) NULL COMMENT "来源单据类型编码",
  `linkTypeName` varchar(1048576) NULL COMMENT "来源单据类型",
  `subs` varchar(1048576) NULL COMMENT "明细",
  `locs` varchar(1048576) NULL COMMENT "入库单货位信息",
  `origin_data` varchar(1048576) NULL COMMENT "原始数据",
  `yuce_cube_shop_id` varchar(1048576) NULL COMMENT "魔方店铺标识",
  `modifiyTime` varchar(1048576) NULL COMMENT "修改时间"
) ENGINE=OLAP 
PRIMARY KEY(`dt`, `__id`)
COMMENT "ODS_物料入库查询信息表(领猫API)"
PARTITION BY date_trunc('day', `dt`)
DISTRIBUTED BY HASH(`dt`, `__id`)
PROPERTIES (
"compression" = "LZ4",
"enable_persistent_index" = "true",
"fast_schema_evolution" = "true",
"replicated_storage" = "true",
"replication_num" = "1"
);

alter table ods_api_lingmao_material_warehousing_query_info_du 
add column(`modifyTime` varchar(1048576) comment '修改时间')
#23

这个"replication_num" = “1”，这个地方，当alter和写入同时进行可能会有问题。你只有1个be吗？有多个be的话，改成3试试。
而这个"replicated_storage"=“true” ，因为你只有1个副本，也没有所谓的主从之分了。

#24

只有一个节点

#25

:rofl:那有点小瑕疵正常。

京ICP备2022026421号-1