Pavel Konstantinov
05/31/2024, 8:53 AM2024.05.31 08:47:24.506741 [ 666 ] {6345e71c-4a66-492f-88ab-e0242a325b9c} <Error> DDLWorker: Query /* ddl_entry=query-0000000184 */ ALTER TABLE signoz_metrics.time_series_v4_1day MODIFY TTL toDateTime(toUInt32(timestamp_ms / 1000), 'UTC') + toIntervalSecond(5184000), toDateTime(toUInt32(timestamp_ms / 1000), 'UTC') + toIntervalSecond(1209600) TO VOLUME 's3' wasn't finished successfully: Code: 47. DB::Exception: Missing columns: 'timestamp_ms' while processing query: 'toDateTime(toUInt32(timestamp_ms / 1000), 'UTC') + toIntervalSecond(5184000)', required columns: 'timestamp_ms' 'timestamp_ms'. (UNKNOWN_IDENTIFIER), Stack trace (when copying this message, always include the lines below):
Also I must note that I was able to change retention for Logs and Traces successfully.Srikanth Chekuri
05/31/2024, 9:22 AMPavel Konstantinov
05/31/2024, 9:39 AMHerb He
06/02/2024, 3:26 PM