== 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=25.3 KiB, rowCount=41)
: +- Exchange (13)
: +- * Project (12)
: +- * SortMergeJoin FullOuter (11)
: :- * Sort (5)
: : +- AQEShuffleRead (4)
: : +- ShuffleQueryStage (3), Statistics(sizeInBytes=24.3 KiB, rowCount=41)
: : +- Exchange (2)
: : +- LocalTableScan (1)
: +- * Sort (10)
: +- AQEShuffleRead (9)
: +- ShuffleQueryStage (8), Statistics(sizeInBytes=1968.0 B, rowCount=41)
: +- Exchange (7)
: +- LocalTableScan (6)
+- * Sort (21)
+- AQEShuffleRead (20)
+- ShuffleQueryStage (19), Statistics(sizeInBytes=2.6 KiB, rowCount=41)
+- 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#912185, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L]
Arguments: [jobId#912185, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, ... 48 more fields]
(2) Exchange
Input [73]: [jobId#912185, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L]
Arguments: hashpartitioning(jobId#912185, 25), ENSURE_REQUIREMENTS, [plan_id=355899]
(3) ShuffleQueryStage
Output [73]: [jobId#912185, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L]
Arguments: 0
(4) AQEShuffleRead
Input [73]: [jobId#912185, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L]
Arguments: coalesced
(5) Sort [codegen id : 1]
Input [73]: [jobId#912185, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L]
Arguments: [jobId#912185 ASC NULLS FIRST], false, 0
(6) LocalTableScan
Output [4]: [jobId#912258, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: [jobId#912258, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
(7) Exchange
Input [4]: [jobId#912258, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: hashpartitioning(jobId#912258, 25), ENSURE_REQUIREMENTS, [plan_id=355900]
(8) ShuffleQueryStage
Output [4]: [jobId#912258, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: 1
(9) AQEShuffleRead
Input [4]: [jobId#912258, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: coalesced
(10) Sort [codegen id : 2]
Input [4]: [jobId#912258, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: [jobId#912258 ASC NULLS FIRST], false, 0
(11) SortMergeJoin [codegen id : 3]
Left keys [1]: [jobId#912185]
Right keys [1]: [jobId#912258]
Join type: FullOuter
Join condition: None
(12) Project [codegen id : 3]
Output [76]: [coalesce(jobId#912185, jobId#912258) AS jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Input [77]: [jobId#912185, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, jobId#912258, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
(13) Exchange
Input [76]: [jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: hashpartitioning(jobId#912268, 25), ENSURE_REQUIREMENTS, [plan_id=356104]
(14) ShuffleQueryStage
Output [76]: [jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: 3
(15) AQEShuffleRead
Input [76]: [jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: coalesced
(16) Sort [codegen id : 4]
Input [76]: [jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: [jobId#912268 ASC NULLS FIRST], false, 0
(17) LocalTableScan
Output [6]: [jobId#912262, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267]
Arguments: [jobId#912262, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267]
(18) Exchange
Input [6]: [jobId#912262, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267]
Arguments: hashpartitioning(jobId#912262, 25), ENSURE_REQUIREMENTS, [plan_id=355908]
(19) ShuffleQueryStage
Output [6]: [jobId#912262, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267]
Arguments: 2
(20) AQEShuffleRead
Input [6]: [jobId#912262, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267]
Arguments: coalesced
(21) Sort [codegen id : 5]
Input [6]: [jobId#912262, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267]
Arguments: [jobId#912262 ASC NULLS FIRST], false, 0
(22) SortMergeJoin [codegen id : 6]
Left keys [1]: [jobId#912268]
Right keys [1]: [jobId#912262]
Join type: FullOuter
Join condition: None
(23) Project [codegen id : 6]
Output [92]: [coalesce(jobId#912268, jobId#912262) AS jobId#912269, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267, 10000002110 AS replenishmentRunId#912270L, 6944346648028224943 AS tenantId#912271, 8378 AS cornerstoneTenantId#912272L, KA_REVIEW_CW31 AS marketUnit#912273, STANDARD AS scenario#912274, 5f814697-dfbb-368a-80a8-cd3d5f52c0b6 AS activityId#912275, CreateOrderProposalShards AS activityType#912276, CalculateOrderProposalsWorkflow AS workflowType#912277, afe967c1-e992-35fd-8b62-b2a49c5d9666 AS workflowId#912278, 1 AS activityAttempt#912279, AS gitCommitId#912281]
Input [82]: [jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L, jobId#912262, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267]
(24) Sort [codegen id : 6]
Input [92]: [jobId#912269, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267, replenishmentRunId#912270L, tenantId#912271, cornerstoneTenantId#912272L, marketUnit#912273, scenario#912274, activityId#912275, activityType#912276, workflowType#912277, workflowId#912278, activityAttempt#912279, gitCommitId#912281]
Arguments: [activityType#912276 ASC NULLS FIRST], false, 0
(25) WriteFiles
Input [92]: [jobId#912269, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267, replenishmentRunId#912270L, tenantId#912271, cornerstoneTenantId#912272L, marketUnit#912273, scenario#912274, activityId#912275, activityType#912276, workflowType#912277, workflowId#912278, activityAttempt#912279, gitCommitId#912281]
(26) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/internal/performance-metrics/10000002110, false, [activityType#912276], Parquet, [__partition_columns=["activityType"], path=hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/internal/performance-metrics/10000002110], 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#912185, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L]
Arguments: [jobId#912185 ASC NULLS FIRST], false, 0
(29) Sort
Input [4]: [jobId#912258, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: [jobId#912258 ASC NULLS FIRST], false, 0
(30) SortMergeJoin
Left keys [1]: [jobId#912185]
Right keys [1]: [jobId#912258]
Join type: FullOuter
Join condition: None
(31) Project
Output [76]: [coalesce(jobId#912185, jobId#912258) AS jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Input [77]: [jobId#912185, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, jobId#912258, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
(32) Exchange
Input [76]: [jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: hashpartitioning(jobId#912268, 25), ENSURE_REQUIREMENTS, [plan_id=355907]
(33) Sort
Input [76]: [jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L]
Arguments: [jobId#912268 ASC NULLS FIRST], false, 0
(34) Sort
Input [6]: [jobId#912262, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267]
Arguments: [jobId#912262 ASC NULLS FIRST], false, 0
(35) SortMergeJoin
Left keys [1]: [jobId#912268]
Right keys [1]: [jobId#912262]
Join type: FullOuter
Join condition: None
(36) Project
Output [92]: [coalesce(jobId#912268, jobId#912262) AS jobId#912269, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267, 10000002110 AS replenishmentRunId#912270L, 6944346648028224943 AS tenantId#912271, 8378 AS cornerstoneTenantId#912272L, KA_REVIEW_CW31 AS marketUnit#912273, STANDARD AS scenario#912274, 5f814697-dfbb-368a-80a8-cd3d5f52c0b6 AS activityId#912275, CreateOrderProposalShards AS activityType#912276, CalculateOrderProposalsWorkflow AS workflowType#912277, afe967c1-e992-35fd-8b62-b2a49c5d9666 AS workflowId#912278, 1 AS activityAttempt#912279, AS gitCommitId#912281]
Input [82]: [jobId#912268, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L, jobId#912262, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267]
(37) Sort
Input [92]: [jobId#912269, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267, replenishmentRunId#912270L, tenantId#912271, cornerstoneTenantId#912272L, marketUnit#912273, scenario#912274, activityId#912275, activityType#912276, workflowType#912277, workflowId#912278, activityAttempt#912279, gitCommitId#912281]
Arguments: [activityType#912276 ASC NULLS FIRST], false, 0
(38) WriteFiles
Input [92]: [jobId#912269, stageCount#912186L, totalTaskCount#912187L, minTaskCountPerStage#912188L, maxTaskCountPerStage#912189L, medianTaskCountPerStage#912190L, bytesSpilledToDiskSerializedTotal#912191L, bytesSpilledToDiskSerializedMin#912192L, bytesSpilledToDiskSerializedMax#912193L, bytesSpilledToDiskSerializedMedian#912194L, taskCpuTimeTotal#912195L, taskCpuTimeMin#912196L, taskCpuTimeMax#912197L, taskCpuTimeMedian#912198L, taskDeserializeCpuTimeTotal#912199L, taskDeserializeCpuTimeMin#912200L, taskDeserializeCpuTimeMax#912201L, taskDeserializeCpuTimeMedian#912202L, taskDeserializeTimeTotal#912203L, taskDeserializeTimeMin#912204L, taskDeserializeTimeMax#912205L, taskDeserializeTimeMedian#912206L, taskRunTimeTotal#912207L, taskRunTimeMin#912208L, taskRunTimeMax#912209L, taskRunTimeMedian#912210L, jvmGcTimeTotal#912211L, jvmGcTimeMin#912212L, jvmGcTimeMax#912213L, jvmGcTimeMedian#912214L, bytesSpilledToDiskRawTotal#912215L, bytesSpilledToDiskRawMin#912216L, bytesSpilledToDiskRawMax#912217L, bytesSpilledToDiskRawMedian#912218L, resultSerializationTimeTotal#912219L, resultSerializationTimeMin#912220L, resultSerializationTimeMax#912221L, resultSerializationTimeMedian#912222L, resultSizeToDriverTotal#912223L, resultSizeToDriverMin#912224L, resultSizeToDriverMax#912225L, resultSizeToDriverMedian#912226L, taskPeakExecutionMemoryMin#912227L, taskPeakExecutionMemoryMax#912228L, taskPeakExecutionMemoryMedian#912229L, persistencyBytesReadTotal#912230L, persistencyBytesReadMin#912231L, persistencyBytesReadMax#912232L, persistencyBytesReadMedian#912233L, persistencyRecordsReadTotal#912234L, persistencyRecordsReadMin#912235L, persistencyRecordsReadMax#912236L, persistencyRecordsReadMedian#912237L, persistencyBytesWrittenTotal#912238L, persistencyBytesWrittenMin#912239L, persistencyBytesWrittenMax#912240L, persistencyBytesWrittenMedian#912241L, persistencyRecordsWrittenTotal#912242L, persistencyRecordsWrittenMin#912243L, persistencyRecordsWrittenMax#912244L, persistencyRecordsWrittenMedian#912245L, shuffleConsumeRecordsReadTotal#912246L, shuffleConsumeRemoteBlocksFetchedTotal#912247L, shuffleConsumeLocalBlocksFetchedTotal#912248L, shuffleConsumeTotalBlocksFetchedTotal#912249L, shuffleConsumeRemoteBytesReadTotal#912250L, shuffleConsumeLocalBytesReadTotal#912251L, shuffleConsumeTotalBytesReadTotal#912252L, shuffleConsumeRemoteBytesReadToDiskTotal#912253L, shuffleConsumeFetchWaitTimeTotal#912254L, shuffleProduceBytesWrittenTotal#912255L, shuffleProduceRecordsWrittenTotal#912256L, shuffleProduceWriteTimeTotal#912257L, peakExecutionMemory#912259L, peakExecutionMemoryCliqueDuration#912260L, peakExecutionMemoryCliqueSize#912261L, rddStorageDiskSizeTotal#912263L, rddStorageMemSizeTotal#912264L, rddNumCachedPartitionsTotal#912265, rddNumPartitionsTotal#912266, numberOfExecutors#912267, replenishmentRunId#912270L, tenantId#912271, cornerstoneTenantId#912272L, marketUnit#912273, scenario#912274, activityId#912275, activityType#912276, workflowType#912277, workflowId#912278, activityAttempt#912279, gitCommitId#912281]
(39) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/internal/performance-metrics/10000002110, false, [activityType#912276], Parquet, [__partition_columns=["activityType"], path=hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/internal/performance-metrics/10000002110], 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