Skip to main content

Snowflake Documentation

GET /common/app/details

Returns consolidated data for an application.

Request
GET http://<unravel-host>:3000/api/v1/common/app/details?from={from}&to={to}&appTypes={appTypes}&appStatus={appStatus}&page=1&clusterUid={clusterUid}
Path Parameters

Name

Description

app_id

App ID.

Query parameters

Name

Type

Description

from

string($date)

Start date in the date range. Format yyyy-mm-ddThh:mm:ss.SSSZ

to

string($date)

End date in the date range. Format yyyy-mm-ddThh:mm:ss.SSSZ

appType

string

Type of applications:

  • MR

  • Hive

  • Spark

  • Impala

  • Tez

  • Cascading

  • PIG

appStatus

string

Status of applications:

  • S - Success

  • F - Failed

  • K - Killed

  • R - Running

  • W - Waiting

  • P - Pending

  • U - Unknown

page

int

Page number for pagination

clusterUid

string

Cluster unique ID

Examples

Request:

curl -X GET "http://myserver.com:3000/api/v1/common/app/details?from=2022-03-23T16:08:56.000Z&to=2022-03-30T16:08:56.000Z&appTypes=spark&appStatus=S&page=1&clusterUid=default" -H "accept: application/json"  -H "Content-Type:application/json" -H  "Authorization: JWT token"

Response body:

[
   {
       "id": "application_1648115466090_0016",
       "type": "spark",
       "type_org": "spark",
       "user": "user3",
       "cluster": "Cluster1",
       "clusterUid": "3c599cf8-aa69-11ec-9173-1e0036001415",
       "queue": "root.DataForecast",
       "status": "Success",
       "nick": "spark",
       "raw_startTime": 1648127077600,
       "startTime": "03/24/2022 13:04:37",
       "endTime": "03/24/2022 13:05:29",
       "raw_endTime": 1648127129287,
       "realUser": "user3",
       "duration": "51s",
       "raw_duration": 51687,
       "IO": 0,
       "raw_IO": 0,
       "perc_read": 0,
       "perc_written": 0,
       "read_long": "0 B",
       "write_long": "0 B",
       "numberofJobs": {
           "1": 10
       },
       "numberofStages": {
           "1": 100
       },
       "recommendation": []
   },
   {
       "id": "application_1648115466090_0015",
       "type": "spark",
       "type_org": "spark",
       "user": "user3",
       "cluster": "Cluster1",
       "clusterUid": "3c599cf8-aa69-11ec-9173-1e0036001415",
       "queue": "root.Payroll",
       "status": "Success",
       "nick": "spark",
       "raw_startTime": 1648127027467,
       "startTime": "03/24/2022 13:03:47",
       "endTime": "03/24/2022 13:06:46",
       "raw_endTime": 1648127206523,
       "realUser": "user3",
       "duration": "2m 59s",
       "raw_duration": 179056,
       "IO": 0,
       "raw_IO": 0,
       "perc_read": 0,
       "perc_written": 0,
       "read_long": "0 B",
       "write_long": "0 B",
       "numberofJobs": {
           "1": 1
       },
       "numberofStages": {
           "1": 1
       },
       "recommendation": []
   }
]