for example, in my clickhouse instance, there is 4 rows
uuid | time | counter
333 | 13:13:13 | 13
333 | 13:13:15 | 133
3333 | 23:23:23 | 23
3333 | 23:23:25 | 233
how to split the 2 time range rows to serials second level rows, such as
uuid | time | counter
333 | 13:13:13 | (133-13)/3
333 | 13:13:14 | (133-13)/3
333 | 13:13:15 | (133-13)/3
3333 | 23:23:23 | (233-23)/3
3333 | 23:23:23 | (233-23)/3
3333 | 23:23:25 | (233-23)/3
scan the clickhouse time serials function, but not found the solution.
New contributor
user21923632 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.