查询impala-query概览

最近更新时间: 2026-09-17 00:05:46

1. 接口描述

接口请求域名: tbdsnew.api3.fincloud.tencent.cn。

在impala组件的查询管理的查询列表的总览入口,查询的是该次查询的统计信息

默认接口请求频率限制:20次/秒。

接口更新时间:2024-11-01 12:22:14。

接口既验签名又鉴权。

2. 输入参数

以下请求参数列表仅列出了接口请求参数和部分公共参数,完整公共参数列表见公共请求参数

参数名称 必选 允许NULL 类型 描述
Action String 公共参数,本接口取值:DescribeImpalaQueryOverview
Version String 公共参数,本接口取值:2019-01-03
Region String 公共参数,地域信息可通过DescribeRegions接口查看产品支持的地域列表
InstanceId String 集群实例ID
示例值: tbds-1vzudj86
QueryId String 查询sql Id
示例值: 0a4fd351ce2eac59:b74ab71900000000

3. 输出参数

参数名称 类型 描述
QueryCompilation Array of TimeLineItem QueryCompilation各个阶段
注意:此字段可能返回 null,表示取不到有效值。
示例值:查看
QueryTimeline Array of TimeLineItem QueryTimeline各个阶段
注意:此字段可能返回 null,表示取不到有效值。
示例值:查看
Metrics Array of MetricItem 指标
注意:此字段可能返回 null,表示取不到有效值。
示例值:查看
RequestId String 唯一请求 ID,每次请求都会返回。定位问题时需要提供该次请求的 RequestId。

4. 错误码

以下仅列出了接口业务逻辑相关的错误码,其他错误码详见公共错误码

错误码 描述
InternalError 内部错误。
InternalError.EMRCCException EMRCC异常。
InvalidParameter.ImpalaQueryException impala查询参数异常。
ResourceNotFound.MetricsMetaNotFound 无法找到监控元数据。
ResourceNotFound.ClusterNotFound 无法找到该实例。

5. 示例

示例1 查询impala query 概览

输入示例

POST / HTTP/1.1
Host: tbdsnew.api3.{conf.main_domain}
Content-Type: application/json
X-TC-Action: DescribeImpalaQueryOverview
<公共请求参数>

{
  "InstanceId": "tbds-1vzudj86",
  "QueryId": "0a4fd351ce2eac59:b74ab71900000000"
}

输出示例

{
  "Response": {
    "Metrics": [
      {
        "Name": "Estimated Per-Host Mem",
        "Value": "3735617710"
      },
      {
        "Name": "Request Pool",
        "Value": "default-pool"
      },
      {
        "Name": "Admission result",
        "Value": "Admitted immediately"
      },
      {
        "Name": "Cluster Memory Admitted",
        "Value": "17.40 GB"
      },
      {
        "Name": "Executor Group",
        "Value": "default"
      },
      {
        "Name": "ClientFetchWaitTimer",
        "Value": "20.000ms"
      },
      {
        "Name": "NumRowsFetched",
        "Value": "1 (1)"
      },
      {
        "Name": "NumRowsFetchedFromCache",
        "Value": "0 (0)"
      },
      {
        "Name": "RowMaterializationRate",
        "Value": "14.00 /sec"
      },
      {
        "Name": "RowMaterializationTimer",
        "Value": "70.000ms"
      },
      {
        "Name": "ExchangeScanRatio",
        "Value": "0.45"
      },
      {
        "Name": "FiltersReceived",
        "Value": "5 (5)"
      },
      {
        "Name": "FinalizationTimer",
        "Value": "0.000ns"
      },
      {
        "Name": "InnerNodeSelectivityRatio",
        "Value": "0.00"
      },
      {
        "Name": "NumBackends",
        "Value": "5 (5)"
      },
      {
        "Name": "NumCompletedBackends",
        "Value": "5 (5)"
      },
      {
        "Name": "NumFragmentInstances",
        "Value": "499 (499)"
      },
      {
        "Name": "NumFragments",
        "Value": "13 (13)"
      },
      {
        "Name": "TotalBytesRead",
        "Value": "55.98 MB (58694173)"
      },
      {
        "Name": "TotalBytesSent",
        "Value": "25.38 MB (26613099)"
      },
      {
        "Name": "TotalCpuTime",
        "Value": "12s731ms"
      },
      {
        "Name": "TotalInnerBytesSent",
        "Value": "1.17 KB (1200)"
      },
      {
        "Name": "TotalScanBytesSent",
        "Value": "25.38 MB (26611899)"
      }
    ],
    "QueryCompilation": [
      {
        "Name": "Metadata load started",
        "Duration": "2.741ms",
        "StartTime": 0,
        "EndTime": 2.74,
        "StartTimeDesc": "0",
        "EndTimeDesc": "2.741ms"
      },
      {
        "Name": "Metadata load finished. loaded-tables=1/5 load-requests=1 catalog-updates=3 storage-load-time=1ms",
        "Duration": "3s494ms",
        "StartTime": 2.74,
        "EndTime": 3497,
        "StartTimeDesc": "2.741ms",
        "EndTimeDesc": "3s497ms"
      },
      {
        "Name": "Analysis finished",
        "Duration": "12.374ms",
        "StartTime": 3497,
        "EndTime": 3509,
        "StartTimeDesc": "3s497ms",
        "EndTimeDesc": "3s509ms"
      },
      {
        "Name": "Authorization finished (ranger)",
        "Duration": "1.358ms",
        "StartTime": 3509,
        "EndTime": 3510,
        "StartTimeDesc": "3s509ms",
        "EndTimeDesc": "3s510ms"
      },
      {
        "Name": "Value transfer graph computed",
        "Duration": "199.810us",
        "StartTime": 3510,
        "EndTime": 3510,
        "StartTimeDesc": "3s510ms",
        "EndTimeDesc": "3s510ms"
      },
      {
        "Name": "Single node plan created",
        "Duration": "323.287ms",
        "StartTime": 3510,
        "EndTime": 3834,
        "StartTimeDesc": "3s510ms",
        "EndTimeDesc": "3s834ms"
      },
      {
        "Name": "Runtime filters computed",
        "Duration": "2.800ms",
        "StartTime": 3834,
        "EndTime": 3837,
        "StartTimeDesc": "3s834ms",
        "EndTimeDesc": "3s837ms"
      },
      {
        "Name": "Distributed plan created",
        "Duration": "22.470us",
        "StartTime": 3837,
        "EndTime": 3837,
        "StartTimeDesc": "3s837ms",
        "EndTimeDesc": "3s837ms"
      },
      {
        "Name": "Parallel plans created",
        "Duration": "17.430us",
        "StartTime": 3837,
        "EndTime": 3837,
        "StartTimeDesc": "3s837ms",
        "EndTimeDesc": "3s837ms"
      },
      {
        "Name": "Planning finished",
        "Duration": "11.154ms",
        "StartTime": 3837,
        "EndTime": 3848,
        "StartTimeDesc": "3s837ms",
        "EndTimeDesc": "3s848ms"
      }
    ],
    "QueryTimeline": [
      {
        "Name": "Query submitted",
        "Duration": "0.000ns",
        "StartTime": 0,
        "EndTime": 0,
        "StartTimeDesc": "0",
        "EndTimeDesc": "0.000ns"
      },
      {
        "Name": "Planning finished",
        "Duration": "3s870ms",
        "StartTime": 0,
        "EndTime": 3870,
        "StartTimeDesc": "0.000ns",
        "EndTimeDesc": "3s870ms"
      },
      {
        "Name": "Submit for admission",
        "Duration": "0.000ns",
        "StartTime": 3870,
        "EndTime": 3870,
        "StartTimeDesc": "3s870ms",
        "EndTimeDesc": "3s870ms"
      },
      {
        "Name": "Completed admission",
        "Duration": "30.000ms",
        "StartTime": 3870,
        "EndTime": 3900,
        "StartTimeDesc": "3s870ms",
        "EndTimeDesc": "3s900ms"
      },
      {
        "Name": "Ready to start on 5 backends",
        "Duration": "30.000ms",
        "StartTime": 3900,
        "EndTime": 3930,
        "StartTimeDesc": "3s900ms",
        "EndTimeDesc": "3s930ms"
      },
      {
        "Name": "All 5 execution backends (499 fragment instances) started",
        "Duration": "20.000ms",
        "StartTime": 3930,
        "EndTime": 3950,
        "StartTimeDesc": "3s930ms",
        "EndTimeDesc": "3s950ms"
      },
      {
        "Name": "First dynamic filter received",
        "Duration": "9s750ms",
        "StartTime": 3950,
        "EndTime": 13700,
        "StartTimeDesc": "3s950ms",
        "EndTimeDesc": "13s700ms"
      },
      {
        "Name": "Rows available",
        "Duration": "10.000ms",
        "StartTime": 13700,
        "EndTime": 13710,
        "StartTimeDesc": "13s700ms",
        "EndTimeDesc": "13s710ms"
      },
      {
        "Name": "First row fetched",
        "Duration": "10.000ms",
        "StartTime": 13710,
        "EndTime": 13720,
        "StartTimeDesc": "13s710ms",
        "EndTimeDesc": "13s720ms"
      },
      {
        "Name": "Last row fetched",
        "Duration": "0.000ns",
        "StartTime": 13720,
        "EndTime": 13720,
        "StartTimeDesc": "13s720ms",
        "EndTimeDesc": "13s720ms"
      },
      {
        "Name": "Released admission control resources",
        "Duration": "70.000ms",
        "StartTime": 13720,
        "EndTime": 13790,
        "StartTimeDesc": "13s720ms",
        "EndTimeDesc": "13s790ms"
      },
      {
        "Name": "Unregister query",
        "Duration": "10.000ms",
        "StartTime": 13790,
        "EndTime": 13800,
        "StartTimeDesc": "13s790ms",
        "EndTimeDesc": "13s800ms"
      }
    ],
    "RequestId": "d76a1666-a7ab-4822-8bfb-3b9483a0b7ec"
  }
}