Snippets

Nudge Errors

Created by Izac Hancock
errors.txt
Raw 
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
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)

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.