Table Query Plan Action

Request

POST /api/<db>/<table>/_query_plan

Description

给定一个 SQL，用于获取该 SQL 对应的查询计划。

该接口目前用于 Spark-Doris-Connector 中，Spark 获取 Doris 的查询计划。

Path parameters

  • <db>

指定数据库 - <table>

指定表

Query parameters

无

Request body

1. {
2. "sql": "select * from db1.tbl1;"
3. }

Response

1. {
2. "msg": "success",
3. "code": 0,
4. "data": {
5. "partitions": {
6. "10039": {
7. "routings": ["10.81.85.89:9062"],
8. "version": 2,
9. "versionHash": 982459448378619656,
10. "schemaHash": 1294206575
11. }
12. },
13. "opaqued_query_plan": "DAABDAACDwABDAAAAAEIAAEAAAAACAACAAAAAAgAAwAAAAAKAAT//////////w8ABQgAAAABAAAAAA8ABgIAAAABAAIACAAMABIIAAEAAAAADwACCwAAAAIAAAACazEAAAACazIPAAMIAAAAAgAAAAUAAAAFAgAEAQAAAA8ABAwAAAACDwABDAAAAAEIAAEAAAAQDAACDwABDAAAAAEIAAEAAAAADAACCAABAAAABQAAAAgABAAAAAAMAA8IAAEAAAAACAACAAAAAAAIABT/////CAAX/////wAADwABDAAAAAEIAAEAAAAQDAACDwABDAAAAAEIAAEAAAAADAACCAABAAAABQAAAAgABAAAAAAMAA8IAAEAAAABCAACAAAAAAAIABT/////CAAX/////wAADAAFCAABAAAABgwACAAADAAGCAABAAAAAA8AAgwAAAAAAAoABwAAAAAAAAAACgAIAAAAAAAAAAAADQACCgwAAAABAAAAAAAAJzcKAAEAAAAAAAAnNwoAAgAAAAAAAAACCgADDaJlqbrVdwgIAARNJAZvAAwAAw8AAQwAAAACCAABAAAAAAgAAgAAAAAMAAMPAAEMAAAAAQgAAQAAAAAMAAIIAAEAAAAFAAAACAAE/////wgABQAAAAQIAAYAAAAACAAHAAAAAAsACAAAAAJrMQgACQAAAAACAAoBAAgAAQAAAAEIAAIAAAAADAADDwABDAAAAAEIAAEAAAAADAACCAABAAAABQAAAAgABP////8IAAUAAAAICAAGAAAAAAgABwAAAAELAAgAAAACazIIAAkAAAABAgAKAQAPAAIMAAAAAQgAAQAAAAAIAAIAAAAMCAADAAAAAQoABAAAAAAAACc1CAAFAAAAAgAPAAMMAAAAAQoAAQAAAAAAACc1CAACAAAAAQgAAwAAAAIIAAQAAAAACwAHAAAABHRibDELAAgAAAAADAALCwABAAAABHRibDEAAAAMAAQKAAFfL5rpxl1I4goAArgs6f+h6eMxAAA=",
14. "status": 200
15. },
16. "count": 0
17. }

其中 opaqued_query_plan 为查询计划的二进制格式。

Examples

  1. 获取指定 sql 的查询计划

``` 1. POST /api/db1/tbl1/_query_plan 2. { 3. "sql": "select * from db1.tbl1;" 4. }

  1. Response:
  2. {
  3. "msg": "success",
  4. "code": 0,
  5. "data": {
  6. "partitions": {
  7. "10039": {
  8. "routings": ["192.168.1.1:9060"],
  9. "version": 2,
  10. "versionHash": 982459448378619656,
  11. "schemaHash": 1294206575
  12. }
  13. },
  14. "opaqued_query_plan": "DAABDAACDwABD...",
  15. "status": 200
  16. },
  17. "count": 0
  18. } ```