Skip to main content

Snowflake Documentation

GET /apps/events/inefficient_apps

Gets total job count per status in a given time window (at one-hour intervals).

Request
GET http://<unravel-host>:3000/api/v1/apps/events/inefficient_apps?start_time={start_time}&end_time={end_time}&entity_type={application type}
Path parameters

None.

Query parameters

Required parameters are highlighted.

Name

Type

Description

start_time

string

Start time. Format yyyy-mm-ddThh:mm:ss.SSS+offset value

end_time

string

End time. Format yyyy-mm-ddThh:mm:ss.SSS+offset value

entity_type

integer

Application type.

Valid values are:

0: MR
1: Hive
2 : Spark
15: Tez
16 : Impala
Examples

Request:

curl -X GET -H "Authorization: JWT <token>" H "Accept: application/json" http://myserver.unraveldata.com:3000/api/v1/apps/events/inefficient_apps?start_time=2019-03-01&end_time=2019-03-06&entity_type=2

Response body:

[
  {
    "entity_type": 0,
    "event_name": "MRTooLargeMapEvent",
    "count": 10559
  },
  {
    "entity_type": 0,
    "event_name": "MRTimeBreakdownEvent",
    "count": 7868
  },
  {
    "entity_type": 0,
    "event_name": "MRTooLargeReduceEvent",
    "count": 4782
  },
  {
    "entity_type": 0,
    "event_name": "MRTooManyMapEvent2",
    "count": 2097
  },
  {
   "entity_type": 0,
    "event_name": "MRTooManyReduceEvent2",
    "count": 1066
  },
  {
    "entity_type": 0,
    "event_name": "LongReduceTasksStartBeforeMapFinishEvent",
    "count": 21
  },
  {
    "entity_type": 0,
    "event_name": "MRTooFewMapEvent2",
    "count": 3
  },
  {
    "entity_type": 0,
    "event_name": "MRReduceTimeSkewEvent",
    "count": 2
  },
  {
    "entity_type": 0,
    "event_name": "MRMapTimeSkewEvent",
    "count": 1
  }
]