Cross join is taken to much time to execute in clickhouse
The calldetails table is receiving live data. a view was constructed that would accept any data that is added to calldetails and use those records. Our view generates 30 minute time segments for that day using those records. For instance, 00:00:00 – 00:29:00, 00:30:00 – 00:59:00, and so on, all the way up to 23:30:00 […]