{"info":{"_postman_id":"3c57cad0-30f0-4003-b6c9-3b3fa04e5678","name":"Canner RESTful API V2","description":"

Authorization

To use the RESTful API V2, you must first obtain a Personal Access Token and attach it to the Request headers.

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Name	Format	Sample
Authorization	format(\"Token %s\", PAT)	Token asdsafgwg4gregregergergregerg32

Cache Control

When performing a Query using POST /query, two parameters can be used in the body to control the Query Cache:

cacheTTL: This value is in seconds and represents the maximum amount of time the Query Cache can tolerate. For example, if set to 3600 (seconds), if the Query Cache result exceeds 3600 seconds, the Query will be re-executed to fetch new data.
cacheRefresh: Boolean value, \"true\" or \"false\", indicating whether to ignore the Cache and re-execute the Query.

API Endpoint

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Mode	Endpoint
Standalone	https://api.mydomain.cannerdata.com/web/api/v2
Cluster	https://api.mydomain.cannerdata.com/api/v2

Params & Input

The data carried by the request is divided into 3 types:

Params: e.g. id in /resource/:id.
Query String: e.g. workspaceId in /resource?workspaceId=.
Input: Data in Request Body, unified as JSON Object.

Workspace ID

Operations under the workspace scope, such as Saved SQL, Materialized Views, and Queries, will require the workspaceId to be carried in params or request body. This ID can be found in the workspace.

\n\n

Query Execution Process

Reference

Canner Enterprise Restful API NodeJS Example (github.com)

Step

Execute a SQL query. (Use Create query API)
Use polling method to check the execution status of the query. (Use Get query information API)
After completing the above steps and the status changes to \"successful\", obtain the result of the query.
1. Use Get query result API to get the JSON result.
2. Use Get query result in urls API to get the http location of a parquet file, it can import into a Python enviroment to use.
\n

Errors

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Status	Description
400	Incorrect parameter format given by the user, e.g. `?limit=some-string` where `limit` must be a `number`.
401	Incorrect authentication information resulting in no permission to access the resource. For example, no `Authorization` header is included.
404	The given resource cannot be found.

Changelog

2023/04/25

1. Deprecated v2 API endpoints

Create query ( POST/queries )
Get query information ( GET/queries/:queryId )
Get query result (GET/queries/:queryId/result)

2. New v2 API endpoints

Create query ( POST/async-queries )
Get query information ( GET/async-queries/:queryId )
Get query result (GET/async-queries/:queryId/result)

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"21257531","collectionId":"3c57cad0-30f0-4003-b6c9-3b3fa04e5678","publishedId":"2s93CGSc5k","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2023-02-18T08:48:56.000Z"},"item":[{"name":"saved-sqls","item":[{"name":"id","item":[{"name":"Get saved sql","id":"035196f9-043d-4574-b8ce-b538d1e4fa63","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls/:id?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Get a saved sql

\n","urlObject":{"path":["saved-sqls",":id"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"f85db43d-68b0-43c2-9ba5-0e2ab5924159","description":{"content":"

(Required) id of saved sql

\n","type":"text/plain"},"type":"any","value":"6120b178-d898-a52b-4ec6-ad7a5082f18b","key":"id"}]}},"response":[{"id":"b314077a-e549-4228-8cab-b57e1bc7db57","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls/:id?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["saved-sqls",":id"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694","type":"text"}],"variable":[{"key":"id","value":"6120b178-d898-a52b-4ec6-ad7a5082f18b","description":"(Required) id of saved sql"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": \"0dcd0d31-debb-49c0-bff5-10c4652a8b0f\",\n \"title\": \"Query 12\",\n \"description\": \"\",\n \"sql\": \"select\\nlineitem_95227.shipmode,\\nsum(case\\nwhen orders_91318.orderpriority ='1-URGENT'\\nor orders_91318.orderpriority ='2-HIGH'\\nthen 1\\nelse 0\\nend) as high_line_count,\\nsum(case\\nwhen orders_91318.orderpriority <> '1-URGENT'\\nand orders_91318.orderpriority <> '2-HIGH'\\nthen 1\\nelse 0\\nend) as low_line_count\\n\\n\\nfrom\\norders_91318,lineitem_95227\\n\\n\\nwhere\\norders_91318.orderkey = lineitem_95227.orderkey\\nand lineitem_95227.shipmode in ('MAIL', 'SHIP') \\nand lineitem_95227.commitdate < lineitem_95227.receiptdate\\nand lineitem_95227.shipdate < lineitem_95227.commitdate\\nand lineitem_95227.receiptdate >= date '1994-01-01' \\nand lineitem_95227.receiptdate < date '1994-01-01' + interval '1' year\\ngroup by\\nlineitem_95227.shipmode\\norder by\\nlineitem_95227.shipmode\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\"\n}"}],"_postman_id":"035196f9-043d-4574-b8ce-b538d1e4fa63"},{"name":"Delete saved sql","id":"7129fa7a-dfa4-4637-8346-f51e4947962e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls/:id?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Delete a saved sql

\n","urlObject":{"path":["saved-sqls",":id"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"680d1bfd-977f-4f43-ba87-62151a94543d","description":{"content":"

(Required) the id of saved sql

\n","type":"text/plain"},"type":"any","value":"6120b178-d898-a52b-4ec6-ad7a5082f18b","key":"id"}]}},"response":[{"id":"14803ed3-59b9-48fd-a429-383534731290","name":"OK","originalRequest":{"method":"DELETE","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls/:id?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["saved-sqls",":id"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694","type":"text"}],"variable":[{"key":"id","value":"6120b178-d898-a52b-4ec6-ad7a5082f18b","description":"(Required) the id of saved sql"}]}},"status":"OK","code":200,"_postman_previewlanguage":"text","header":[{"key":"Content-Type","value":"text/plain"}],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"7129fa7a-dfa4-4637-8346-f51e4947962e"},{"name":"Execute saved sql","id":"d21437e3-7b65-4074-a293-9da32841b0cc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"cacheTTL\": 86400,\n \"cacheRefresh\": false\n}","options":{"raw":{"language":"json"}}},"url":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls/:id/query?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Execute a saved sql

\n","urlObject":{"path":["saved-sqls",":id","query"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"8e08cb6e-13a4-4faf-b5b6-2fcc1d580a78","description":{"content":"

(Required) the id of saved sql

\n","type":"text/plain"},"type":"any","value":"6120b178-d898-a52b-4ec6-ad7a5082f18b","key":"id"}]}},"response":[{"id":"6ceca444-11cd-4b8b-b923-36201ad5238d","name":"OK","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"cacheTTL\": 86400,\n \"cacheRefresh\": false\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls/:id/query?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["saved-sqls",":id","query"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694","type":"text"}],"variable":[{"key":"id","value":"6120b178-d898-a52b-4ec6-ad7a5082f18b","description":"(Required) the id of saved sql"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": \"f7bbfb5f-9b92-4602-94b1-c39a489ae990\",\n \"sql\": \"select\\nlineitem_95227.shipmode,\\nsum(case\\nwhen orders_91318.orderpriority ='1-URGENT'\\nor orders_91318.orderpriority ='2-HIGH'\\nthen 1\\nelse 0\\nend) as high_line_count,\\nsum(case\\nwhen orders_91318.orderpriority <> '1-URGENT'\\nand orders_91318.orderpriority <> '2-HIGH'\\nthen 1\\nelse 0\\nend) as low_line_count\\n\\n\\nfrom\\norders_91318,lineitem_95227\\n\\n\\nwhere\\norders_91318.orderkey = lineitem_95227.orderkey\\nand lineitem_95227.shipmode in ('MAIL', 'SHIP') \\nand lineitem_95227.commitdate < lineitem_95227.receiptdate\\nand lineitem_95227.shipdate < lineitem_95227.commitdate\\nand lineitem_95227.receiptdate >= date '1994-01-01' \\nand lineitem_95227.receiptdate < date '1994-01-01' + interval '1' year\\ngroup by\\nlineitem_95227.shipmode\\norder by\\nlineitem_95227.shipmode\",\n \"statementId\": \"20230217_124001_00015_262sd\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"userId\": \"377e8838-8c6f-45df-801d-3604c130a5ab\",\n \"userType\": \"BASIC_USER\",\n \"source\": null,\n \"fromCache\": true,\n \"status\": \"FINISHED\",\n \"startedAt\": \"2023-02-17T12:40:01.445Z\",\n \"duration\": 6,\n \"error\": {},\n \"location\": \"file:///canner-s3-cannerflow/hive/911d1bf6-249b-4f19-86a8-4cb9bc47b694/20230217_124001_00015_262sd\",\n \"rowCount\": 2,\n \"columns\": [\n {\n \"name\": \"shipmode\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"high_line_count\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"low_line_count\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n }\n ],\n \"dataFormat\": \"PARQUET\",\n \"queryStats\": {\n \"state\": \"FINISHED\",\n \"queued\": false,\n \"scheduled\": true,\n \"nodes\": 2,\n \"totalSplits\": 24,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 24,\n \"cpuTimeMillis\": 7029,\n \"wallTimeMillis\": 14896,\n \"queuedTimeMillis\": 68,\n \"elapsedTimeMillis\": 9823,\n \"processedRows\": 7501215,\n \"processedBytes\": 47262762,\n \"peakMemoryBytes\": 42649529,\n \"spilledBytes\": 0,\n \"executionTimeMills\": 8256,\n \"internalNetworkProcessedBytes\": 43353447,\n \"outputPositions\": 1,\n \"outputBytes\": 9,\n \"physicalWrittenBytes\": 795,\n \"updateType\": \"CREATE TABLE\",\n \"rootStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 5,\n \"wallTimeMillis\": 5,\n \"processedRows\": 3,\n \"processedBytes\": 1400,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 25,\n \"wallTimeMillis\": 28,\n \"processedRows\": 2,\n \"processedBytes\": 130,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 8,\n \"wallTimeMillis\": 36,\n \"processedRows\": 2,\n \"processedBytes\": 212,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"3\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 4,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 4,\n \"cpuTimeMillis\": 5,\n \"wallTimeMillis\": 76,\n \"processedRows\": 4,\n \"processedBytes\": 702,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"4\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 6,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 6,\n \"cpuTimeMillis\": 516,\n \"wallTimeMillis\": 931,\n \"processedRows\": 1530988,\n \"processedBytes\": 43351003,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"5\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 2,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 2,\n \"cpuTimeMillis\": 1740,\n \"wallTimeMillis\": 4610,\n \"processedRows\": 1500000,\n \"processedBytes\": 2458543,\n \"physicalInputBytes\": 2458543,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n },\n {\n \"stageId\": \"6\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 5,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 5,\n \"cpuTimeMillis\": 4730,\n \"wallTimeMillis\": 9210,\n \"processedRows\": 6001215,\n \"processedBytes\": 44804219,\n \"physicalInputBytes\": 44804219,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n }\n ]\n }\n ]\n }\n ]\n },\n \"progressPercentage\": 100\n },\n \"outputStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 5,\n \"wallTimeMillis\": 5,\n \"processedRows\": 3,\n \"processedBytes\": 1400,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 25,\n \"wallTimeMillis\": 28,\n \"processedRows\": 2,\n \"processedBytes\": 130,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 8,\n \"wallTimeMillis\": 36,\n \"processedRows\": 2,\n \"processedBytes\": 212,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"3\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 4,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 4,\n \"cpuTimeMillis\": 5,\n \"wallTimeMillis\": 76,\n \"processedRows\": 4,\n \"processedBytes\": 702,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"4\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 6,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 6,\n \"cpuTimeMillis\": 516,\n \"wallTimeMillis\": 931,\n \"processedRows\": 1530988,\n \"processedBytes\": 43351003,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"5\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 2,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 2,\n \"cpuTimeMillis\": 1740,\n \"wallTimeMillis\": 4610,\n \"processedRows\": 1500000,\n \"processedBytes\": 2458543,\n \"physicalInputBytes\": 2458543,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n },\n {\n \"stageId\": \"6\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 5,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 5,\n \"cpuTimeMillis\": 4730,\n \"wallTimeMillis\": 9210,\n \"processedRows\": 6001215,\n \"processedBytes\": 44804219,\n \"physicalInputBytes\": 44804219,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n }\n ]\n }\n ]\n }\n ]\n }\n}"}],"_postman_id":"d21437e3-7b65-4074-a293-9da32841b0cc"}],"id":"3fe333c2-f706-45dc-837b-12e2bf3059ad","description":"

You will use two ids in request url. One is workspace id; the other is saved sql id.

\n","_postman_id":"3fe333c2-f706-45dc-837b-12e2bf3059ad"},{"name":"List saved sqls","id":"f3c45aaa-68c6-449d-b15a-13f2a28fd2a0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

List all saved sqls in workspace

\n","urlObject":{"path":["saved-sqls"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"323baa1f-c5fc-4bf5-bd95-a97e00eba970","description":{"content":"

The api endpoint of Canner, you can find the endpoint at /cluster-info

\n","type":"text/plain"},"type":"any","value":"https://api.mydomain.cannerdata.com/web","key":"endpoint"}]}},"response":[{"id":"c9a7890f-90d2-46f4-9826-c4f2c2dcde59","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["saved-sqls"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694","type":"text"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"id\": \"78a21f7e-10a6-4ae5-a023-2c9269d465d3\",\n \"title\": \"Query 14\",\n \"description\": \"\",\n \"sql\": \"select\\n100.00 * sum(case\\nwhen part_45096.type like 'PROMO%' \\nthen lineitem_95227.extendedprice*(1-lineitem_95227.discount)\\nelse 0\\nend) / sum(lineitem_95227.extendedprice * (1 - lineitem_95227.discount)) as promo_revenue\\n\\nfrom\\nlineitem_95227, part_45096\\nwhere\\nlineitem_95227.partkey = part_45096.partkey\\nand lineitem_95227.shipdate >= date '1995-09-01' \\nand lineitem_95227.shipdate < date '1995-09-01' + interval '1' month;\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\"\n },\n {\n \"id\": \"17d037cd-cf2d-49ee-86d1-80fb784970e0\",\n \"title\": \"Query 01\",\n \"description\": \"\",\n \"sql\": \"select \\n returnflag,\\n linestatus, \\n sum(quantity) as sum_qty,\\n sum(extendedprice) as sum_base_price,\\n sum(extendedprice * (1 - discount)) as sum_disc_price, \\n sum(extendedprice * (1 - discount) * (1 + tax)) as sum_charge, \\n avg(quantity) as avg_qty, \\n avg(extendedprice) as avg_price, \\n avg(discount) as avg_disc, \\n count(*) as count_order\\nfrom \\n lineitem_95227\\nwhere \\n shipdate <= date'1998-12-01' - interval '90' day\\ngroup by \\n returnflag, \\n linestatus\\norder by\\n returnflag, \\n linestatus\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\"\n },\n {\n \"id\": \"0dcd0d31-debb-49c0-bff5-10c4652a8b0f\",\n \"title\": \"Query 12\",\n \"description\": \"\",\n \"sql\": \"select\\nlineitem_95227.shipmode,\\nsum(case\\nwhen orders_91318.orderpriority ='1-URGENT'\\nor orders_91318.orderpriority ='2-HIGH'\\nthen 1\\nelse 0\\nend) as high_line_count,\\nsum(case\\nwhen orders_91318.orderpriority <> '1-URGENT'\\nand orders_91318.orderpriority <> '2-HIGH'\\nthen 1\\nelse 0\\nend) as low_line_count\\n\\n\\nfrom\\norders_91318,lineitem_95227\\n\\n\\nwhere\\norders_91318.orderkey = lineitem_95227.orderkey\\nand lineitem_95227.shipmode in ('MAIL', 'SHIP') \\nand lineitem_95227.commitdate < lineitem_95227.receiptdate\\nand lineitem_95227.shipdate < lineitem_95227.commitdate\\nand lineitem_95227.receiptdate >= date '1994-01-01' \\nand lineitem_95227.receiptdate < date '1994-01-01' + interval '1' year\\ngroup by\\nlineitem_95227.shipmode\\norder by\\nlineitem_95227.shipmode\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\"\n }\n]"}],"_postman_id":"f3c45aaa-68c6-449d-b15a-13f2a28fd2a0"},{"name":"Create saved sql","id":"2fa35330-ad10-4044-beb9-c5ecc6caec0d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"title\": \"Customer List\",\n \"description\": \"Customer List\"\n}","options":{"raw":{"language":"json"}}},"url":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Create a saved sql

\n","urlObject":{"path":["saved-sqls"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"1334bfe8-d274-4bb5-b0b2-7910a3de3b23","description":{"content":"

The api endpoint of Canner, you can find the endpoint at /cluster-info

\n","type":"text/plain"},"type":"any","value":"https://api.mydomain.cannerdata.com/web","key":"endpoint"}]}},"response":[{"id":"2108f128-5352-4d2e-809e-cd02b77e55f3","name":"OK","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"title\": \"Customer List\",\n \"description\": \"Customer List\"\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/saved-sqls?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["saved-sqls"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694","type":"text"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": \"c7b202c7-b462-47a6-aaa6-91493f4c69a2\",\n \"title\": \"Customer List\",\n \"description\": \"Customer List\",\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\"\n}"}],"_postman_id":"2fa35330-ad10-4044-beb9-c5ecc6caec0d"}],"id":"58cc922c-78e8-488b-8e84-e6389828c654","description":"

Refer to how to save SQL in Canner Enterprise.

\n","_postman_id":"58cc922c-78e8-488b-8e84-e6389828c654"},{"name":"queries","item":[{"name":"{queryId}","item":[{"name":"result","item":[{"name":"Get query result","id":"0e197afd-121c-4786-9722-ec8ba8f74a15","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/queries/:queryId/result?limit=100&offset=0&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Get the result of a query

Deprecated endpoint, use a replacement endpoint: /async-queries/:queryId/result instead

\n","urlObject":{"path":["queries",":queryId","result"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"key":"limit","value":"100"},{"key":"offset","value":"0"},{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"43a8f111-df05-4374-a5fc-a17c0a90490f","description":{"content":"

(Required) the id of a query

\n","type":"text/plain"},"type":"any","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","key":"queryId"}]}},"response":[{"id":"f6d05259-5abc-48fd-9216-8422ce1a7fea","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/queries/:queryId/result?limit=100&offset=0&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","protocol":"https","host":["api","mydomain","cannerdata","com"],"path":["web","api","v2","queries",":queryId","result"],"query":[{"key":"limit","value":"100"},{"key":"offset","value":"0"},{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"key":"queryId","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","description":"(Required) the id of a query"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"result\": [\n [\n \"1\",\n \"Customer#000000001\",\n \"IVhzIApeRb ot,c,E\",\n \"15\",\n \"25-989-741-2988\",\n \"711.56\",\n \"BUILDING\",\n \"to the even, regular platelets. regular, ironic epitaphs nag e\"\n ],\n [\n \"2\",\n \"Customer#000000002\",\n \"XSTf4,NCwDVaWNe6tEgvwfmRchLXak\",\n \"13\",\n \"23-768-687-3665\",\n \"121.65\",\n \"AUTOMOBILE\",\n \"l accounts. blithely ironic theodolites integrate boldly: caref\"\n ],\n [\n \"3\",\n \"Customer#000000003\",\n \"MG9kdTD2WBHm\",\n \"1\",\n \"11-719-748-3364\",\n \"7498.12\",\n \"AUTOMOBILE\",\n \" deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov\"\n ],\n [\n \"4\",\n \"Customer#000000004\",\n \"XxVSJsLAGtn\",\n \"4\",\n \"14-128-190-5944\",\n \"2866.83\",\n \"MACHINERY\",\n \" requests. final, regular ideas sleep final accou\"\n ],\n [\n \"5\",\n \"Customer#000000005\",\n \"KvpyuHCplrB84WgAiGV6sYpZq7Tj\",\n \"3\",\n \"13-750-942-6364\",\n \"794.47\",\n \"HOUSEHOLD\",\n \"n accounts will have to unwind. foxes cajole accor\"\n ],\n [\n \"6\",\n \"Customer#000000006\",\n \"sKZz0CsnMD7mp4Xd0YrBvx,LREYKUWAh yVn\",\n \"20\",\n \"30-114-968-4951\",\n \"7638.57\",\n \"AUTOMOBILE\",\n \"tions. even deposits boost according to the slyly bold packages. final accounts cajole requests. furious\"\n ],\n [\n \"7\",\n \"Customer#000000007\",\n \"TcGe5gaZNgVePxU5kRrvXBfkasDTea\",\n \"18\",\n \"28-190-982-9759\",\n \"9561.95\",\n \"AUTOMOBILE\",\n \"ainst the ironic, express theodolites. express, even pinto beans among the exp\"\n ],\n [\n \"8\",\n \"Customer#000000008\",\n \"I0B10bB0AymmC, 0PrRYBCP1yGJ8xcBPmWhl5\",\n \"17\",\n \"27-147-574-9335\",\n \"6819.74\",\n \"BUILDING\",\n \"among the slyly regular theodolites kindle blithely courts. carefully even theodolites haggle slyly along the ide\"\n ],\n [\n \"9\",\n \"Customer#000000009\",\n \"xKiAFTjUsCuxfeleNqefumTrjS\",\n \"8\",\n \"18-338-906-3675\",\n \"8324.07\",\n \"FURNITURE\",\n \"r theodolites according to the requests wake thinly excuses: pending requests haggle furiousl\"\n ],\n [\n \"10\",\n \"Customer#000000010\",\n \"6LrEaV6KR6PLVcgl2ArL Q3rqzLzcT1 v2\",\n \"5\",\n \"15-741-346-9870\",\n \"2753.54\",\n \"HOUSEHOLD\",\n \"es regular deposits haggle. fur\"\n ]\n ],\n \"columns\": [\n {\n \"name\": \"custkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"name\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"address\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"nationkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"phone\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"acctbal\",\n \"type\": \"double\",\n \"typeSignature\": {\n \"rawType\": \"double\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"mktsegment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"comment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n }\n ],\n \"rowCount\": 10\n}"}],"_postman_id":"0e197afd-121c-4786-9722-ec8ba8f74a15"},{"name":"Get query result in urls","id":"33c843c2-440a-4b32-9844-cf0a93d74f7d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/queries/:queryId/result/urls?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Get the url of a query result, you can download the result via these urls in a period of time

\n","urlObject":{"path":["queries",":queryId","result","urls"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"587165b5-b5f8-411c-a1ca-c6e17038e3c2","description":{"content":"

(Required) the id of a query

\n","type":"text/plain"},"type":"any","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","key":"queryId"}]}},"response":[{"id":"cc320b4d-d9d4-43b3-85c6-3b6e96088b7f","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/queries/:queryId/result/urls?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["queries",":queryId","result","urls"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"key":"queryId","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","description":"(Required) the id of a query"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"urls\": [\n \"https://api.mydomain.cannerdata.com/data/cannerdata/hive/911d1bf6-249b-4f19-86a8-4cb9bc47b694/20230217_070557_00915_gp27p/20230217_070557_00915_gp27p_54650a25-aa0d-4658-bb28-e752d7daf6e0?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=cannerflow-admin%2F20230217%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230217T094957Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=fbd56263f3a43640e4940c8df74962bc4d45b62468d017a707001f235835a5eb\"\n ]\n}"}],"_postman_id":"33c843c2-440a-4b32-9844-cf0a93d74f7d"}],"id":"ceb1780e-b690-452e-a6e1-f436c6b97270","description":"

The result of a query.

\n","_postman_id":"ceb1780e-b690-452e-a6e1-f436c6b97270"},{"name":"Get query information","id":"41d97977-e367-4e18-996c-ec88e569ac79","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/queries/:queryId?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Get the information of a query (query result data not included)

Deprecated endpoint, use a replacement endpoint: /async-queries/:queryId instead

\n","urlObject":{"path":["queries",":queryId"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"9026f55d-1a4c-4aad-aeed-a689a7da8fe2","description":{"content":"

(Required) the id of query

\n","type":"text/plain"},"type":"any","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","key":"queryId"}]}},"response":[{"id":"32ef6f46-2a0b-4d85-8004-7942e22c9b3c","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/queries/:queryId?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","protocol":"https","host":["api","mydomain","cannerdata","com"],"path":["web","api","v2","queries",":queryId"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"key":"queryId","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","description":"(Required) the id of query"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": \"e2893ab5-1b87-4329-8a15-797324d8f5a7\",\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"statementId\": \"20230217_070557_00915_gp27p\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"userId\": \"377e8838-8c6f-45df-801d-3604c130a5ab\",\n \"userType\": \"BASIC_USER\",\n \"source\": \"RESTFUL\",\n \"fromCache\": false,\n \"status\": \"FINISHED\",\n \"startedAt\": \"2023-02-17T07:05:57.056Z\",\n \"duration\": 3,\n \"error\": {},\n \"location\": \"file:///canner-s3-cannerflow/hive/911d1bf6-249b-4f19-86a8-4cb9bc47b694/20230217_070557_00915_gp27p\",\n \"rowCount\": 10,\n \"columns\": [\n {\n \"name\": \"custkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"name\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"address\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"nationkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"phone\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"acctbal\",\n \"type\": \"double\",\n \"typeSignature\": {\n \"rawType\": \"double\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"mktsegment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"comment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n }\n ],\n \"dataFormat\": \"PARQUET\",\n \"queryStats\": {\n \"state\": \"FINISHED\",\n \"queued\": false,\n \"scheduled\": true,\n \"nodes\": 2,\n \"totalSplits\": 7,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 7,\n \"cpuTimeMillis\": 45,\n \"wallTimeMillis\": 108,\n \"queuedTimeMillis\": 1,\n \"elapsedTimeMillis\": 385,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"peakMemoryBytes\": 2141,\n \"spilledBytes\": 0,\n \"executionTimeMills\": 213,\n \"internalNetworkProcessedBytes\": 5077,\n \"outputPositions\": 1,\n \"outputBytes\": 9,\n \"physicalWrittenBytes\": 3191,\n \"updateType\": \"CREATE TABLE\",\n \"rootStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n },\n \"progressPercentage\": 100\n },\n \"outputStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n }\n}"}],"_postman_id":"41d97977-e367-4e18-996c-ec88e569ac79"},{"name":"Cancel query","id":"4142632f-b27e-48bf-94e9-ccf61d4fd356","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/queries/:queryId?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Cancel a running query, if the query is stable (finish or fail), an FAIL_TO_GET_STATEMENT error will return.

\n","urlObject":{"path":["queries",":queryId"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"6c1adea2-39f8-4494-b8f8-ec02965cf8f3","description":{"content":"

(Required) the id of a query

\n","type":"text/plain"},"type":"any","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","key":"queryId"}]}},"response":[{"id":"d2f88fbb-9f3e-4eb6-a3f2-6cfeca17e497","name":"OK","originalRequest":{"method":"DELETE","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/queries/:queryId?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["queries",":queryId"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"(Required) the id of workspace"}],"variable":[{"key":"queryId","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","description":"(Required) the id of a query"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"message\": \"Fail to cancel statement, it may be already finished or failed\",\n \"code\": \"SQL_QUERY_FAIL_TO_CANCEL_STATEMENT_CONFLICT\"\n}"}],"_postman_id":"4142632f-b27e-48bf-94e9-ccf61d4fd356"}],"id":"d8d021a9-a164-44d7-ad49-54d3669d3e65","description":"

The id of a query. You can use list queries to get the queryid.

\n","_postman_id":"d8d021a9-a164-44d7-ad49-54d3669d3e65"},{"name":"Create query","id":"f707d12e-1496-45c5-aa93-d6c66af7cfc2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"sql\": \"Select 1\",\n \"cacheRefresh\": false,\n \"cacheTTL\": 86400,\n \"partitionQuery\": false\n}","options":{"raw":{"language":"json"}}},"url":"https://api.mydomain.cannerdata.com/web/api/v2/queries?forwardHeaders=false&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Create an async query in workspace, you can get the result by the query Id in response.
Deprecated endpoint, use a replacement endpoint: /async-queries instead.

\n","urlObject":{"path":["queries"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"key":"forwardHeaders","value":"false"},{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[]}},"response":[{"id":"ebd71b8e-a094-448e-8ba6-a9b7ed1741ab","name":"OK","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"cacheRefresh\": false,\n \"cacheTTL\": 86400,\n \"partitionQuery\": false\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/queries?forwardHeaders=false&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","protocol":"https","host":["api","mydomain","cannerdata","com"],"path":["web","api","v2","queries"],"query":[{"key":"forwardHeaders","value":"false"},{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": \"1ed0042b-9be7-4a53-af6a-1502d465c6f1\",\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"statementId\": \"20230217_070557_00915_gp27p\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"userId\": \"377e8838-8c6f-45df-801d-3604c130a5ab\",\n \"userType\": \"BASIC_USER\",\n \"source\": \"RESTFUL\",\n \"fromCache\": true,\n \"status\": \"FINISHED\",\n \"startedAt\": \"2023-02-17T07:05:57.056Z\",\n \"duration\": 3,\n \"error\": {},\n \"location\": \"file:///canner-s3-cannerflow/hive/911d1bf6-249b-4f19-86a8-4cb9bc47b694/20230217_070557_00915_gp27p\",\n \"rowCount\": 10,\n \"columns\": [\n {\n \"name\": \"custkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"name\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"address\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"nationkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"phone\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"acctbal\",\n \"type\": \"double\",\n \"typeSignature\": {\n \"rawType\": \"double\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"mktsegment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"comment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n }\n ],\n \"dataFormat\": \"PARQUET\",\n \"queryStats\": {\n \"state\": \"FINISHED\",\n \"queued\": false,\n \"scheduled\": true,\n \"nodes\": 2,\n \"totalSplits\": 7,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 7,\n \"cpuTimeMillis\": 45,\n \"wallTimeMillis\": 108,\n \"queuedTimeMillis\": 1,\n \"elapsedTimeMillis\": 385,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"peakMemoryBytes\": 2141,\n \"spilledBytes\": 0,\n \"executionTimeMills\": 213,\n \"internalNetworkProcessedBytes\": 5077,\n \"outputPositions\": 1,\n \"outputBytes\": 9,\n \"physicalWrittenBytes\": 3191,\n \"updateType\": \"CREATE TABLE\",\n \"rootStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n },\n \"progressPercentage\": 100\n },\n \"outputStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n },\n \"dataLink\": null\n}"}],"_postman_id":"f707d12e-1496-45c5-aa93-d6c66af7cfc2"},{"name":"List queries","id":"6d229e72-f9f5-45a4-b4be-4ebc9171198a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/queries?limit=100&offset=0&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

List all queries in workspace

\n","urlObject":{"path":["queries"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"key":"limit","value":"100"},{"key":"offset","value":"0"},{"description":{"content":"

(Required) id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"0384acd0-f4c9-4ee1-aed2-f441f7e1ee79","description":{"content":"

The api endpoint of Canner, you can find the endpoint at /cluster-info

\n","type":"text/plain"},"type":"any","value":"https://api.mydomain.cannerdata.com/web","key":"endpoint"}]}},"response":[{"id":"f63f788e-5c7a-4edd-ac92-f5d7d43debe5","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/queries?limit=100&offset=0&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["queries"],"query":[{"key":"limit","value":"100"},{"key":"offset","value":"0"},{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694","type":"text"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"totalCount\": 2,\n \"result\": [\n {\n \"id\": \"e2893ab5-1b87-4329-8a15-797324d8f5a7\",\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"statementId\": \"20230217_070557_00915_gp27p\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"userId\": \"377e8838-8c6f-45df-801d-3604c130a5ab\",\n \"userType\": \"BASIC_USER\",\n \"source\": \"RESTFUL\",\n \"fromCache\": false,\n \"status\": \"FINISHED\",\n \"startedAt\": \"2023-02-17T07:05:57.056Z\",\n \"duration\": 3,\n \"error\": {},\n \"location\": \"file:///canner-s3-cannerflow/hive/911d1bf6-249b-4f19-86a8-4cb9bc47b694/20230217_070557_00915_gp27p\",\n \"rowCount\": 10,\n \"columns\": [\n {\n \"name\": \"custkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"name\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"address\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"nationkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"phone\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"acctbal\",\n \"type\": \"double\",\n \"typeSignature\": {\n \"rawType\": \"double\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"mktsegment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"comment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n }\n ],\n \"dataFormat\": \"PARQUET\",\n \"queryStats\": {\n \"state\": \"FINISHED\",\n \"queued\": false,\n \"scheduled\": true,\n \"nodes\": 2,\n \"totalSplits\": 7,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 7,\n \"cpuTimeMillis\": 45,\n \"wallTimeMillis\": 108,\n \"queuedTimeMillis\": 1,\n \"elapsedTimeMillis\": 385,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"peakMemoryBytes\": 2141,\n \"spilledBytes\": 0,\n \"executionTimeMills\": 213,\n \"internalNetworkProcessedBytes\": 5077,\n \"outputPositions\": 1,\n \"outputBytes\": 9,\n \"physicalWrittenBytes\": 3191,\n \"updateType\": \"CREATE TABLE\",\n \"rootStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n },\n \"progressPercentage\": 100\n },\n \"outputStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n }\n },\n {\n \"id\": \"1ed0042b-9be7-4a53-af6a-1502d465c6f1\",\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"statementId\": \"20230217_070557_00915_gp27p\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"userId\": \"377e8838-8c6f-45df-801d-3604c130a5ab\",\n \"userType\": \"BASIC_USER\",\n \"source\": \"RESTFUL\",\n \"fromCache\": true,\n \"status\": \"FINISHED\",\n \"startedAt\": \"2023-02-17T07:05:57.056Z\",\n \"duration\": 3,\n \"error\": {},\n \"location\": \"file:///canner-s3-cannerflow/hive/911d1bf6-249b-4f19-86a8-4cb9bc47b694/20230217_070557_00915_gp27p\",\n \"rowCount\": 10,\n \"columns\": [\n {\n \"name\": \"custkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"name\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"address\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"nationkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"phone\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"acctbal\",\n \"type\": \"double\",\n \"typeSignature\": {\n \"rawType\": \"double\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"mktsegment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"comment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n }\n ],\n \"dataFormat\": \"PARQUET\",\n \"queryStats\": {\n \"state\": \"FINISHED\",\n \"queued\": false,\n \"scheduled\": true,\n \"nodes\": 2,\n \"totalSplits\": 7,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 7,\n \"cpuTimeMillis\": 45,\n \"wallTimeMillis\": 108,\n \"queuedTimeMillis\": 1,\n \"elapsedTimeMillis\": 385,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"peakMemoryBytes\": 2141,\n \"spilledBytes\": 0,\n \"executionTimeMills\": 213,\n \"internalNetworkProcessedBytes\": 5077,\n \"outputPositions\": 1,\n \"outputBytes\": 9,\n \"physicalWrittenBytes\": 3191,\n \"updateType\": \"CREATE TABLE\",\n \"rootStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n },\n \"progressPercentage\": 100\n },\n \"outputStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n }\n }\n ]\n}"}],"_postman_id":"6d229e72-f9f5-45a4-b4be-4ebc9171198a"}],"id":"c2345f09-9e04-4c48-b55b-d98b8f76ebf0","description":"

Refer to how to execute SQL in Canner Enterprise.

\n","_postman_id":"c2345f09-9e04-4c48-b55b-d98b8f76ebf0"},{"name":"materialized-views","item":[{"name":"{mvSqlName}","item":[{"name":"Get materialized view information","id":"15946f1c-d454-41ea-bbc2-07512bfe4e84","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/materialized-views/:mvSqlName?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Get the information of a materialized view (result data not included)

\n","urlObject":{"path":["materialized-views",":mvSqlName"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"description":{"content":"

(Required) The Sql Name of a materialized view (not id)

\n","type":"text/plain"},"type":"any","value":"","key":"mvSqlName"}]}},"response":[{"id":"57993fe8-33aa-41bc-99ed-af1a163a442a","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/materialized-views/:mvSqlName?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["materialized-views",":mvSqlName"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694","type":"text"}],"variable":[{"key":"mvSqlName","value":"ut Excepteur ut","description":"(Required) The **Sql Name** of a materialized view (not id)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": \"d65f1c91-c8c1-4e23-918b-b6a1e031a901\",\n \"createDate\": \"2022-12-08T07:00:05.422579Z\",\n \"updateDate\": \"2023-01-11T10:03:08.209932Z\",\n \"finishDate\": \"2022-12-08T07:00:09.324504Z\",\n \"displayName\": \"test\",\n \"sqlName\": \"test\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"properties\": {\n \"partitions\": {},\n \"cannerflow.incrementalId.statement\": \"\",\n \"cannerflow.incrementalId\": [],\n \"cannerflow.sourceTable\": \"cannerflow.testdata_85091.part_45096\",\n \"partitionColumns\": [],\n \"storage\": {\n \"storageFormat\": {\n \"serde\": \"org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe\",\n \"inputFormat\": \"org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat\",\n \"outputFormat\": \"org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat\"\n },\n \"location\": \"file:/canner-s3-cannerflow/911d1bf6-249b-4f19-86a8-4cb9bc47b694/materialized_view/d65f1c91-c8c1-4e23-918b-b6a1e031a901\",\n \"bucketProperty\": null,\n \"skewed\": false,\n \"serdeParameters\": {}\n },\n \"cannerflow.incrementalKey\": \"size\",\n \"columnStatistics\": {},\n \"cannerflow.queryId\": \"20221208_070005_00070_dmag9\",\n \"X-Trino-Catalog\": \"canner\",\n \"cannerflow.incrementalMode\": true,\n \"X-Trino-Schema\": \"testdata_85091\",\n \"parameters\": {\n \"presto_version\": \"v1.62.0-dev\",\n \"presto_query_id\": \"20221208_070005_00070_dmag9\",\n \"transactional\": \"false\",\n \"auto.purge\": \"false\",\n \"numFiles\": \"1\",\n \"numRows\": \"200000\",\n \"rawDataSize\": \"29887576\",\n \"totalSize\": \"4380984\",\n \"STATS_GENERATED_VIA_STATS_TASK\": \"workaround for potential lack of HIVE-12730\"\n }\n },\n \"columns\": [\n {\n \"name\": \"type\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"size\",\n \"type\": \"INTEGER\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"container\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"retailprice\",\n \"type\": \"DOUBLE\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"comment\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"partkey\",\n \"type\": \"BIGINT\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"name\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"mfgr\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"brand\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n }\n ],\n \"partitionColumns\": [],\n \"statement\": \"SELECT type,size,container,retailprice,comment,partkey,name,mfgr,brand FROM \\\"materialized_view\\\".\\\"911d1bf6-249b-4f19-86a8-4cb9bc47b694\\\".\\\"d65f1c91-c8c1-4e23-918b-b6a1e031a901\\\" old UNION ALL (SELECT type,size,container,retailprice,comment,partkey,name,mfgr,brand FROM cannerflow.testdata_85091.part_45096 WHERE size > INTEGER '50')\",\n \"storageType\": \"HIVE_LOCAL\",\n \"status\": \"READY\",\n \"semantic\": false\n}"}],"_postman_id":"15946f1c-d454-41ea-bbc2-07512bfe4e84"},{"name":"Get PowerBI integration result","id":"5ed1604b-ab75-44c0-a473-84bec293342f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/materialized-views/:mvSqlName/integration/powerbi/result/urls?workspaceId=1f3c20c0-c4d4-48e1-aeb4-b930ca3ebccf","description":"

Get the result of a materialized view for PowerBI integration in urls

\n","urlObject":{"path":["materialized-views",":mvSqlName","integration","powerbi","result","urls"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"1f3c20c0-c4d4-48e1-aeb4-b930ca3ebccf"}],"variable":[{"description":{"content":"

(Required) The Sql Name of a materialized view (not id)

\n","type":"text/plain"},"type":"any","value":"","key":"mvSqlName"}]}},"response":[{"id":"46b36c37-03f1-4e40-9d68-94219cc1e960","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/materialized-views/:mvSqlName/integration/powerbi/result/urls?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["materialized-views",":mvSqlName","integration","powerbi","result","urls"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"key":"mvSqlName","value":"ut Excepteur ut","description":"(Required) The **Sql Name** of a materialized view (not id)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"urls\": [\n \"https://api.mydomain.cannerdata.com/data/cannerdata/powerbi/1f3c20c0-c4d4-48e1-aeb4-b930ca3ebccf/7e7e5309-6739-4206-986d-0ccdae01d20c/20230213_000520_00014_gk3uq_dfe2d8ec-26f8-45f6-818d-fd88af2fb622.gz?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=cannerflow-admin%2F20230217%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20230217T100935Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=7efd7297d46cd24452e46e8bd15af2b92a569ef642376128fa7c9a5fea72d97c\"\n ]\n}"}],"_postman_id":"5ed1604b-ab75-44c0-a473-84bec293342f"}],"id":"2e1f3f53-e497-4892-9634-d90472d109c5","description":"

The Sql Name of a materialized view (not id).

","_postman_id":"2e1f3f53-e497-4892-9634-d90472d109c5"},{"name":"List materialized views","id":"40124911-b3b5-4808-a2ba-08d1e36301b9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/materialized-views?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

List all materialized views in a workspace

\n","urlObject":{"path":["materialized-views"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"id":"43186469-1212-414c-a19d-77fbc35f11b1","description":{"content":"

The api endpoint of Canner, you can find the endpoint at /cluster-info

\n","type":"text/plain"},"type":"any","value":"https://api.mydomain.cannerdata.com/web","key":"endpoint"}]}},"response":[{"id":"43df9834-b546-416c-b63b-ca6c81755343","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/materialized-views?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["materialized-views"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694","type":"text"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"id\": \"d65f1c91-c8c1-4e23-918b-b6a1e031a901\",\n \"createDate\": \"2022-12-08T07:00:05.422579Z\",\n \"updateDate\": \"2023-01-11T10:03:08.209932Z\",\n \"finishDate\": \"2022-12-08T07:00:09.324504Z\",\n \"displayName\": \"test\",\n \"sqlName\": \"test\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"properties\": {\n \"partitions\": {},\n \"cannerflow.incrementalId.statement\": \"\",\n \"cannerflow.incrementalId\": [],\n \"cannerflow.sourceTable\": \"cannerflow.testdata_85091.part_45096\",\n \"partitionColumns\": [],\n \"storage\": {\n \"storageFormat\": {\n \"serde\": \"org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe\",\n \"inputFormat\": \"org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat\",\n \"outputFormat\": \"org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat\"\n },\n \"location\": \"file:/canner-s3-cannerflow/911d1bf6-249b-4f19-86a8-4cb9bc47b694/materialized_view/d65f1c91-c8c1-4e23-918b-b6a1e031a901\",\n \"bucketProperty\": null,\n \"skewed\": false,\n \"serdeParameters\": {}\n },\n \"cannerflow.incrementalKey\": \"size\",\n \"columnStatistics\": {},\n \"cannerflow.queryId\": \"20221208_070005_00070_dmag9\",\n \"X-Trino-Catalog\": \"canner\",\n \"cannerflow.incrementalMode\": true,\n \"X-Trino-Schema\": \"testdata_85091\",\n \"parameters\": {\n \"presto_version\": \"v1.62.0-dev\",\n \"presto_query_id\": \"20221208_070005_00070_dmag9\",\n \"transactional\": \"false\",\n \"auto.purge\": \"false\",\n \"numFiles\": \"1\",\n \"numRows\": \"200000\",\n \"rawDataSize\": \"29887576\",\n \"totalSize\": \"4380984\",\n \"STATS_GENERATED_VIA_STATS_TASK\": \"workaround for potential lack of HIVE-12730\"\n }\n },\n \"columns\": [\n {\n \"name\": \"type\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"size\",\n \"type\": \"INTEGER\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"container\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"retailprice\",\n \"type\": \"DOUBLE\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"comment\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"partkey\",\n \"type\": \"BIGINT\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"name\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"mfgr\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n },\n {\n \"name\": \"brand\",\n \"type\": \"VARCHAR\",\n \"args\": [],\n \"columns\": []\n }\n ],\n \"partitionColumns\": [],\n \"statement\": \"SELECT type,size,container,retailprice,comment,partkey,name,mfgr,brand FROM \\\"materialized_view\\\".\\\"911d1bf6-249b-4f19-86a8-4cb9bc47b694\\\".\\\"d65f1c91-c8c1-4e23-918b-b6a1e031a901\\\" old UNION ALL (SELECT type,size,container,retailprice,comment,partkey,name,mfgr,brand FROM cannerflow.testdata_85091.part_45096 WHERE size > INTEGER '50')\",\n \"storageType\": \"HIVE_LOCAL\",\n \"status\": \"READY\",\n \"semantic\": false\n }\n]"}],"_postman_id":"40124911-b3b5-4808-a2ba-08d1e36301b9"}],"id":"f4520fc2-b369-4aa5-8087-e8b27742bc90","description":"

Refer to how to create materialized view in Canner Enterprise.

\n","_postman_id":"f4520fc2-b369-4aa5-8087-e8b27742bc90"},{"name":"sync-queries","item":[{"name":"Create sync query","id":"505d26b5-c35e-4d7d-8d1d-7a9b9c4bf66c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"sql\": \"Select 1\",\n \"timeout\": 60,\n \"noLimit\": false,\n \"limit\": 10000\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"https://api.mydomain.cannerdata.com/web/api/v2/sync-queries?forwardHeaders=true&workspaceId=1f3c20c0-c4d4-48e1-aeb4-b930ca3ebccf","description":"

Create sync query statement, request will fulfill after query done.

\n","urlObject":{"path":["sync-queries"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"key":"forwardHeaders","value":"true"},{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"1f3c20c0-c4d4-48e1-aeb4-b930ca3ebccf"}],"variable":[]}},"response":[{"id":"d889ca9a-57f8-4753-8fa4-417a325606ed","name":"OK","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"sql\": \"Select * from asia_customer\",\n \"timeout\": 60,\n \"noLimit\": false,\n \"limit\": 10000\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/sync-queries?forwardHeaders=true&workspaceId=1f3c20c0-c4d4-48e1-aeb4-b930ca3ebccf","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["sync-queries"],"query":[{"key":"forwardHeaders","value":"true"},{"key":"workspaceId","value":"1f3c20c0-c4d4-48e1-aeb4-b930ca3ebccf","description":"(Required) the id of workspace"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"columns\": [\n {\n \"name\": \"regionkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"name\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"comment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n }\n ],\n \"data\": [\n [\n 0,\n \"AFRICA\",\n \"lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to \"\n ],\n [\n 1,\n \"AMERICA\",\n \"hs use ironic, even requests. s\"\n ],\n [\n 2,\n \"ASIA\",\n \"ges. thinly even pinto beans ca\"\n ],\n [\n 3,\n \"EUROPE\",\n \"ly final courts cajole furiously final excuse\"\n ],\n [\n 4,\n \"MIDDLE EAST\",\n \"uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl\"\n ]\n ]\n}"}],"_postman_id":"505d26b5-c35e-4d7d-8d1d-7a9b9c4bf66c"}],"id":"4dd7b911-004d-4a53-b104-267d495debff","_postman_id":"4dd7b911-004d-4a53-b104-267d495debff","description":""},{"name":"services/{serviceName}/status","item":[{"name":"Get service status","id":"67ac84d2-c3cb-448f-a5f7-75ed46a96fd4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/services/:serviceName/status","description":"

Get status of a service

\n","urlObject":{"path":["services",":serviceName","status"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[],"variable":[{"id":"a91cc53c-d33b-4443-ad9b-734fda83dfe9","description":{"content":"

(Required) Service name

\n","type":"text/plain"},"type":"any","value":"SQL_ENGINE","key":"serviceName"},{"id":"4f184382-e982-4a01-87fb-289219ed8483","description":{"content":"

The api endpoint of Canner, you can find the endpoint at /cluster-info

\n","type":"text/plain"},"type":"any","value":"https://api.mydomain.cannerdata.com/web","key":"endpoint"}]}},"response":[{"id":"c2709893-e0d1-4bb7-b323-e5ddec905c28","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/services/:serviceName/status","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["services",":serviceName","status"],"variable":[{"key":"serviceName","value":"SQL_ENGINE","description":"(Required) Service name"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"status\": \"RUNNING\"\n}"}],"_postman_id":"67ac84d2-c3cb-448f-a5f7-75ed46a96fd4"},{"name":"Update status","id":"3ce4af2f-c98c-4259-8942-2e48b7a3a842","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"state\": \"OFF\"\n}","options":{"raw":{"language":"json"}}},"url":"https://api.mydomain.cannerdata.com/web/api/v2/services/:serviceName/status","description":"

Update status of a service

\n","urlObject":{"path":["services",":serviceName","status"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[],"variable":[{"id":"28461147-79be-4513-925b-8a102a337ba7","description":{"content":"

(Required) Service name

\n","type":"text/plain"},"type":"any","value":"SQL_ENGINE","key":"serviceName"},{"id":"fbf3deee-fb21-4851-99da-4ef5d6f0dd20","description":{"content":"

The api endpoint of Canner, you can find the endpoint at /cluster-info

\n","type":"text/plain"},"type":"any","value":"https://api.mydomain.cannerdata.com/web","key":"endpoint"}]}},"response":[{"id":"318380c2-a93e-4832-9ecd-ef69b2a0b9a1","name":"OK","originalRequest":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\n \"state\": \"OFF\"\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/services/:serviceName/status","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["services",":serviceName","status"],"variable":[{"key":"serviceName","value":"SQL_ENGINE","description":"(Required) Service name"}]}},"status":"OK","code":200,"_postman_previewlanguage":"text","header":[{"key":"Content-Type","value":"text/plain"}],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"3ce4af2f-c98c-4259-8942-2e48b7a3a842"}],"id":"ce064b37-9c98-4d92-b5a9-889f078b2481","_postman_id":"ce064b37-9c98-4d92-b5a9-889f078b2481","description":""},{"name":"async-queries","item":[{"name":"{queryId}","item":[{"name":"result","item":[{"name":"Get query result","id":"6774eeb5-352d-43fd-8185-2d2cd57ede14","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/async-queries/:queryId/result?limit=100&offset=0&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Get the result of a query

\n","urlObject":{"path":["async-queries",":queryId","result"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"key":"limit","value":"100"},{"key":"offset","value":"0"},{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"description":{"content":"

(Required) the id of a query

\n","type":"text/plain"},"type":"any","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","key":"queryId"}]}},"response":[{"id":"13fb287d-2ab8-47ac-ad3d-a37d7fa8c42e","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/async-queries/:queryId/result?limit=100&offset=0&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["async-queries",":queryId","result"],"query":[{"key":"limit","value":"100"},{"key":"offset","value":"0"},{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"key":"queryId","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"result\": [\n [\n \"1\",\n \"AMERICA\",\n \"hs use ironic, even requests. s\"\n ],\n [\n \"2\",\n \"ASIA\",\n \"ges. thinly even pinto beans ca\"\n ],\n [\n \"0\",\n \"AFRICA\",\n \"lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to \"\n ],\n [\n \"3\",\n \"EUROPE\",\n \"ly final courts cajole furiously final excuse\"\n ],\n [\n \"4\",\n \"MIDDLE EAST\",\n \"uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl\"\n ]\n ],\n \"columns\": [\n {\n \"name\": \"regionkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"name\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"comment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n }\n ],\n \"rowCount\": 5\n}"}],"_postman_id":"6774eeb5-352d-43fd-8185-2d2cd57ede14"}],"id":"36ad3911-6fe4-41e7-b534-8676689a462b","_postman_id":"36ad3911-6fe4-41e7-b534-8676689a462b","description":""},{"name":"Get query information","id":"8ef32a8a-ac66-42d7-ab6e-ddf785ab8ea0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/async-queries/:queryId?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Get the information of a query (query result data not included)

\n","urlObject":{"path":["async-queries",":queryId"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"description":{"content":"

(Required) the id of query

\n","type":"text/plain"},"type":"any","value":"ee31c4b7-c76a-446b-e8e0-b8018748086a","key":"queryId"}]}},"response":[{"id":"9a6ab97f-fbc4-4798-a36b-2775b036d6ed","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/async-queries/:queryId?workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["async-queries",":queryId"],"query":[{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"key":"queryId","value":null}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": \"84ef5cb4-1b8e-4891-b88f-1f4593eaaa3d\",\n \"sql\": \"Select * From asia_customer Limit 10\",\n \"statementId\": \"20230427_025410_00027_hkpi9\",\n \"accountId\": \"17c2e57c-0adf-4e7f-a5b6-b9fdcd5aef34\",\n \"workspaceId\": \"4c4756d2-abfc-427a-9c82-0d07266535f3\",\n \"userId\": \"e6206d9e-11b8-43bc-b4c9-e7fec9f1f0cb\",\n \"userType\": \"BASIC_USER\",\n \"source\": \"RESTFUL\",\n \"fromCache\": false,\n \"status\": \"FINISHED\",\n \"startedAt\": \"2023-04-27T02:54:10.606Z\",\n \"duration\": 422,\n \"error\": {},\n \"location\": \"file:///canner-s3-cannerflow/hive/4c4756d2-abfc-427a-9c82-0d07266535f3/20230427_025410_00027_hkpi9\",\n \"rowCount\": 5,\n \"columns\": [\n {\n \"name\": \"regionkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"name\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"comment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n }\n ],\n \"dataFormat\": \"PARQUET\",\n \"queryStats\": {\n \"state\": \"FINISHED\",\n \"queued\": false,\n \"scheduled\": true,\n \"nodes\": 2,\n \"totalSplits\": 10,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 10,\n \"cpuTimeMillis\": 39,\n \"wallTimeMillis\": 49,\n \"queuedTimeMillis\": 0,\n \"elapsedTimeMillis\": 422,\n \"processedRows\": 5,\n \"processedBytes\": 1585,\n \"peakMemoryBytes\": 1566,\n \"spilledBytes\": 0,\n \"executionTimeMills\": 414,\n \"internalNetworkProcessedBytes\": 2866,\n \"outputPositions\": 1,\n \"outputBytes\": 9,\n \"physicalWrittenBytes\": 1190,\n \"updateType\": \"CREATE TABLE\",\n \"rootStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 14,\n \"wallTimeMillis\": 14,\n \"processedRows\": 3,\n \"processedBytes\": 1438,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 17,\n \"wallTimeMillis\": 19,\n \"processedRows\": 5,\n \"processedBytes\": 714,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 10,\n \"processedRows\": 5,\n \"processedBytes\": 714,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"3\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 6,\n \"processedRows\": 5,\n \"processedBytes\": 1585,\n \"physicalInputBytes\": 1585,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n }\n ]\n },\n \"writtenPositions\": 5,\n \"progressPercentage\": 100\n },\n \"outputStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 14,\n \"wallTimeMillis\": 14,\n \"processedRows\": 3,\n \"processedBytes\": 1438,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 17,\n \"wallTimeMillis\": 19,\n \"processedRows\": 5,\n \"processedBytes\": 714,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 10,\n \"processedRows\": 5,\n \"processedBytes\": 714,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"3\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 6,\n \"processedRows\": 5,\n \"processedBytes\": 1585,\n \"physicalInputBytes\": 1585,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n }\n ]\n }\n}"}],"_postman_id":"8ef32a8a-ac66-42d7-ab6e-ddf785ab8ea0"}],"id":"3d7cb1f9-44ea-4d27-a3dc-d9c4562536b7","description":"

The id of a query. Create an async query in workspace, you can get the result by the query Id in response.

\n","_postman_id":"3d7cb1f9-44ea-4d27-a3dc-d9c4562536b7"},{"name":"Create async query","id":"512a0bea-b7cf-428c-bd4e-933f57ddd243","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"sql\": \"Select 1\",\n \"cacheRefresh\": false,\n \"cacheTTL\": 86400,\n \"partitionQuery\": false\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"https://api.mydomain.cannerdata.com/web/api/v2/async-queries?forwardHeaders=false&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Create an async query in workspace, you can get the result by the query Id in response.

\n","urlObject":{"path":["async-queries"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"key":"forwardHeaders","value":"false"},{"description":{"content":"

(Required) the id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[]}},"response":[{"id":"4b8585b0-1849-4e8c-a74b-6ebf6e259cb7","name":"OK","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"sql\": \"Select * From asia_customer Limit 10\",\n \"cacheRefresh\": false,\n \"cacheTTL\": 86400,\n \"partitionQuery\": false\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/async-queries?forwardHeaders=false&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["async-queries"],"query":[{"key":"forwardHeaders","value":"false"},{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": \"84ef5cb4-1b8e-4891-b88f-1f4593eaaa3d\",\n \"sql\": \"Select * From asia_customer Limit 10\",\n \"statementId\": \"20230427_025410_00027_hkpi9\",\n \"accountId\": \"17c2e57c-0adf-4e7f-a5b6-b9fdcd5aef34\",\n \"workspaceId\": \"4c4756d2-abfc-427a-9c82-0d07266535f3\",\n \"userId\": \"e6206d9e-11b8-43bc-b4c9-e7fec9f1f0cb\",\n \"userType\": \"BASIC_USER\",\n \"source\": \"RESTFUL\",\n \"fromCache\": false,\n \"status\": \"WAITING_FOR_RESOURCES\",\n \"startedAt\": \"2023-04-27T02:54:10.606Z\",\n \"duration\": 0,\n \"error\": {},\n \"location\": \"file:///canner-s3-cannerflow/hive/4c4756d2-abfc-427a-9c82-0d07266535f3/20230427_025410_00027_hkpi9\",\n \"rowCount\": 0,\n \"columns\": [],\n \"dataFormat\": null,\n \"queryStats\": null,\n \"outputStage\": null,\n \"dataLink\": null\n}"},{"id":"9fe2982a-2797-4bd4-ad79-06bda9cf011b","name":"OK Copy","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"cacheRefresh\": false,\n \"cacheTTL\": 86400,\n \"partitionQuery\": false\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/async-queries?forwardHeaders=false&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["async-queries"],"query":[{"key":"forwardHeaders","value":"false"},{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": \"1ed0042b-9be7-4a53-af6a-1502d465c6f1\",\n \"sql\": \"Select * From customer_27487 Limit 10\",\n \"statementId\": \"20230217_070557_00915_gp27p\",\n \"accountId\": \"39478dd0-5b5f-404c-b369-4d28e565e699\",\n \"workspaceId\": \"911d1bf6-249b-4f19-86a8-4cb9bc47b694\",\n \"userId\": \"377e8838-8c6f-45df-801d-3604c130a5ab\",\n \"userType\": \"BASIC_USER\",\n \"source\": \"RESTFUL\",\n \"fromCache\": true,\n \"status\": \"FINISHED\",\n \"startedAt\": \"2023-02-17T07:05:57.056Z\",\n \"duration\": 3,\n \"error\": {},\n \"location\": \"file:///canner-s3-cannerflow/hive/911d1bf6-249b-4f19-86a8-4cb9bc47b694/20230217_070557_00915_gp27p\",\n \"rowCount\": 10,\n \"columns\": [\n {\n \"name\": \"custkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"name\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"address\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"nationkey\",\n \"type\": \"bigint\",\n \"typeSignature\": {\n \"rawType\": \"bigint\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"phone\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"acctbal\",\n \"type\": \"double\",\n \"typeSignature\": {\n \"rawType\": \"double\",\n \"arguments\": []\n }\n },\n {\n \"name\": \"mktsegment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n },\n {\n \"name\": \"comment\",\n \"type\": \"varchar\",\n \"typeSignature\": {\n \"rawType\": \"varchar\",\n \"arguments\": [\n {\n \"kind\": \"LONG\",\n \"value\": 2147483647\n }\n ]\n }\n }\n ],\n \"dataFormat\": \"PARQUET\",\n \"queryStats\": {\n \"state\": \"FINISHED\",\n \"queued\": false,\n \"scheduled\": true,\n \"nodes\": 2,\n \"totalSplits\": 7,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 7,\n \"cpuTimeMillis\": 45,\n \"wallTimeMillis\": 108,\n \"queuedTimeMillis\": 1,\n \"elapsedTimeMillis\": 385,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"peakMemoryBytes\": 2141,\n \"spilledBytes\": 0,\n \"executionTimeMills\": 213,\n \"internalNetworkProcessedBytes\": 5077,\n \"outputPositions\": 1,\n \"outputBytes\": 9,\n \"physicalWrittenBytes\": 3191,\n \"updateType\": \"CREATE TABLE\",\n \"rootStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n },\n \"progressPercentage\": 100\n },\n \"outputStage\": {\n \"stageId\": \"0\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 2,\n \"wallTimeMillis\": 2,\n \"processedRows\": 3,\n \"processedBytes\": 3000,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": true,\n \"subStages\": [\n {\n \"stageId\": \"1\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 3,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 3,\n \"cpuTimeMillis\": 6,\n \"wallTimeMillis\": 7,\n \"processedRows\": 10,\n \"processedBytes\": 2077,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": [\n {\n \"stageId\": \"2\",\n \"state\": \"FINISHED\",\n \"done\": true,\n \"nodes\": 1,\n \"totalSplits\": 1,\n \"queuedSplits\": 0,\n \"runningSplits\": 0,\n \"completedSplits\": 1,\n \"cpuTimeMillis\": 37,\n \"wallTimeMillis\": 99,\n \"processedRows\": 10,\n \"processedBytes\": 0,\n \"physicalInputBytes\": 0,\n \"failedTasks\": 0,\n \"coordinatorOnly\": false,\n \"subStages\": []\n }\n ]\n }\n ]\n },\n \"dataLink\": null\n}"}],"_postman_id":"512a0bea-b7cf-428c-bd4e-933f57ddd243"}],"id":"8e91682d-5d3a-4f70-a2f5-9e90039a9c39","_postman_id":"8e91682d-5d3a-4f70-a2f5-9e90039a9c39","description":""},{"name":"workspace-datasets","item":[{"name":"{datasetSqlName}","item":[{"name":"generate-csv","item":[{"name":"Get the csv stream of a workspace dataset","id":"3f565d6a-5f21-4693-a7be-50cbca26125f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api.mydomain.cannerdata.com/web/api/v2/workspace-datasets/:datasetSqlName/generate-csv?limit=&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","description":"

Get the csv stream to download file of specific dataset in workspace

\n","urlObject":{"path":["workspace-datasets",":datasetSqlName","generate-csv"],"host":["https://api.mydomain.cannerdata.com/web/api/v2"],"query":[{"key":"limit","value":""},{"description":{"content":"

(Required) id of workspace

\n","type":"text/plain"},"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"description":{"content":"

(Required) The Sql Name of a workspace dataset (not id)

\n","type":"text/plain"},"type":"any","value":"test","key":"datasetSqlName"}]}},"response":[{"id":"0ead18bb-d8d2-45a0-b2be-3168a266247b","name":"OK","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api.mydomain.cannerdata.com/web/api/v2/workspace-datasets/:datasetSqlName/generate-csv?limit=10&workspaceId=911d1bf6-249b-4f19-86a8-4cb9bc47b694","host":["https://api.mydomain.cannerdata.com/web/api/v2"],"path":["workspace-datasets",":datasetSqlName","generate-csv"],"query":[{"key":"limit","value":"10"},{"key":"workspaceId","value":"911d1bf6-249b-4f19-86a8-4cb9bc47b694"}],"variable":[{"key":"datasetSqlName","value":"test"}]}},"status":"OK","code":200,"_postman_previewlanguage":"text","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"regionkey,name,comment\n0,\"AFRICA\",\"lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to \"\n1,\"AMERICA\",\"hs use ironic, even requests. s\"\n2,\"ASIA\",\"ges. thinly even pinto beans ca\"\n3,\"EUROPE\",\"ly final courts cajole furiously final excuse\"\n4,\"MIDDLE EAST\",\"uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl\"\n"}],"_postman_id":"3f565d6a-5f21-4693-a7be-50cbca26125f"}],"id":"7ebc8784-675d-48c6-8e76-114f2fb5229a","_postman_id":"7ebc8784-675d-48c6-8e76-114f2fb5229a","description":""}],"id":"64da0a2f-53f2-4e49-a608-9e7a1c289bbe","description":"

The Sql Name of a workspace dataset (not id).

","_postman_id":"64da0a2f-53f2-4e49-a608-9e7a1c289bbe"}],"id":"d5063277-cbd4-4dcc-84ce-19dc8686aed1","_postman_id":"d5063277-cbd4-4dcc-84ce-19dc8686aed1","description":""}],"event":[{"listen":"prerequest","script":{"id":"555cef65-c32a-4104-93f3-e40a277f4713","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"ffec4cff-1cc4-41ac-8876-d5a014e94345","type":"text/javascript","exec":[""]}}],"variable":[{"key":"endpoint","value":"https://api.mydomain.cannerdata.com/web","type":"any"},{"key":"baseUrl","value":"https://api.mydomain.cannerdata.com/web/api/v2","type":"string"}]}