Table Query Plan Action

Request

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

Description

Given a SQL, it is used to obtain the query plan corresponding to the SQL.

This interface is currently used in Spark-Doris-Connector, Spark obtains Doris’ query plan.

Path parameters

  • <db>

Specify database - <table>

Specify table

Query parameters

None

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

Among them, opaqued_query_plan is the binary format of the query plan.

Examples

  1. Get the query plan of the specified 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. } ```