NasaLogSparkStreaming - Details for Query 81

Details for Query 81

Submitted Time: 2024/12/04 20:20:19
Duration: 15 s
Succeeded Jobs: 32 33

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" WriteToDataSourceV2 "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n11 ms (0 ms, 1 ms, 4 ms (stage 53.0: task 2875))"; 2 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 53.0: task 2876)) peak memory total (min, med, max (stageId: taskId)) 448.5 MiB (64.0 KiB, 64.1 MiB, 64.1 MiB (stage 53.0: task 2876)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 53.0: task 2876))"]; } 3 [labelType="html" label="Exchange shuffle records written: 13 shuffle write time total (min, med, max (stageId: taskId)) 6 ms (0 ms, 0 ms, 1 ms (stage 52.0: task 2682)) records read: 13 local bytes read total (min, med, max (stageId: taskId)) 1073.0 B (0.0 B, 123.0 B, 230.0 B (stage 53.0: task 2881)) fetch wait time total (min, med, max (stageId: taskId)) 1 ms (0 ms, 0 ms, 1 ms (stage 53.0: task 2875)) remote bytes read total (min, med, max (stageId: taskId)) 284.0 B (0.0 B, 0.0 B, 161.0 B (stage 53.0: task 2880)) local blocks read: 10 remote blocks read: 3 data size total (min, med, max (stageId: taskId)) 936.0 B (0.0 B, 0.0 B, 88.0 B (stage 52.0: task 2706)) shuffle bytes written total (min, med, max (stageId: taskId)) 1357.0 B (0.0 B, 0.0 B, 123.0 B (stage 52.0: task 2706))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n640 ms (0 ms, 1 ms, 43 ms (stage 52.0: task 2778))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 65 ms (0 ms, 0 ms, 39 ms (stage 52.0: task 2778)) peak memory total (min, med, max (stageId: taskId)) 1764.0 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 52.0: task 2682)) number of output rows: 26 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 52.0: task 2682))"]; } 6 [labelType="html" label="StateStoreSave number of total state rows: 26 memory used by state total (min, med, max (stageId: taskId)) 129.6 KiB (232.0 B, 400.0 B, 728.0 B (stage 50.0: task 2536)) count of cache hit on states cache in provider: 7,600 number of output rows: 26 estimated size of state only on current version total (min, med, max (stageId: taskId)) 40.1 KiB (88.0 B, 88.0 B, 328.0 B (stage 52.0: task 2706)) time to commit changes total (min, med, max (stageId: taskId)) 19.6 s (28 ms, 37 ms, 89 ms (stage 52.0: task 2694)) time to remove total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 52.0: task 2675)) number of updated state rows: 8 time to update total (min, med, max (stageId: taskId)) 303 ms (0 ms, 0 ms, 49 ms (stage 52.0: task 2857))"]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n304 ms (0 ms, 0 ms, 49 ms (stage 52.0: task 2857))"; 8 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 59 ms (0 ms, 0 ms, 32 ms (stage 52.0: task 2857)) peak memory total (min, med, max (stageId: taskId)) 612.0 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 52.0: task 2706)) number of output rows: 8 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 52.0: task 2706))"]; } 9 [labelType="html" label="StateStoreRestore number of output rows: 8"]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n1.0 s (1 ms, 2 ms, 69 ms (stage 52.0: task 2857))"; 11 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 53 ms (0 ms, 0 ms, 34 ms (stage 52.0: task 2857)) peak memory total (min, med, max (stageId: taskId)) 612.0 MiB (256.0 KiB, 256.0 KiB, 64.3 MiB (stage 52.0: task 2706)) number of output rows: 8 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 52.0: task 2706))"]; } 12 [labelType="html" label="Exchange shuffle records written: 8 shuffle write time total (min, med, max (stageId: taskId)) 10 ms (3 ms, 7 ms, 7 ms (stage 49.0: task 2474)) records read: 16 local bytes read total (min, med, max (stageId: taskId)) 920.0 B (0.0 B, 0.0 B, 123.0 B (stage 52.0: task 2706)) fetch wait time total (min, med, max (stageId: taskId)) 12 ms (0 ms, 0 ms, 8 ms (stage 50.0: task 2507)) remote bytes read total (min, med, max (stageId: taskId)) 920.0 B (0.0 B, 0.0 B, 123.0 B (stage 52.0: task 2706)) local blocks read: 8 remote blocks read: 8 data size total (min, med, max (stageId: taskId)) 640.0 B (320.0 B, 320.0 B, 320.0 B (stage 49.0: task 2473)) shuffle bytes written total (min, med, max (stageId: taskId)) 920.0 B (460.0 B, 460.0 B, 460.0 B (stage 49.0: task 2473))"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n17 ms (5 ms, 12 ms, 12 ms (stage 49.0: task 2474))"; 14 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 1 ms (0 ms, 1 ms, 1 ms (stage 49.0: task 2474)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 49.0: task 2473)) number of output rows: 8 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 49.0: task 2473))"]; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="Filter number of output rows: 30"]; 17 [labelType="html" label="Expand number of output rows: 30"]; 18 [labelType="html" label=" Project "]; } 19 [labelType="html" label=" EventTimeWatermark "]; subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n7 ms (2 ms, 5 ms, 5 ms (stage 49.0: task 2474))"; 21 [labelType="html" label=" Project "]; } 22 [labelType="html" label="Generate number of output rows: 15"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n9 ms (3 ms, 6 ms, 6 ms (stage 49.0: task 2474))"; 24 [labelType="html" label=" Project "]; } 25 [labelType="html" label="MicroBatchScan number of output rows: 15"]; 2->0; 3->2; 5->3; 6->5; 8->6; 9->8; 11->9; 12->11; 14->12; 15->14; 16->15; 17->16; 18->17; 19->18; 21->19; 22->21; 24->22; 25->24; }

WriteToDataSourceV2 org.apache.spark.sql.execution.streaming.sources.MicroBatchWrite@1b685a73

Sort [total_bytes#858 DESC NULLS LAST], true, 0

WholeStageCodegen (7)

Exchange rangepartitioning(total_bytes#858 DESC NULLS LAST, 200), true, [id=#1545]

HashAggregate(keys=[window#859-T3000ms, hostname#140], functions=[sum(cast(bytes#175 as double))])

WholeStageCodegen (6)

StateStoreSave [window#859-T3000ms, hostname#140], state info [ checkpoint = file:/tmp/temporary-fcb72abb-9143-4d38-a65d-25baf17e34c7/state, runId = 49431645-20e3-4737-9dcc-8f334da22f1d, opId = 0, ver = 5, numPartitions = 200], Complete, 1733343600102, 2

HashAggregate(keys=[window#859-T3000ms, hostname#140], functions=[merge_sum(cast(bytes#175 as double))])

WholeStageCodegen (5)

StateStoreRestore [window#859-T3000ms, hostname#140], state info [ checkpoint = file:/tmp/temporary-fcb72abb-9143-4d38-a65d-25baf17e34c7/state, runId = 49431645-20e3-4737-9dcc-8f334da22f1d, opId = 0, ver = 5, numPartitions = 200], 2

HashAggregate(keys=[window#859-T3000ms, hostname#140], functions=[merge_sum(cast(bytes#175 as double))])

WholeStageCodegen (4)

Exchange hashpartitioning(window#859-T3000ms, hostname#140, 200), true, [id=#1533]

HashAggregate(keys=[window#859-T3000ms, hostname#140], functions=[partial_sum(cast(bytes#175 as double))])

Project [window#859-T3000ms, hostname#140, bytes#175]

Filter (((isnotnull(timestamp#1-T3000ms) AND isnotnull(window#859-T3000ms)) AND (timestamp#1-T3000ms >= window#859-T3000ms.start)) AND (timestamp#1-T3000ms < window#859-T3000ms.end))

Expand [ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 0) - 2) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 0) - 2) * 30000000) + 60000000), LongType, TimestampType)), timestamp#1-T3000ms, hostname#140, bytes#175), ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 1) - 2) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 1) - 2) * 30000000) + 60000000), LongType, TimestampType)), timestamp#1-T3000ms, hostname#140, bytes#175)], [window#859-T3000ms, timestamp#1-T3000ms, hostname#140, bytes#175]

Project [timestamp#1-T3000ms, split(logs#5, ,, -1)[1] AS hostname#140, split(logs#5, ,, -1)[6] AS bytes#175]

WholeStageCodegen (3)

EventTimeWatermark timestamp#1: timestamp, 3 seconds

Project [logs#5, timestamp#1]

WholeStageCodegen (2)

Generate explode(split(value#0, , -1)), [timestamp#1], false, [logs#5]

Project [value#0, timestamp#1]

WholeStageCodegen (1)

MicroBatchScan[value#0, timestamp#1] class org.apache.spark.sql.execution.streaming.sources.TextSocketTable$$anon$1

Details

== Parsed Logical Plan ==
WriteToDataSourceV2 org.apache.spark.sql.execution.streaming.sources.MicroBatchWrite@1b685a73
+- Sort [total_bytes#858 DESC NULLS LAST], true
   +- Aggregate [window#859-T3000ms, hostname#140], [window#859-T3000ms AS window#847-T3000ms, hostname#140, sum(cast(bytes#175 as double)) AS total_bytes#858]
      +- Filter ((timestamp#1-T3000ms >= window#859-T3000ms.start) AND (timestamp#1-T3000ms < window#859-T3000ms.end))
         +- Expand [ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) + cast(1 as bigint)) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) END + cast(0 as bigint)) - cast(2 as bigint)) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion((((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) + cast(1 as bigint)) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) END + cast(0 as bigint)) - cast(2 as bigint)) * 30000000) + 0) + 60000000), LongType, TimestampType)), logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, responsecode#166, bytes#175), ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) + cast(1 as bigint)) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) END + cast(1 as bigint)) - cast(2 as bigint)) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion((((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) + cast(1 as bigint)) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) END + cast(1 as bigint)) - cast(2 as bigint)) * 30000000) + 0) + 60000000), LongType, TimestampType)), logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, responsecode#166, bytes#175)], [window#859-T3000ms, logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, responsecode#166, bytes#175]
            +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, responsecode#166, split(logs#5, ,, -1)[6] AS bytes#175]
               +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, split(logs#5, ,, -1)[5] AS responsecode#166]
                  +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, split(logs#5, ,, -1)[4] AS url#158]
                     +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, split(logs#5, ,, -1)[3] AS method#151]
                        +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, split(logs#5, ,, -1)[2] AS time#145]
                           +- Project [logs#5, timestamp#1-T3000ms, idx#136, split(logs#5, ,, -1)[1] AS hostname#140]
                              +- Project [logs#5, timestamp#1-T3000ms, split(logs#5, ,, -1)[0] AS idx#136]
                                 +- EventTimeWatermark timestamp#1: timestamp, 3 seconds
                                    +- Project [logs#5, timestamp#1]
                                       +- Generate explode(split(value#0,  , -1)), false, [logs#5]
                                          +- StreamingDataSourceV2Relation [value#0, timestamp#1], org.apache.spark.sql.execution.streaming.sources.TextSocketTable$$anon$1@6b3ca49a, TextSocketV2[host: stream-emulator.data-science-tools.svc.cluster.local, port: 5551], 63, 78

== Analyzed Logical Plan ==

WriteToDataSourceV2 org.apache.spark.sql.execution.streaming.sources.MicroBatchWrite@1b685a73
+- Sort [total_bytes#858 DESC NULLS LAST], true
   +- Aggregate [window#859-T3000ms, hostname#140], [window#859-T3000ms AS window#847-T3000ms, hostname#140, sum(cast(bytes#175 as double)) AS total_bytes#858]
      +- Filter ((timestamp#1-T3000ms >= window#859-T3000ms.start) AND (timestamp#1-T3000ms < window#859-T3000ms.end))
         +- Expand [ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) + cast(1 as bigint)) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) END + cast(0 as bigint)) - cast(2 as bigint)) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion((((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) + cast(1 as bigint)) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) END + cast(0 as bigint)) - cast(2 as bigint)) * 30000000) + 0) + 60000000), LongType, TimestampType)), logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, responsecode#166, bytes#175), ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) + cast(1 as bigint)) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) END + cast(1 as bigint)) - cast(2 as bigint)) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion((((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) + cast(1 as bigint)) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / cast(30000000 as double))) END + cast(1 as bigint)) - cast(2 as bigint)) * 30000000) + 0) + 60000000), LongType, TimestampType)), logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, responsecode#166, bytes#175)], [window#859-T3000ms, logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, responsecode#166, bytes#175]
            +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, responsecode#166, split(logs#5, ,, -1)[6] AS bytes#175]
               +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, url#158, split(logs#5, ,, -1)[5] AS responsecode#166]
                  +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, method#151, split(logs#5, ,, -1)[4] AS url#158]
                     +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, time#145, split(logs#5, ,, -1)[3] AS method#151]
                        +- Project [logs#5, timestamp#1-T3000ms, idx#136, hostname#140, split(logs#5, ,, -1)[2] AS time#145]
                           +- Project [logs#5, timestamp#1-T3000ms, idx#136, split(logs#5, ,, -1)[1] AS hostname#140]
                              +- Project [logs#5, timestamp#1-T3000ms, split(logs#5, ,, -1)[0] AS idx#136]
                                 +- EventTimeWatermark timestamp#1: timestamp, 3 seconds
                                    +- Project [logs#5, timestamp#1]
                                       +- Generate explode(split(value#0,  , -1)), false, [logs#5]
                                          +- StreamingDataSourceV2Relation [value#0, timestamp#1], org.apache.spark.sql.execution.streaming.sources.TextSocketTable$$anon$1@6b3ca49a, TextSocketV2[host: stream-emulator.data-science-tools.svc.cluster.local, port: 5551], 63, 78

== Optimized Logical Plan ==
WriteToDataSourceV2 org.apache.spark.sql.execution.streaming.sources.MicroBatchWrite@1b685a73
+- Sort [total_bytes#858 DESC NULLS LAST], true
   +- Aggregate [window#859-T3000ms, hostname#140], [window#859-T3000ms AS window#847-T3000ms, hostname#140, sum(cast(bytes#175 as double)) AS total_bytes#858]
      +- Project [window#859-T3000ms, hostname#140, bytes#175]
         +- Filter (((isnotnull(timestamp#1-T3000ms) AND isnotnull(window#859-T3000ms)) AND (timestamp#1-T3000ms >= window#859-T3000ms.start)) AND (timestamp#1-T3000ms < window#859-T3000ms.end))
            +- Expand [ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 0) - 2) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 0) - 2) * 30000000) + 60000000), LongType, TimestampType)), timestamp#1-T3000ms, hostname#140, bytes#175), ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 1) - 2) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 1) - 2) * 30000000) + 60000000), LongType, TimestampType)), timestamp#1-T3000ms, hostname#140, bytes#175)], [window#859-T3000ms, timestamp#1-T3000ms, hostname#140, bytes#175]
               +- Project [timestamp#1-T3000ms, split(logs#5, ,, -1)[1] AS hostname#140, split(logs#5, ,, -1)[6] AS bytes#175]
                  +- EventTimeWatermark timestamp#1: timestamp, 3 seconds
                     +- Project [logs#5, timestamp#1]
                        +- Generate explode(split(value#0,  , -1)), [0], false, [logs#5]
                           +- StreamingDataSourceV2Relation [value#0, timestamp#1], org.apache.spark.sql.execution.streaming.sources.TextSocketTable$$anon$1@6b3ca49a, TextSocketV2[host: stream-emulator.data-science-tools.svc.cluster.local, port: 5551], 63, 78

== Physical Plan ==
WriteToDataSourceV2 org.apache.spark.sql.execution.streaming.sources.MicroBatchWrite@1b685a73
+- *(7) Sort [total_bytes#858 DESC NULLS LAST], true, 0
   +- Exchange rangepartitioning(total_bytes#858 DESC NULLS LAST, 200), true, [id=#1545]
      +- *(6) HashAggregate(keys=[window#859-T3000ms, hostname#140], functions=[sum(cast(bytes#175 as double))], output=[window#847-T3000ms, hostname#140, total_bytes#858])
         +- StateStoreSave [window#859-T3000ms, hostname#140], state info [ checkpoint = file:/tmp/temporary-fcb72abb-9143-4d38-a65d-25baf17e34c7/state, runId = 49431645-20e3-4737-9dcc-8f334da22f1d, opId = 0, ver = 5, numPartitions = 200], Complete, 1733343600102, 2
            +- *(5) HashAggregate(keys=[window#859-T3000ms, hostname#140], functions=[merge_sum(cast(bytes#175 as double))], output=[window#859-T3000ms, hostname#140, sum#869])
               +- StateStoreRestore [window#859-T3000ms, hostname#140], state info [ checkpoint = file:/tmp/temporary-fcb72abb-9143-4d38-a65d-25baf17e34c7/state, runId = 49431645-20e3-4737-9dcc-8f334da22f1d, opId = 0, ver = 5, numPartitions = 200], 2
                  +- *(4) HashAggregate(keys=[window#859-T3000ms, hostname#140], functions=[merge_sum(cast(bytes#175 as double))], output=[window#859-T3000ms, hostname#140, sum#869])
                     +- Exchange hashpartitioning(window#859-T3000ms, hostname#140, 200), true, [id=#1533]
                        +- *(3) HashAggregate(keys=[window#859-T3000ms, hostname#140], functions=[partial_sum(cast(bytes#175 as double))], output=[window#859-T3000ms, hostname#140, sum#869])
                           +- *(3) Project [window#859-T3000ms, hostname#140, bytes#175]
                              +- *(3) Filter (((isnotnull(timestamp#1-T3000ms) AND isnotnull(window#859-T3000ms)) AND (timestamp#1-T3000ms >= window#859-T3000ms.start)) AND (timestamp#1-T3000ms < window#859-T3000ms.end))
                                 +- *(3) Expand [ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 0) - 2) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 0) - 2) * 30000000) + 60000000), LongType, TimestampType)), timestamp#1-T3000ms, hostname#140, bytes#175), ArrayBuffer(named_struct(start, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 1) - 2) * 30000000) + 0), LongType, TimestampType), end, precisetimestampconversion(((((CASE WHEN (cast(CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) as double) = (cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) THEN (CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) + 1) ELSE CEIL((cast((precisetimestampconversion(timestamp#1-T3000ms, TimestampType, LongType) - 0) as double) / 3.0E7)) END + 1) - 2) * 30000000) + 60000000), LongType, TimestampType)), timestamp#1-T3000ms, hostname#140, bytes#175)], [window#859-T3000ms, timestamp#1-T3000ms, hostname#140, bytes#175]
                                    +- *(3) Project [timestamp#1-T3000ms, split(logs#5, ,, -1)[1] AS hostname#140, split(logs#5, ,, -1)[6] AS bytes#175]
                                       +- EventTimeWatermark timestamp#1: timestamp, 3 seconds
                                          +- *(2) Project [logs#5, timestamp#1]
                                             +- Generate explode(split(value#0,  , -1)), [timestamp#1], false, [logs#5]
                                                +- *(1) Project [value#0, timestamp#1]
                                                   +- MicroBatchScan[value#0, timestamp#1] class org.apache.spark.sql.execution.streaming.sources.TextSocketTable$$anon$1