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"
}
}