Skip to main content

Snowflake Documentation

GET /reports/celeryreports
New API: GET /ondemand_reports/report_details_by_id

Gets report details by report ID.

Request
GET http://<unravel-host>:3000/api/v1/ondemand_reports/report_details_by_id?entity_id={entity_id}&report_key={report_key}
Path parameters

None.

Query parameters

Required parameters are highlighted.

Name

Type

Description

report_key

string

Report type

Metric ID. The valid values are as follows:

  • cluster_discovery_task

  • small_files_report

  • topx_report

  • capacity_prediction_task

  • cloud_reports_task

  • services_compatibility_task

  • executive_kpi

  • queue_analysis_task

  • cluster_app_param_task

entity_id

string

Report ID

Examples

Request:

"http://myserver.com:3000/api/v1/ondemand_reports/report_details_by_id?entity_id=140384729222702&report_key=cluster_discovery_task"; -H "accept: application/json" -H "Authorization: JWT <token>"

Response:

{
   "output_json": "{\"Hive\": {\"Total\": {\"total\": 45, \"successful\": 31, \"failed\": 14, \"others\": 0}, \"Resources\": {\"total_mappers\": 1.0, \"total_reducers\": 2.0, \"map_time\": 27297.0, \"reduce_time\": 19001.0, \"successful_mappers\": 1.0, \"successful_reducers\": 2.0}, \"Duration\": [{\"id\": \"hive_20220330055913_dcddb685-6e18-4e23-a899-819b6a3e741d\", \"duration\": 301788, \"user\": \"hive\", \"realUser\": \"user1\", \"numEvents\": 0, \"status\": \"F\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"queryString\": \"select sum(l_quantity) as sum_qty from lineitem wh\", \"vcoreSeconds\": 0, \"memorySeconds\": 0, \"appt\": \"\"}], \"CPU\": [{\"id\": \"hive_20220329124310_3133df82-b014-47b2-9e13-febc51d10c20\", \"duration\": 84371, \"user\": \"hive\", \"realUser\": \"unravel\", \"numEvents\": 1, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"queryString\": \"select count(*) from store_returns\", \"vcoreSeconds\": 130, \"memorySeconds\": 135032, \"appt\": \"\"}], \"Memory\": [{\"id\": \"hive_20220329124310_3133df82-b014-47b2-9e13-febc51d10c20\", \"duration\": 84371, \"user\": \"hive\", \"realUser\": \"unravel\", \"numEvents\": 1, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"queryString\": \"select count(*) from store_returns\", \"vcoreSeconds\": 130, \"memorySeconds\": 135032, \"appt\": \"\"}], \"Cluster\": [{\"id\": \"hive_20220329124310_3133df82-b014-47b2-9e13-febc51d10c20\", \"duration\": 40233, \"user\": \"hive\", \"realUser\": \"unravel\", \"numEvents\": 1, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"queryString\": \"select count(*) from store_returns\", \"vcoreSeconds\": 130, \"memorySeconds\": 135032, \"appt\": \"\"}], \"IO\": [{\"id\": \"hive_20220329134904_f3f989d8-bc43-4ced-8e12-a22d4e41439d\", \"IO\": 1069901734, \"user\": \"hive\", \"realUser\": \"hive\", \"numEvents\": 0, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"queryString\": \"select sum(l_quantity) as sum_qty from lineitem wh\", \"vcoreSeconds\": \"-\", \"memorySeconds\": \"-\", \"appt\": \"spark\"}], \"Data\": {\"totalReadIo\": 5970601563.0, \"totalWriteIo\": 5483.0}, \"Queues\": {\"root.Payroll\": 4, \"root.hive\": 3, \"root.hdfs\": 2, \"root.unravel\": 1}}, \"Spark\": {\"Total\": {\"total\": 105, \"successful\": 66, \"failed\": 31, \"others\": 8}, \"Resources\": {\"total_spark_slot_time\": 71046130.0}, \"Duration\": [{\"id\": \"application_1648535910174_0003\", \"duration\": 12885553, \"user\": \"unravel\", \"realUser\": \"unravel\", \"numEvents\": 5, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 36191659, \"vcoreSeconds\": 25703, \"sparkStages\": 0, \"sparkTasks\": 0}], \"CPU\": [{\"id\": \"application_1648535910174_0003\", \"duration\": 12885553, \"user\": \"unravel\", \"realUser\": \"unravel\", \"numEvents\": 5, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 36191659, \"vcoreSeconds\": 25703, \"sparkStages\": 0, \"sparkTasks\": 0}], \"Memory\": [{\"id\": \"application_1648535910174_0020\", \"duration\": 8846547, \"user\": \"user7\", \"realUser\": \"user7\", \"numEvents\": 5, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 49769918, \"vcoreSeconds\": 17680, \"sparkStages\": 1, \"sparkTasks\": 10000}], \"Cluster\": [{\"id\": \"application_1648535910174_0007\", \"duration\": 9684185, \"user\": \"user9\", \"realUser\": \"user9\", \"numEvents\": 0, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 32874772, \"vcoreSeconds\": 23337, \"sparkStages\": 0, \"sparkTasks\": 1000}], \"IO\": [{\"id\": \"application_1648561667886_0001\", \"IO\": 1069901734, \"user\": \"hive\", \"realUser\": \"hive\", \"numEvents\": 0, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 3621654, \"vcoreSeconds\": 1026, \"sparkStages\": 2, \"sparkTasks\": 15}], \"Data\": {\"totalReadIo\": 5913084790.0, \"totalWriteIo\": 8110.0}, \"Queues\": {\"root.Payroll\": 19, \"root.Finance\": 10, \"root.Marketing\": 9, \"root.ThirdPartyData\": 8, \"root.DataAnalyst\": 6, \"root.DataScience\": 6, \"root.Sales\": 6, \"root.DataForecast\": 5, \"root.default\": 5, \"default\": 4}}, \"Impala\": {\"Total\": {\"total\": 13, \"successful\": 13, \"failed\": 0, \"others\": 0}, \"Resources\": {\"totalProcessingTime\": 2752439.0}, \"Duration\": [{\"id\": \"1e4e56b2b29a1c57:26be943d00000000\", \"duration\": 3046148, \"user\": \"hdfs/myserver.unraveldata.com@UNRAVELDATA.COM\", \"realUser\": \"hdfs/myserver.unraveldata.com\", \"numEvents\": 2, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 129595, \"queryString\": \"select * from workflow_test where l_quantity < 200\", \"cpuTime\": 66887}], \"CPU\": [{\"id\": \"1e4e56b2b29a1c57:26be943d00000000\", \"duration\": 3046148, \"user\": \"hdfs/myserver.unraveldata.com@UNRAVELDATA.COM\", \"realUser\": \"hdfs/myserver.unraveldata.com\", \"numEvents\": 2, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 129595, \"queryString\": \"select * from workflow_test where l_quantity < 200\", \"cpuTime\": 66887}], \"Memory\": [{\"id\": \"1e4e56b2b29a1c57:26be943d00000000\", \"duration\": 3046148, \"user\": \"hdfs/myserver.unraveldata.com@UNRAVELDATA.COM\", \"realUser\": \"hdfs/myserver.unraveldata.com\", \"numEvents\": 2, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 129595, \"queryString\": \"select * from workflow_test where l_quantity < 200\", \"cpuTime\": 66887}], \"Cluster\": [{\"id\": \"1e4e56b2b29a1c57:26be943d00000000\", \"duration\": 2718736, \"user\": \"hdfs/myserver.unraveldata.com@UNRAVELDATA.COM\", \"realUser\": \"hdfs/myserver.unraveldata.com\", \"numEvents\": 2, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 129595, \"queryString\": \"select * from workflow_test where l_quantity < 200\", \"cpuTime\": 66887}], \"IO\": [{\"id\": \"1e4e56b2b29a1c57:26be943d00000000\", \"IO\": 57150834, \"user\": \"hdfs/myserver.unraveldata.com@UNRAVELDATA.COM\", \"realUser\": \"hdfs/myserver.unraveldata.com\", \"numEvents\": 2, \"status\": \"S\", \"clusterUid\": \"default\", \"clusterId\": \"Cluster1\", \"memorySeconds\": 129595, \"queryString\": \"select * from workflow_test where l_quantity < 200\", \"cpuTime\": 66887}], \"Data\": {\"totalReadIo\": 99663287.0, \"totalWriteIo\": 43073529.0}, \"Queues\": {\"root.hdfs\": 3, \"root.user5\": 1}}, \"Parameters\": {\"startDate\": 1648018819000, \"endDate\": 1648623619000, \"x\": 1, \"tags\": {}, \"users\": [], \"realUsers\": [], \"queues\": [], \"clusterUid\": \"default\", \"clusterId\": \"default\"}}",
   "metadata": "{\"start\": 1648018819000, \"end\": 1648623619000, \"x\": 1, \"tags\": {}, \"users\": [], \"realUsers\": [], \"queues\": [], \"clusterUid\": \"default\", \"clusterId\": \"default\"}"
}