mv convert TStatisticData to ColumnStatistics failed

bulolo commented 4 weeks ago

use mv,but the datetime sometime success and sometime fail

2024-10-28 09:30:03.682+08:00 WARN (stats-cache-refresher-0|104) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 <1:30:25.669680' could not be parsed at index 0
 2024-10-28 09:30:03.700+08:00 WARN (stats-cache-refresher-5|109) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transferde_mv, column : RTD_TOLOTTABLE12, errMsg : Text 'ï¿½9ï¿½3-11-25' could not be parsed at index 0
 2024-10-28 09:30:21.711+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_crm_orders_mv, column : read_at, errMsg : Text 'ï¿½9ï¿½3-11-24 03:34:44.902071' could not be parsed at index 0
 2024-10-28 09:30:21.711+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_crm_orders_mv, column : cancel_at, errMsg : Text 'B345-03-12 ?3:18:31.719040' could not be parsed at index 0
 2024-10-28 09:40:30.165+08:00 WARN (stats-cache-refresher-2|106) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_crm_orders_mv, column : cancel_at, errMsg : Text '<410-08-07 <5:44:50.079587' could not be parsed at index 0
 2024-10-28 09:40:30.166+08:00 WARN (stats-cache-refresher-2|106) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_crm_orders_mv, column : read_at, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00' could not be parsed at index 0
 2024-10-28 09:50:03.734+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 C8:02:44.571283' could not be parsed at index 0
 2024-10-28 09:50:03.799+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transferde_mv, column : RTD_TOLOTTABLE12, errMsg : Text 'ï¿½9ï¿½4-08-07' could not be parsed at index 0
 2024-10-28 09:50:26.121+08:00 WARN (stats-cache-refresher-2|106) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_crm_orders_mv, column : cancel_at, errMsg : Text 'ï¿½9ï¿½4-03-30 ;9:06:56.441600' could not be parsed at index 0
 2024-10-28 09:50:26.121+08:00 WARN (stats-cache-refresher-2|106) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_crm_orders_mv, column : read_at, errMsg : Text 'ï¿½9ï¿½3-11-24 04:46:19.869186' could not be parsed at index 0

murphyatwork commented 4 weeks ago

Text 'ï¿½9ï¿½3-11-24 03:34:44.902071' could not be parsed at index 0

can you provide the schema of that table ?

bulolo commented 4 weeks ago

Text 'ï¿½9ï¿½3-11-24 03:34:44.902071' could not be parsed at index 0

can you provide the schema of that table ?

CREATE TABLE `ods_crm_orders` (
  `_id` varchar(65533) NOT NULL COMMENT "基本信息 - ID",
  `cancelAt` datetime NULL COMMENT "状态信息、电商订单信息 - 取消时间",
  `readAt` datetime NULL COMMENT "电商订单信息 - 已读时间（客户）",
  `createAt` datetime NOT NULL COMMENT "状态信息 - 创建时间",
  `type` int(11) NOT NULL COMMENT "基本信息 - 订单类型"
) ENGINE=OLAP 
PRIMARY KEY(`_id`, `createAt`, `type`)
COMMENT "crm订单表"
PARTITION BY date_trunc('day', createAt)
DISTRIBUTED BY HASH(`type`) BUCKETS 3 
ORDER BY(`createAt`, `type`);

CREATE MATERIALIZED VIEW `dwd_crm_orders_mv` 
COMMENT "dwd-crm订单表"
PARTITION BY (date_trunc('day', `create_at`))
DISTRIBUTED BY RANDOM
REFRESH ASYNC START("2024-10-01 10:00:00") EVERY(INTERVAL 10 MINUTE)
AS 
SELECT 
        oco._id as order_id,  -- 订单id
        oco.createAt as create_at,  -- 创建时间
        oco.readAt as read_at,  -- 已读时间（客户）
        oco.cancelAt as cancel_at  -- 取消时间
FROM 
        scm.ods_crm_orders oco;

The above shows the structure of my ods_crm_orders table and the materialized view dwd_crm_orders_mv.

Currently, the cancelAt and readAt fields in ods_crm_orders are both NULL. The logs frequently display the exception information shown in the screenshot above. At present, I am unable to locate the specific data causing the error because the fields I see are all NULL, and I cannot confirm whether the error occurs during insertion or update operations.

If you need any further adjustments or additional context included, feel free to let me know!

bulolo commented 4 weeks ago

发现一个规律，所有日期字段，只要table不是必填日期，mv就一定会报这个warning @murphyatwork

2024-10-29 09:50:28.072+08:00 WARN (stats-cache-refresher-5|109) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00' could not be parsed at index 0
 2024-10-29 09:50:29.956+08:00 WARN (stats-cache-refresher-7|111) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transferde_mv, column : RTD_TOLOTTABLE12, errMsg : Text 'ï¿½723-07-21' could not be parsed at index 0
 2024-10-29 09:51:26.193+08:00 WARN (stats-cache-refresher-2|106) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 @3:03:15.561088' could not be parsed at index 0
 2024-10-29 09:51:39.956+08:00 WARN (stats-cache-refresher-7|111) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transferde_mv, column : RTD_TOLOTTABLE12, errMsg : Text 'ï¿½0ï¿½3-04-14' could not be parsed at index 0
 2024-10-29 09:51:51.452+08:00 WARN (stats-cache-refresher-9|113) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:08.237139' could not be parsed at index 0
 2024-10-29 09:52:20.261+08:00 WARN (stats-cache-refresher-4|108) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transferde_mv, column : RTD_TOLOTTABLE12, errMsg : Text 'ï¿½9ï¿½3-11-24' could not be parsed at index 0
 2024-10-29 09:52:22.956+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 @2:25:16.129024' could not be parsed at index 0
 2024-10-29 09:52:45.667+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½3-11-24 00:14:02.609205' could not be parsed at index 0
 2024-10-29 09:52:47.194+08:00 WARN (stats-cache-refresher-5|109) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transferde_mv, column : RTD_TOLOTTABLE12, errMsg : Text 'n917-09-02' could not be parsed at index 0
 2024-10-29 09:53:12.314+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transferde_mv, column : RTD_TOLOTTABLE12, errMsg : Text 'ï¿½9ï¿½3-11-24' could not be parsed at index 0
 2024-10-29 09:53:15.898+08:00 WARN (starrocks-mysql-nio-pool-1|288) [MaterializedView.getBaseTablePartitionColumnMapImpl():1588] Partition slot ref SlotRef{id=null, type=INVALID_TYPE, sel=-1.0, #distinct=-1, scale=-1} is not in the base table dwd_crm_orders_mv, baseTablePartitionSlotMap:{Table [id=6140761, name=dwd_crm_order_item_allots_mv, type=CLOUD_NATIVE_MATERIALIZED_VIEW]=SlotRef{id=null, type=INVALID_TYPE, sel=-1.0, #distinct=-1, scale=-1}, Table [id=8184049, name=dwd_crm_orders_mv, type=CLOUD_NATIVE_MATERIALIZED_VIEW]=SlotRef{id=null, type=INVALID_TYPE, sel=-1.0, #distinct=-1, scale=-1}}
 2024-10-29 09:53:16.003+08:00 WARN (starrocks-mysql-nio-pool-2|289) [MaterializedView.getBaseTablePartitionColumnMapImpl():1588] Partition slot ref SlotRef{id=null, type=INVALID_TYPE, sel=-1.0, #distinct=-1, scale=-1} is not in the base table dwd_wms_orders_mv, baseTablePartitionSlotMap:{Table [id=6120027, name=dwd_wms_orders_mv, type=CLOUD_NATIVE_MATERIALIZED_VIEW]=SlotRef{id=null, type=INVALID_TYPE, sel=-1.0, #distinct=-1, scale=-1}, Table [id=6121537, name=dwd_wms_pick_detail_mv, type=CLOUD_NATIVE_MATERIALIZED_VIEW]=SlotRef{id=null, type=INVALID_TYPE, sel=-1.0, #distinct=-1, scale=-1}}
 2024-10-29 09:53:16.147+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-18 00:28:04.627310' could not be parsed at index 0
 2024-10-29 09:53:42.295+08:00 WARN (stats-cache-refresher-5|109) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transferde_mv, column : RTD_TOLOTTABLE12, errMsg : Text 'ï¿½9ï¿½3-11-24' could not be parsed at index 0
 2024-10-29 09:53:45.007+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½3-11-24 19:05:19.476736' could not be parsed at index 0
 2024-10-29 09:53:58.200+08:00 WARN (stats-cache-refresher-7|111) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 M3:26:54.247440' could not be parsed at index 0
 2024-10-29 09:54:57.184+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():184] Min: 10134.0, Max: 2825.0 values abnormal for catalog : default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderType
 2024-10-29 09:54:57.185+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 08:21:04.771176' could not be parsed at index 0
 2024-10-29 09:54:57.185+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text 'ï¿½9ï¿½3-11-24 08:21:04.771079' could not be parsed at index 0
 2024-10-29 09:54:57.185+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderDate, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00' could not be parsed at index 0
 2024-10-29 09:55:11.550+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.010134' could not be parsed at index 0
 2024-10-29 09:55:11.551+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderDate, errMsg : Text '4472-09-05 61:04:47.256900' could not be parsed: Invalid value for HourOfDay (valid values 0 - 23): 61
 2024-10-29 09:55:11.551+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text '4296-01-19 58:41:52.334925' could not be parsed: Invalid value for HourOfDay (valid values 0 - 23): 58
 2024-10-29 09:55:11.551+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():184] Min: 1.88978561068E11, Max: 0.0 values abnormal for catalog : default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderType
 2024-10-29 09:56:42.334+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text '?278-09-14 <5:48:45.219184' could not be parsed at index 0
 2024-10-29 09:56:42.334+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():184] Min: 4.294967296E9, Max: 0.0 values abnormal for catalog : default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderType
 2024-10-29 09:56:42.334+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00' could not be parsed at index 0
 2024-10-29 09:56:42.334+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderDate, errMsg : Text 'ï¿½9ï¿½3-11-25 01:11:41.614433' could not be parsed at index 0
 2024-10-29 09:56:56.202+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():184] Min: 4.294967296E9, Max: 0.0 values abnormal for catalog : default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderType
 2024-10-29 09:56:56.202+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.000002' could not be parsed at index 0
 2024-10-29 09:56:56.202+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderDate, errMsg : Text 'ï¿½9ï¿½4-03-30 @3:41:40.518913' could not be parsed at index 0
 2024-10-29 09:56:56.203+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.010134' could not be parsed at index 0
 2024-10-29 09:57:34.780+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00' could not be parsed at index 0
 2024-10-29 09:57:34.780+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.010134' could not be parsed at index 0
 2024-10-29 09:57:34.780+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderDate, errMsg : Text 'ï¿½9ï¿½4-03-30 89:28:42.547202' could not be parsed at index 0
 2024-10-29 09:58:06.868+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderDate, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.010134' could not be parsed at index 0
 2024-10-29 09:58:06.869+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():184] Min: 8.0280758070386606E18, Max: 0.0 values abnormal for catalog : default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderType
 2024-10-29 09:58:06.869+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.282257' could not be parsed at index 0
 2024-10-29 09:58:06.869+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text '5191-10-27 58:41:52.334925' could not be parsed: Invalid value for HourOfDay (valid values 0 - 23): 58
 2024-10-29 09:58:17.251+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text 'ï¿½9ï¿½3-11-24 07:09:29.803780' could not be parsed at index 0
 2024-10-29 09:58:17.251+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderDate, errMsg : Text 'ï¿½9ï¿½4-03-30 M2:52:37.308160' could not be parsed at index 0
 2024-10-29 09:58:17.251+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text '?278-09-14 <5:48:45.219184' could not be parsed at index 0
 2024-10-29 09:58:22.058+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00' could not be parsed at index 0
 2024-10-29 09:58:22.059+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : crmOrderDate, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.000005' could not be parsed at index 0
 2024-10-29 09:58:22.059+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text 'ï¿½9ï¿½4-03-30 @3:29:38.896192' could not be parsed at index 0
 2024-10-29 09:58:54.590+08:00 WARN (stats-cache-refresher-0|104) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.010134' could not be parsed at index 0
 2024-10-29 09:58:54.591+08:00 WARN (stats-cache-refresher-0|104) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text 'ï¿½9ï¿½3-11-24 07:09:29.803776' could not be parsed at index 0
 2024-10-29 09:59:05.989+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 01:11:34.967296' could not be parsed at index 0
 2024-10-29 09:59:05.989+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text 'ï¿½9ï¿½3-11-24 07:09:29.803779' could not be parsed at index 0
 2024-10-29 09:59:11.248+08:00 WARN (stats-cache-refresher-2|106) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : packageExpectedArrivalDate, errMsg : Text 'ï¿½9ï¿½4-03-30 91:15:57.747648' could not be parsed at index 0
 2024-10-29 09:59:11.248+08:00 WARN (stats-cache-refresher-2|106) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.010134' could not be parsed at index 0
 2024-10-29 09:59:48.167+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'F006-02-10 A1:40:32.513000' could not be parsed at index 0
 2024-10-29 09:59:57.787+08:00 WARN (stats-cache-refresher-5|109) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½4-03-30 90:44:08.943616' could not be parsed at index 0
 2024-10-29 10:00:03.729+08:00 WARN (stats-cache-refresher-8|112) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dws_pms_demand_item_row_mv, column : lockedAt, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.010134' could not be parsed at index 0
 2024-10-29 10:00:42.885+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 @2:02:15.809168' could not be parsed at index 0
 2024-10-29 10:01:31.997+08:00 WARN (stats-cache-refresher-2|106) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.014385' could not be parsed at index 0
 2024-10-29 10:02:03.928+08:00 WARN (stats-cache-refresher-7|111) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'M001-11-22 E7:00:56.931556' could not be parsed at index 0
 2024-10-29 10:02:30.765+08:00 WARN (stats-cache-refresher-4|108) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½1ï¿½3-05-01 00:00:00' could not be parsed at index 0
 2024-10-29 10:03:00.470+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½3-11-24 00:00:00.143460' could not be parsed at index 0
 2024-10-29 10:03:27.879+08:00 WARN (stats-cache-refresher-2|106) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 00:28:04.627310' could not be parsed at index 0
 2024-10-29 10:03:55.750+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 90:35:50.963200' could not be parsed at index 0
 2024-10-29 10:04:03.131+08:00 WARN (stats-cache-refresher-4|108) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 90:41:07.846144' could not be parsed at index 0
 2024-10-29 10:10:19.856+08:00 WARN (stats-cache-refresher-9|113) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 M2:26:01.885696' could not be parsed at index 0
 2024-10-29 10:11:04.630+08:00 WARN (stats-cache-refresher-1|105) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 89:28:42.547202' could not be parsed at index 0
 2024-10-29 10:11:30.126+08:00 WARN (stats-cache-refresher-9|113) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'M001-11-22 E7:00:56.931556' could not be parsed at index 0
 2024-10-29 10:12:02.841+08:00 WARN (stats-cache-refresher-4|108) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 90:17:18.372176' could not be parsed at index 0
 2024-10-29 10:12:27.853+08:00 WARN (stats-cache-refresher-7|111) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½3-11-24 00:02:24.703488' could not be parsed at index 0
 2024-10-29 10:12:53.459+08:00 WARN (stats-cache-refresher-6|110) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 @1:08:28.481024' could not be parsed at index 0
 2024-10-29 10:13:22.458+08:00 WARN (stats-cache-refresher-4|108) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'ï¿½9ï¿½4-03-30 @2:15:45.357712' could not be parsed at index 0
 2024-10-29 10:13:36.932+08:00 WARN (stats-cache-refresher-3|107) [ColumnBasicStatsCacheLoader.buildColumnStatistics():179] convert TStatisticData to ColumnStatistics failed, catalog: default_catalog, db : scm, table : dwd_wms_rtx_transfer_detail_mv, column : RT_DETAIL_EFFECTIVEDATE, errMsg : Text 'A252-06-12 ;3:47:36.910180' could not be parsed at index 0

murphyatwork commented 4 weeks ago

which version can reproduce this bug ?

bulolo commented 4 weeks ago

which version can reproduce this bug ?

3.3.5 and 3.3.4

StarRocks / starrocks

mv convert TStatisticData to ColumnStatistics failed #52360