NYC Yellow Taxi Data Analysis - Details for Job 6

Details for Job 6

Status: SUCCEEDED
Associated SQL Query: 4
Completed Stages: 5

Enable zooming

digraph G { subgraph clusterstage_9 { label="Stage 9"; 2 [labelType="html" label="PythonRDD [2] RDD at PythonRDD.scala:53"]; 14 [labelType="html" label="SQLExecutionRDD [14] csv at NativeMethodAccessorImpl.java:0"]; subgraph cluster0 { label="textFile"; 0 [labelType="html" label="s3a://data-repository-bkt/ECS765/nyc_taxi/taxi_zone_lookup.csv [0] textFile at NativeMethodAccessorImpl.java:0"]; 1 [labelType="html" label="s3a://data-repository-bkt/ECS765/nyc_taxi/taxi_zone_lookup.csv [1] textFile at NativeMethodAccessorImpl.java:0"]; } subgraph cluster1 { label="map"; 3 [labelType="html" label="MapPartitionsRDD [3] map at NativeMethodAccessorImpl.java:0"]; } subgraph cluster29 { label="Scan"; 11 [labelType="html" label="MapPartitionsRDD [11] csv at NativeMethodAccessorImpl.java:0"]; } subgraph cluster25 { label="WholeStageCodegen (1)"; 12 [labelType="html" label="MapPartitionsRDD [12] csv at NativeMethodAccessorImpl.java:0"]; } subgraph cluster24 { label="DeserializeToObject"; 13 [labelType="html" label="MapPartitionsRDD [13] csv at NativeMethodAccessorImpl.java:0"]; } subgraph cluster30 { label="mapPartitions"; 15 [labelType="html" label="MapPartitionsRDD [15] csv at NativeMethodAccessorImpl.java:0"]; } subgraph cluster31 { label="mapPartitions"; 16 [labelType="html" label="MapPartitionsRDD [16] csv at NativeMethodAccessorImpl.java:0"]; } subgraph cluster32 { label="mapPartitions"; 17 [labelType="html" label="MapPartitionsRDD [17] csv at NativeMethodAccessorImpl.java:0"]; } subgraph cluster143 { label="WholeStageCodegen (2)"; 53 [labelType="html" label="MapPartitionsRDD [53] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster142 { label="Exchange"; 54 [labelType="html" label="MapPartitionsRDD [54] showString at NativeMethodAccessorImpl.java:0"]; } } 0->1; 1->2; 2->3; 3->11; 11->12; 12->13; 13->14; 14->15; 15->16; 16->17; 17->53; 53->54; }

digraph G { subgraph clusterstage_10 { label="Stage 10"; subgraph cluster138 { label="Scan csv "; 48 [labelType="html" label="FileScanRDD [48] showString at NativeMethodAccessorImpl.java:0"]; 49 [labelType="html" label="MapPartitionsRDD [49] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster137 { label="Exchange"; 50 [labelType="html" label="MapPartitionsRDD [50] showString at NativeMethodAccessorImpl.java:0"]; } } 48->49; 49->50; }

digraph G { subgraph clusterstage_11 { label="Stage 11"; subgraph cluster137 { label="Exchange"; 51 [labelType="html" label="ShuffledRowRDD [51] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster134 { label="WholeStageCodegen (1)"; 52 [labelType="html" label="MapPartitionsRDD [52] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster142 { label="Exchange"; 55 [labelType="html" label="ShuffledRowRDD [55] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster139 { label="WholeStageCodegen (3)"; 56 [labelType="html" label="MapPartitionsRDD [56] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster133 { label="SortMergeJoin"; 57 [labelType="html" label="ZippedPartitionsRDD2 [57] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster130 { label="WholeStageCodegen (4)"; 58 [labelType="html" label="MapPartitionsRDD [58] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster129 { label="Exchange"; 59 [labelType="html" label="MapPartitionsRDD [59] showString at NativeMethodAccessorImpl.java:0"]; } } 51->52; 55->56; 52->57; 56->57; 57->58; 58->59; }

50,51

54,55

digraph G { subgraph clusterstage_12 { label="Stage 12"; subgraph cluster142 { label="Exchange"; 55 [labelType="html" label="ShuffledRowRDD [55] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster129 { label="Exchange"; 60 [labelType="html" label="ShuffledRowRDD [60] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster126 { label="WholeStageCodegen (5)"; 61 [labelType="html" label="MapPartitionsRDD [61] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster147 { label="WholeStageCodegen (7)"; 62 [labelType="html" label="MapPartitionsRDD [62] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster125 { label="SortMergeJoin"; 63 [labelType="html" label="ZippedPartitionsRDD2 [63] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster121 { label="WholeStageCodegen (8)"; 64 [labelType="html" label="MapPartitionsRDD [64] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster120 { label="Exchange"; 65 [labelType="html" label="MapPartitionsRDD [65] showString at NativeMethodAccessorImpl.java:0"]; } } 60->61; 55->62; 61->63; 62->63; 63->64; 64->65; }

54,55

59,60

digraph G { subgraph clusterstage_13 { label="Stage 13"; subgraph cluster120 { label="Exchange"; 66 [labelType="html" label="ShuffledRowRDD [66] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster117 { label="WholeStageCodegen (9)"; 67 [labelType="html" label="MapPartitionsRDD [67] showString at NativeMethodAccessorImpl.java:0"]; } subgraph cluster152 { label="mapPartitionsInternal"; 68 [labelType="html" label="MapPartitionsRDD [68] showString at NativeMethodAccessorImpl.java:0"]; } } 66->67; 67->68; }

65,66

Completed Stages (5)

Page:

Stage Id ▾	Description	Submitted	Duration	Tasks: Succeeded/Total	Input	Shuffle Read	Shuffle Write
13	showString at NativeMethodAccessorImpl.java:0 +details org.apache.spark.sql.Dataset.showString(Dataset.scala:337) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244) py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357) py4j.Gateway.invoke(Gateway.java:282) py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132) py4j.commands.CallCommand.execute(CallCommand.java:79) py4j.GatewayConnection.run(GatewayConnection.java:238) java.lang.Thread.run(Thread.java:750)	2024/12/16 22:18:29	85 ms	1/1		8.1 KiB
12	showString at NativeMethodAccessorImpl.java:0 +details org.apache.spark.sql.Dataset.showString(Dataset.scala:337) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244) py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357) py4j.Gateway.invoke(Gateway.java:282) py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132) py4j.commands.CallCommand.execute(CallCommand.java:79) py4j.GatewayConnection.run(GatewayConnection.java:238) java.lang.Thread.run(Thread.java:750)	2024/12/16 22:18:14	15 s	200/200		383.7 MiB	744.8 KiB
11	showString at NativeMethodAccessorImpl.java:0 +details org.apache.spark.sql.Dataset.showString(Dataset.scala:337) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244) py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357) py4j.Gateway.invoke(Gateway.java:282) py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132) py4j.commands.CallCommand.execute(CallCommand.java:79) py4j.GatewayConnection.run(GatewayConnection.java:238) java.lang.Thread.run(Thread.java:750)	2024/12/16 22:18:00	14 s	200/200		450.1 MiB	383.6 MiB
10	showString at NativeMethodAccessorImpl.java:0 +details org.apache.spark.sql.Dataset.showString(Dataset.scala:337) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244) py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357) py4j.Gateway.invoke(Gateway.java:282) py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132) py4j.commands.CallCommand.execute(CallCommand.java:79) py4j.GatewayConnection.run(GatewayConnection.java:238) java.lang.Thread.run(Thread.java:750)	2024/12/16 22:17:22	37 s	20/20	2.2 GiB		450.1 MiB
9	showString at NativeMethodAccessorImpl.java:0 +details org.apache.spark.sql.Dataset.showString(Dataset.scala:337) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244) py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357) py4j.Gateway.invoke(Gateway.java:282) py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132) py4j.commands.CallCommand.execute(CallCommand.java:79) py4j.GatewayConnection.run(GatewayConnection.java:238) java.lang.Thread.run(Thread.java:750)	2024/12/16 22:17:22	0.2 s	2/2	14.5 KiB		16.0 KiB

Page: