This message was deleted.
# troubleshooting
s
This message was deleted.
j
pasted the full query here FWIW:
Copy code
{
  "queryType": "topN",
  "dataSource": {
    "type": "union",
    "dataSources": [
      {
        "type": "table",
        "name": "dsp_perf"
      },
      {
        "type": "table",
        "name": "dsp_hha_impressions"
      }
    ]
  },
  "virtualColumns": [],
  "dimension": {
    "type": "LegacyDimensionSpec",
    "dimension": "line_id",
    "outputName": "line_id",
    "outputType": "STRING"
  },
  "metric": {
    "type": "numeric",
    "metric": "advertiser_cost"
  },
  "threshold": 10000,
  "intervals": {
    "type": "LegacySegmentSpec",
    "intervals": [
      "2022-12-15T05:00:00.000Z/2022-12-16T04:59:59.000Z"
    ]
  },
  "filter": {
    "type": "and",
    "fields": [
      {
        "type": "or",
        "fields": [
          {
            "type": "selector",
            "dimension": "order_id",
            "value": "455853",
            "extractionFn": null
          }
        ]
      },
      {
        "type": "or",
        "fields": [
          {
            "type": "selector",
            "dimension": "valid",
            "value": "1",
            "extractionFn": null
          },
          {
            "type": "selector",
            "dimension": "valid",
            "value": null,
            "extractionFn": null
          },
          {
            "type": "selector",
            "dimension": "valid",
            "value": "true",
            "extractionFn": null
          }
        ]
      },
      {
        "type": "not",
        "field": {
          "type": "or",
          "fields": [
            {
              "type": "selector",
              "dimension": "event_type",
              "value": "4",
              "extractionFn": null
            }
          ]
        }
      },
      {
        "type": "or",
        "fields": [
          {
            "type": "selector",
            "dimension": "seat_id",
            "value": "3331",
            "extractionFn": null
          }
        ]
      }
    ]
  },
  "granularity": {
    "type": "all"
  },
  "aggregations": [
    {
      "type": "doubleSum",
      "name": "advertiser_cost",
      "fieldName": "advertiser_cost",
      "expression": null
    }
  ],
  "postAggregations": [],
  "context": {
    "priority": 0,
    "queryId": "topN_union_request_1",
    "timeout": 20000
  },
  "descending": false
}
@Karan Kumar this is why @Ashwin Tumma want to confirm/extract the start time from request log, sorry for being a bit spammy but I want to create a separate thread for the timed out issue just for visibility.