I am working on some time-series data, say the memory usage of some application, with Clickhouse. To analyze the historic trending of the data, I store the historic data in a table, with some schema like:

I am working on some time-series data, say the memory usage of some application, with Clickhouse. To analyze the historic trending of the data, I store the historic data in a table, with some schema like:

I’m trying to create a time table on the ClickHouse. This is a simple table consisting of 4 fields.
The first field shows the date + time in one minute increments ranging from 00:00:00 to 23:59:00.
The second field shows the hour in 24 format.
The third field shows minutes in the range from 00 to 59.
The fourth field indicates the time of day: morning, afternoon, evening.

for example, in my clickhouse instance, there is 4 rows

I’m trying to join two log tables with clickhouse to get one table with all events and ordered by event_date.
The first table

I have this query in postgresql:

I have a Clickhouse table having multiple Array columns, such as

I can’t seem to get the groupArrayInsertAt aggregation function to work on Clickhouse. I am passing zero as the second argument which is position, but it keeps throwing an error.