== Physical Plan ==
AdaptiveSparkPlan (40)
+- == Final Plan ==
ResultQueryStage (27), Statistics(sizeInBytes=8.0 EiB)
+- Execute InsertIntoHadoopFsRelationCommand (26)
+- WriteFiles (25)
+- * Sort (24)
+- * Project (23)
+- * SortMergeJoin FullOuter (22)
:- * Sort (16)
: +- AQEShuffleRead (15)
: +- ShuffleQueryStage (14), Statistics(sizeInBytes=13.0 KiB, rowCount=21)
: +- Exchange (13)
: +- * Project (12)
: +- * SortMergeJoin FullOuter (11)
: :- * Sort (5)
: : +- AQEShuffleRead (4)
: : +- ShuffleQueryStage (3), Statistics(sizeInBytes=12.5 KiB, rowCount=21)
: : +- Exchange (2)
: : +- LocalTableScan (1)
: +- * Sort (10)
: +- AQEShuffleRead (9)
: +- ShuffleQueryStage (8), Statistics(sizeInBytes=1008.0 B, rowCount=21)
: +- Exchange (7)
: +- LocalTableScan (6)
+- * Sort (21)
+- AQEShuffleRead (20)
+- ShuffleQueryStage (19), Statistics(sizeInBytes=1344.0 B, rowCount=21)
+- Exchange (18)
+- LocalTableScan (17)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (39)
+- WriteFiles (38)
+- Sort (37)
+- Project (36)
+- SortMergeJoin FullOuter (35)
:- Sort (33)
: +- Exchange (32)
: +- Project (31)
: +- SortMergeJoin FullOuter (30)
: :- Sort (28)
: : +- Exchange (2)
: : +- LocalTableScan (1)
: +- Sort (29)
: +- Exchange (7)
: +- LocalTableScan (6)
+- Sort (34)
+- Exchange (18)
+- LocalTableScan (17)
(1) LocalTableScan
Output [73]: [jobId#966840, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L]
Arguments: [jobId#966840, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, ... 48 more fields]
(2) Exchange
Input [73]: [jobId#966840, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L]
Arguments: hashpartitioning(jobId#966840, 37), ENSURE_REQUIREMENTS, [plan_id=1620529]
(3) ShuffleQueryStage
Output [73]: [jobId#966840, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L]
Arguments: 0
(4) AQEShuffleRead
Input [73]: [jobId#966840, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L]
Arguments: coalesced
(5) Sort [codegen id : 1]
Input [73]: [jobId#966840, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L]
Arguments: [jobId#966840 ASC NULLS FIRST], false, 0
(6) LocalTableScan
Output [4]: [jobId#966913, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: [jobId#966913, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
(7) Exchange
Input [4]: [jobId#966913, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: hashpartitioning(jobId#966913, 37), ENSURE_REQUIREMENTS, [plan_id=1620530]
(8) ShuffleQueryStage
Output [4]: [jobId#966913, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: 1
(9) AQEShuffleRead
Input [4]: [jobId#966913, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: coalesced
(10) Sort [codegen id : 2]
Input [4]: [jobId#966913, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: [jobId#966913 ASC NULLS FIRST], false, 0
(11) SortMergeJoin [codegen id : 3]
Left keys [1]: [jobId#966840]
Right keys [1]: [jobId#966913]
Join type: FullOuter
Join condition: None
(12) Project [codegen id : 3]
Output [76]: [coalesce(jobId#966840, jobId#966913) AS jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Input [77]: [jobId#966840, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, jobId#966913, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
(13) Exchange
Input [76]: [jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: hashpartitioning(jobId#966923, 37), ENSURE_REQUIREMENTS, [plan_id=1620734]
(14) ShuffleQueryStage
Output [76]: [jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: 3
(15) AQEShuffleRead
Input [76]: [jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: coalesced
(16) Sort [codegen id : 4]
Input [76]: [jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: [jobId#966923 ASC NULLS FIRST], false, 0
(17) LocalTableScan
Output [6]: [jobId#966917, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922]
Arguments: [jobId#966917, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922]
(18) Exchange
Input [6]: [jobId#966917, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922]
Arguments: hashpartitioning(jobId#966917, 37), ENSURE_REQUIREMENTS, [plan_id=1620538]
(19) ShuffleQueryStage
Output [6]: [jobId#966917, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922]
Arguments: 2
(20) AQEShuffleRead
Input [6]: [jobId#966917, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922]
Arguments: coalesced
(21) Sort [codegen id : 5]
Input [6]: [jobId#966917, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922]
Arguments: [jobId#966917 ASC NULLS FIRST], false, 0
(22) SortMergeJoin [codegen id : 6]
Left keys [1]: [jobId#966923]
Right keys [1]: [jobId#966917]
Join type: FullOuter
Join condition: None
(23) Project [codegen id : 6]
Output [92]: [coalesce(jobId#966923, jobId#966917) AS jobId#966924, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922, 10000000678 AS replenishmentRunId#966925L, 6951945722030153353 AS tenantId#966926, 8468 AS cornerstoneTenantId#966927L, IW_MU_CRP-125444_1 AS marketUnit#966928, STANDARD AS scenario#966929, aded1321-bd2b-35de-a087-438f85924892 AS activityId#966930, RunStreamWithId AS activityType#966931, CalculateOrderProposalsWorkflow AS workflowType#966932, 0020c3ec-5ab0-324c-997b-beeff7b311d9 AS workflowId#966933, 1 AS activityAttempt#966934, AS gitCommitId#966936]
Input [82]: [jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L, jobId#966917, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922]
(24) Sort [codegen id : 6]
Input [92]: [jobId#966924, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922, replenishmentRunId#966925L, tenantId#966926, cornerstoneTenantId#966927L, marketUnit#966928, scenario#966929, activityId#966930, activityType#966931, workflowType#966932, workflowId#966933, activityAttempt#966934, gitCommitId#966936]
Arguments: [activityType#966931 ASC NULLS FIRST], false, 0
(25) WriteFiles
Input [92]: [jobId#966924, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922, replenishmentRunId#966925L, tenantId#966926, cornerstoneTenantId#966927L, marketUnit#966928, scenario#966929, activityId#966930, activityType#966931, workflowType#966932, workflowId#966933, activityAttempt#966934, gitCommitId#966936]
(26) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://770f0770-bd0c-456f-b83b-9649926e0857.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000678, false, [activityType#966931], Parquet, [__partition_columns=["activityType"], path=hdlfs://770f0770-bd0c-456f-b83b-9649926e0857.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000678], Append, [jobId, stageCount, totalTaskCount, minTaskCountPerStage, maxTaskCountPerStage, medianTaskCountPerStage, bytesSpilledToDiskSerializedTotal, bytesSpilledToDiskSerializedMin, bytesSpilledToDiskSerializedMax, bytesSpilledToDiskSerializedMedian, taskCpuTimeTotal, taskCpuTimeMin, taskCpuTimeMax, taskCpuTimeMedian, taskDeserializeCpuTimeTotal, taskDeserializeCpuTimeMin, taskDeserializeCpuTimeMax, taskDeserializeCpuTimeMedian, taskDeserializeTimeTotal, taskDeserializeTimeMin, taskDeserializeTimeMax, taskDeserializeTimeMedian, taskRunTimeTotal, taskRunTimeMin, taskRunTimeMax, ... 67 more fields]
(27) ResultQueryStage
Output: []
Arguments: 4
(28) Sort
Input [73]: [jobId#966840, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L]
Arguments: [jobId#966840 ASC NULLS FIRST], false, 0
(29) Sort
Input [4]: [jobId#966913, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: [jobId#966913 ASC NULLS FIRST], false, 0
(30) SortMergeJoin
Left keys [1]: [jobId#966840]
Right keys [1]: [jobId#966913]
Join type: FullOuter
Join condition: None
(31) Project
Output [76]: [coalesce(jobId#966840, jobId#966913) AS jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Input [77]: [jobId#966840, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, jobId#966913, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
(32) Exchange
Input [76]: [jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: hashpartitioning(jobId#966923, 37), ENSURE_REQUIREMENTS, [plan_id=1620537]
(33) Sort
Input [76]: [jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L]
Arguments: [jobId#966923 ASC NULLS FIRST], false, 0
(34) Sort
Input [6]: [jobId#966917, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922]
Arguments: [jobId#966917 ASC NULLS FIRST], false, 0
(35) SortMergeJoin
Left keys [1]: [jobId#966923]
Right keys [1]: [jobId#966917]
Join type: FullOuter
Join condition: None
(36) Project
Output [92]: [coalesce(jobId#966923, jobId#966917) AS jobId#966924, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922, 10000000678 AS replenishmentRunId#966925L, 6951945722030153353 AS tenantId#966926, 8468 AS cornerstoneTenantId#966927L, IW_MU_CRP-125444_1 AS marketUnit#966928, STANDARD AS scenario#966929, aded1321-bd2b-35de-a087-438f85924892 AS activityId#966930, RunStreamWithId AS activityType#966931, CalculateOrderProposalsWorkflow AS workflowType#966932, 0020c3ec-5ab0-324c-997b-beeff7b311d9 AS workflowId#966933, 1 AS activityAttempt#966934, AS gitCommitId#966936]
Input [82]: [jobId#966923, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L, jobId#966917, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922]
(37) Sort
Input [92]: [jobId#966924, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922, replenishmentRunId#966925L, tenantId#966926, cornerstoneTenantId#966927L, marketUnit#966928, scenario#966929, activityId#966930, activityType#966931, workflowType#966932, workflowId#966933, activityAttempt#966934, gitCommitId#966936]
Arguments: [activityType#966931 ASC NULLS FIRST], false, 0
(38) WriteFiles
Input [92]: [jobId#966924, stageCount#966841L, totalTaskCount#966842L, minTaskCountPerStage#966843L, maxTaskCountPerStage#966844L, medianTaskCountPerStage#966845L, bytesSpilledToDiskSerializedTotal#966846L, bytesSpilledToDiskSerializedMin#966847L, bytesSpilledToDiskSerializedMax#966848L, bytesSpilledToDiskSerializedMedian#966849L, taskCpuTimeTotal#966850L, taskCpuTimeMin#966851L, taskCpuTimeMax#966852L, taskCpuTimeMedian#966853L, taskDeserializeCpuTimeTotal#966854L, taskDeserializeCpuTimeMin#966855L, taskDeserializeCpuTimeMax#966856L, taskDeserializeCpuTimeMedian#966857L, taskDeserializeTimeTotal#966858L, taskDeserializeTimeMin#966859L, taskDeserializeTimeMax#966860L, taskDeserializeTimeMedian#966861L, taskRunTimeTotal#966862L, taskRunTimeMin#966863L, taskRunTimeMax#966864L, taskRunTimeMedian#966865L, jvmGcTimeTotal#966866L, jvmGcTimeMin#966867L, jvmGcTimeMax#966868L, jvmGcTimeMedian#966869L, bytesSpilledToDiskRawTotal#966870L, bytesSpilledToDiskRawMin#966871L, bytesSpilledToDiskRawMax#966872L, bytesSpilledToDiskRawMedian#966873L, resultSerializationTimeTotal#966874L, resultSerializationTimeMin#966875L, resultSerializationTimeMax#966876L, resultSerializationTimeMedian#966877L, resultSizeToDriverTotal#966878L, resultSizeToDriverMin#966879L, resultSizeToDriverMax#966880L, resultSizeToDriverMedian#966881L, taskPeakExecutionMemoryMin#966882L, taskPeakExecutionMemoryMax#966883L, taskPeakExecutionMemoryMedian#966884L, persistencyBytesReadTotal#966885L, persistencyBytesReadMin#966886L, persistencyBytesReadMax#966887L, persistencyBytesReadMedian#966888L, persistencyRecordsReadTotal#966889L, persistencyRecordsReadMin#966890L, persistencyRecordsReadMax#966891L, persistencyRecordsReadMedian#966892L, persistencyBytesWrittenTotal#966893L, persistencyBytesWrittenMin#966894L, persistencyBytesWrittenMax#966895L, persistencyBytesWrittenMedian#966896L, persistencyRecordsWrittenTotal#966897L, persistencyRecordsWrittenMin#966898L, persistencyRecordsWrittenMax#966899L, persistencyRecordsWrittenMedian#966900L, shuffleConsumeRecordsReadTotal#966901L, shuffleConsumeRemoteBlocksFetchedTotal#966902L, shuffleConsumeLocalBlocksFetchedTotal#966903L, shuffleConsumeTotalBlocksFetchedTotal#966904L, shuffleConsumeRemoteBytesReadTotal#966905L, shuffleConsumeLocalBytesReadTotal#966906L, shuffleConsumeTotalBytesReadTotal#966907L, shuffleConsumeRemoteBytesReadToDiskTotal#966908L, shuffleConsumeFetchWaitTimeTotal#966909L, shuffleProduceBytesWrittenTotal#966910L, shuffleProduceRecordsWrittenTotal#966911L, shuffleProduceWriteTimeTotal#966912L, peakExecutionMemory#966914L, peakExecutionMemoryCliqueDuration#966915L, peakExecutionMemoryCliqueSize#966916L, rddStorageDiskSizeTotal#966918L, rddStorageMemSizeTotal#966919L, rddNumCachedPartitionsTotal#966920, rddNumPartitionsTotal#966921, numberOfExecutors#966922, replenishmentRunId#966925L, tenantId#966926, cornerstoneTenantId#966927L, marketUnit#966928, scenario#966929, activityId#966930, activityType#966931, workflowType#966932, workflowId#966933, activityAttempt#966934, gitCommitId#966936]
(39) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://770f0770-bd0c-456f-b83b-9649926e0857.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000678, false, [activityType#966931], Parquet, [__partition_columns=["activityType"], path=hdlfs://770f0770-bd0c-456f-b83b-9649926e0857.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000678], Append, [jobId, stageCount, totalTaskCount, minTaskCountPerStage, maxTaskCountPerStage, medianTaskCountPerStage, bytesSpilledToDiskSerializedTotal, bytesSpilledToDiskSerializedMin, bytesSpilledToDiskSerializedMax, bytesSpilledToDiskSerializedMedian, taskCpuTimeTotal, taskCpuTimeMin, taskCpuTimeMax, taskCpuTimeMedian, taskDeserializeCpuTimeTotal, taskDeserializeCpuTimeMin, taskDeserializeCpuTimeMax, taskDeserializeCpuTimeMedian, taskDeserializeTimeTotal, taskDeserializeTimeMin, taskDeserializeTimeMax, taskDeserializeTimeMedian, taskRunTimeTotal, taskRunTimeMin, taskRunTimeMax, ... 67 more fields]
(40) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true