我遇到过GENERATE_DATE_ARRAY,并且能够在单个数组中创建我想要的日期。然而,将它们拆分到每行的单个日期...
@alexey-milovidov hey, I once encountered a use case, generate a date_array, but no matching udf found. Finally, i use range to implement, like this: WITH toUnixTimestamp(toDateTime(toStartOfInterval(toDateTime('2022-12-18 00:00:00'), interval 1 month))) as start, toUnixTimestamp(...