查询impala-profile树形节点内容

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

1. 接口描述

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

在impala组件的查询管理的查询列表的详情入口，查询树形节点的元数据信息，包括查询语句、查询状态、查询耗时，时区等

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

接口更新时间：2024-11-01 12:17:24。

接口既验签名又鉴权。

2. 输入参数

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

参数名称 必选 允许NULL 类型 描述
Action 是 否 String 公共参数，本接口取值：DescribeImpalaProfileTreeNode
Version 是 否 String 公共参数，本接口取值：2019-01-03
Region 是 否 String 公共参数，地域信息可通过DescribeRegions接口查看产品支持的地域列表
InstanceId 是 否 String 集群Id
示例值： tbds-1vzudj86
ImpalaQueryId 是 否 String impala作业Id
示例值： 0a4fd351ce2eac59:b74ab71900000000
StartTime 是 否 String impala作业开始时间
示例值： 2025-05-26 17:41:01.799
NodeId 是 否 String 节点ID
示例值： 1

3. 输出参数

参数名称 类型 描述
ImpalaProfileTreeNode String 树形节点内容
示例值： 1
RequestId String 唯一请求 ID，每次请求都会返回。定位问题时需要提供该次请求的 RequestId。

4. 错误码

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

错误码 描述
InvalidParameter.ImpalaQueryException impala查询参数异常。
InternalError.ClickHouseQueryException 查询ClickHouse异常。
ResourceNotFound.ClusterNotFound 无法找到该实例。

5. 示例

示例1 【监控】查询impala profile树形节点内容

输入示例

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

{
  "InstanceId": "tbds-1vzudj86",
  "ImpalaQueryId": "0a4fd351ce2eac59:b74ab71900000000",
  "StartTime": "2025-05-26 17:41:01.799",
  "NodeId": "1"
}

输出示例

{
  "Response": {
    "ImpalaProfileTreeNode": "{\"node_content\":\"   - InactiveTotalTime: 0.000ns\\n   - TotalTime: 0.000ns\\n  Summary:\\n    Session ID: 1746a9c0246e9ad9:c8018aaa94a33798\\n    Session Type: BEESWAX\\n    Start Time: 2025-05-26 17:41:01.799953000\\n    End Time: 2025-05-26 17:41:15.586715000\\n    Duration: 13s786ms (13786762 us)\\n    Query Type: QUERY\\n    Query State: FINISHED\\n    Impala Query State: FINISHED\\n    Query Status: OK\\n    Impala Version: impalad version 4.1.0 RELEASE (build 1d7b63102ebc8974e8133c964917ea8052148088)\\n    User: hadoop/tbds-172-16-0-71@TBDS-N5TFY9DC\\n    Connected User: hadoop/tbds-172-16-0-71@TBDS-N5TFY9DC\\n    Delegated User: \\n    Network Address: [::ffff:172.16.0.71]:58518\\n    Default Db: tpcds_hive_orc_2\\n    Sql Statement: -- start query 1 in stream 0 using template query16.tpl and seed 171719422\\nselect count(distinct cs_order_number) as `order count`\\n  ,sum(cs_ext_ship_cost) as `total shipping cost`\\n  ,sum(cs_net_profit) as `total net profit`\\nfrom\\n   catalog_sales cs1\\n  ,date_dim\\n  ,customer_address\\n  ,call_center\\nwhere\\n    d_date between '1999-4-01' and\\n           (cast('1999-4-01' as date) + interval 60 days)\\nand cs1.cs_ship_date_sk = d_date_sk\\nand cs1.cs_ship_addr_sk = ca_address_sk\\nand ca_state = 'IL'\\nand cs1.cs_call_center_sk = cc_call_center_sk\\nand cc_county in ('Richland County','Bronx County','Maverick County','Mesa County',\\n                  'Raleigh County'\\n)\\nand exists (select *\\n            from catalog_sales cs2\\n            where cs1.cs_order_number = cs2.cs_order_number\\n              and cs1.cs_warehouse_sk \\u003c\\u003e cs2.cs_warehouse_sk)\\nand not exists(select *\\n               from catalog_returns cr1\\n               where cs1.cs_order_number = cr1.cr_order_number)\\norder by count(distinct cs_order_number)\\nlimit 100\\n    Coordinator: tbds-172-16-0-117:27000\\n    Query Options (set by configuration): MT_DOP=16,TIMEZONE=,CLIENT_IDENTIFIER=Impala Shell v4.1.0 (1d7b631) built on Thu May  8 18:37:16 CST 2025\\n    Query Options (set by configuration and planner): MT_DOP=16,TIMEZONE=,CLIENT_IDENTIFIER=Impala Shell v4.1.0 (1d7b631) built on Thu May  8 18:37:16 CST 2025,MINMAX_FILTER_THRESHOLD=0.5,MINMAX_FILTERING_LEVEL=PAGE\\n\",\"node_id\":\"1\"}",
    "RequestId": "0a2d0989-da13-40fc-a67c-40cee1b971a8"
  }
}