Shaurya Goel
11/03/2025, 4:11 PMselect COUNT(*) from shs where to_date(shs.created_at) >= '2025-09-24' LIMIT 2;
ERROR 1064 (HY000): load_segments failed tablet:271529807 rowset:366 segid:0: starlet err [RequestID=18748A228868A193][StatusCode=404]Get object <s3://starrocks-data-store/data-science/39a98ed0-4905-48eb-b4fd-6543f3264afa/db437986/563781/271529802/data/000000000d2ef076_1a66197f-245f-406a-9258-2fc98c3ec249.dat> error: The specified key does not exist.:
Common causes for this error are:
1. A schema change has been made to the table
2. The current query is a slow query
For the first case, you can retry the current query.
For the
However, the query works fine-
select COUNT(*) from shs where to_date(shs.created_at) >= '2025-09-25' LIMIT 2;
I think something happened with the data on '2025-09-24' . Can someone help on debugging this?jeff.ding
11/07/2025, 1:41 AMShaurya Goel
11/10/2025, 9:11 AMCREATE TABLE `service_history_summarization` (
`created_at` datetime NULL COMMENT "",
`registration_number` varchar(65533) NULL COMMENT "",
`make` varchar(65533) NULL COMMENT "",
`status` varchar(65533) NULL COMMENT "",
`message` varchar(65533) NULL COMMENT "",
`input_path` varchar(65533) NULL COMMENT "",
`output` json NULL COMMENT "",
`env` varchar(65533) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`created_at`, `registration_number`, `make`, `status`)
COMMENT "OLAP"
PARTITION BY date_trunc('DAY', created_at)
DISTRIBUTED BY HASH(`registration_number`)
PROPERTIES (
"replication_num" = "1",
"datacache.partition_duration" = "3 days",
"datacache.enable" = "true",
"storage_volume" = "starrocks_prod_ds",
"enable_async_write_back" = "false",
"enable_persistent_index" = "true",
"persistent_index_type" = "LOCAL",
"compression" = "LZ4"
);Shaurya Goel
11/10/2025, 9:12 AMShaurya Goel
11/13/2025, 6:28 AMShaurya Goel
11/23/2025, 4:26 AM