SELECT
"insights".device "insights__device", "insights".owner "insights__owner", "insights".url "insights__url", timestamp_floor('d', to_timezone("insights".created, 'UTC')) "insights__created_day", avg(CASE WHEN impressions > 0 THEN time_spent / impressions ELSE 0 END) "insights__average_attention", sum("insights".earned_int) "insights__earned_impressions", count_distinct(uuid) "insights__people"
FROM
(
SELECT
ingest_impressions.created,
ingest_impressions.owner,
ingest_impressions.impressionid,
ingest_impressions.uuid,
ingest_impressions.url,
ingest_impressions.trafficsource,
CAST(ingest_impressions.earned AS INT) as earned_int,
ingest_impressions.device,
ingest_impressions.city,
ingest_impressions.country,
MAX(ingest_impressions.isimpression) AS impressions,
SUM(ingest_impressions.timespent) AS time_spent,
SUM(ingest_impressions.scrolled) AS scrolled
FROM
ingest_impressions
GROUP BY
ingest_impressions.created,
ingest_impressions.owner,
ingest_impressions.impressionid,
ingest_impressions.uuid,
ingest_impressions.url,
ingest_impressions.trafficsource,
ingest_impressions.earned,
ingest_impressions.device,
ingest_impressions.city,
ingest_impressions.country
) AS "insights" GROUP BY "insights__device", "insights__owner", "insights__url", "insights__created_day"
--
{
"queryKey": [
[
"CREATE TABLE dev_pre_aggregations.insights_top_devices AS SELECT\n \"insights\".device \"insights__device\", \"insights\".owner \"insights__owner\", \"insights\".url \"insights__url\", timestamp_floor('d', to_timezone(\"insights\".created, 'UTC')) \"insights__created_day\", avg(CASE WHEN impressions > 0 THEN time_spent / impressions ELSE 0 END) \"insights__average_attention\", sum(\"insights\".earned_int) \"insights__earned_impressions\", count_distinct(uuid) \"insights__people\"\n FROM\n (\n SELECT\n ingest_impressions.created,\n ingest_impressions.owner,\n ingest_impressions.impressionid,\n ingest_impressions.uuid,\n ingest_impressions.url,\n ingest_impressions.trafficsource,\n CAST(ingest_impressions.earned AS INT) as earned_int,\n ingest_impressions.device,\n ingest_impressions.city,\n ingest_impressions.country,\n MAX(ingest_impressions.isimpression) AS impressions,\n SUM(ingest_impressions.timespent) AS time_spent,\n SUM(ingest_impressions.scrolled) AS scrolled\n FROM\n ingest_impressions\n GROUP BY\n ingest_impressions.created,\n ingest_impressions.owner,\n ingest_impressions.impressionid,\n ingest_impressions.uuid,\n ingest_impressions.url,\n ingest_impressions.trafficsource,\n ingest_impressions.earned,\n ingest_impressions.device,\n ingest_impressions.city,\n ingest_impressions.country\n ) AS \"insights\" GROUP BY \"insights__device\", \"insights__owner\", \"insights__url\", \"insights__created_day\"",
[]
],
[
[
{
"refresh_key": "471261"
}
]
]
],
"targetTableName": "dev_pre_aggregations.insights_top_devices_bsye2kwd_fo0du3xp_1ihu94e",
"newVersionEntry": {
"table_name": "dev_pre_aggregations.insights_top_devices",
"structure_version": "fo0du3xp",
"content_version": "bsye2kwd",
"last_updated_at": 1696539790791,
"naming_version": 2
}
}
Error: Connection terminated unexpectedly
at Connection.<anonymous> (/cube/node_modules/@cubejs-backend/questdb-driver/node_modules/pg/lib/client.js:132:73)
at Object.onceWrapper (node:events:627:28)
at Connection.emit (node:events:513:28)
at TLSSocket.<anonymous> (/cube/node_modules/@cubejs-backend/questdb-driver/node_modules/pg/lib/connection.js:107:12)
at TLSSocket.emit (node:events:525:35)
at endReadableNT (node:internal/streams/readable:1358:12)
at processTicksAndRejections (node:internal/process/task_queues:83:21)
Error while querying: scheduler-4feaf296-2ed5-4931-9e53-9e5f63067651 (14803ms)