== 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=16.0 KiB, rowCount=26)
: +- Exchange (13)
: +- * Project (12)
: +- * SortMergeJoin FullOuter (11)
: :- * Sort (5)
: : +- AQEShuffleRead (4)
: : +- ShuffleQueryStage (3), Statistics(sizeInBytes=15.4 KiB, rowCount=26)
: : +- Exchange (2)
: : +- LocalTableScan (1)
: +- * Sort (10)
: +- AQEShuffleRead (9)
: +- ShuffleQueryStage (8), Statistics(sizeInBytes=1248.0 B, rowCount=26)
: +- Exchange (7)
: +- LocalTableScan (6)
+- * Sort (21)
+- AQEShuffleRead (20)
+- ShuffleQueryStage (19), Statistics(sizeInBytes=1664.0 B, rowCount=26)
+- 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#133779, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L]
Arguments: [jobId#133779, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, ... 48 more fields]
(2) Exchange
Input [73]: [jobId#133779, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L]
Arguments: hashpartitioning(jobId#133779, 20), ENSURE_REQUIREMENTS, [plan_id=211151]
(3) ShuffleQueryStage
Output [73]: [jobId#133779, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L]
Arguments: 0
(4) AQEShuffleRead
Input [73]: [jobId#133779, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L]
Arguments: coalesced
(5) Sort [codegen id : 1]
Input [73]: [jobId#133779, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L]
Arguments: [jobId#133779 ASC NULLS FIRST], false, 0
(6) LocalTableScan
Output [4]: [jobId#133852, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: [jobId#133852, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
(7) Exchange
Input [4]: [jobId#133852, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: hashpartitioning(jobId#133852, 20), ENSURE_REQUIREMENTS, [plan_id=211152]
(8) ShuffleQueryStage
Output [4]: [jobId#133852, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: 1
(9) AQEShuffleRead
Input [4]: [jobId#133852, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: coalesced
(10) Sort [codegen id : 2]
Input [4]: [jobId#133852, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: [jobId#133852 ASC NULLS FIRST], false, 0
(11) SortMergeJoin [codegen id : 3]
Left keys [1]: [jobId#133779]
Right keys [1]: [jobId#133852]
Join type: FullOuter
Join condition: None
(12) Project [codegen id : 3]
Output [76]: [coalesce(jobId#133779, jobId#133852) AS jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Input [77]: [jobId#133779, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, jobId#133852, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
(13) Exchange
Input [76]: [jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: hashpartitioning(jobId#133862, 20), ENSURE_REQUIREMENTS, [plan_id=211315]
(14) ShuffleQueryStage
Output [76]: [jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: 3
(15) AQEShuffleRead
Input [76]: [jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: coalesced
(16) Sort [codegen id : 4]
Input [76]: [jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: [jobId#133862 ASC NULLS FIRST], false, 0
(17) LocalTableScan
Output [6]: [jobId#133856, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861]
Arguments: [jobId#133856, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861]
(18) Exchange
Input [6]: [jobId#133856, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861]
Arguments: hashpartitioning(jobId#133856, 20), ENSURE_REQUIREMENTS, [plan_id=211160]
(19) ShuffleQueryStage
Output [6]: [jobId#133856, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861]
Arguments: 2
(20) AQEShuffleRead
Input [6]: [jobId#133856, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861]
Arguments: coalesced
(21) Sort [codegen id : 5]
Input [6]: [jobId#133856, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861]
Arguments: [jobId#133856 ASC NULLS FIRST], false, 0
(22) SortMergeJoin [codegen id : 6]
Left keys [1]: [jobId#133862]
Right keys [1]: [jobId#133856]
Join type: FullOuter
Join condition: None
(23) Project [codegen id : 6]
Output [92]: [coalesce(jobId#133862, jobId#133856) AS jobId#133863, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861, 10000002107 AS replenishmentRunId#133864L, 6944346648028224943 AS tenantId#133865, 8378 AS cornerstoneTenantId#133866L, Daily_grocery AS marketUnit#133867, STANDARD AS scenario#133868, 52450e05-18fb-376e-8776-55724393a71c AS activityId#133869, RunStreamWithId AS activityType#133870, CalculateOrderProposalsWorkflow AS workflowType#133871, 46aae8d5-2a38-3d98-8114-7c8102691886 AS workflowId#133872, 1 AS activityAttempt#133873, AS gitCommitId#133875]
Input [82]: [jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L, jobId#133856, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861]
(24) Sort [codegen id : 6]
Input [92]: [jobId#133863, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861, replenishmentRunId#133864L, tenantId#133865, cornerstoneTenantId#133866L, marketUnit#133867, scenario#133868, activityId#133869, activityType#133870, workflowType#133871, workflowId#133872, activityAttempt#133873, gitCommitId#133875]
Arguments: [activityType#133870 ASC NULLS FIRST], false, 0
(25) WriteFiles
Input [92]: [jobId#133863, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861, replenishmentRunId#133864L, tenantId#133865, cornerstoneTenantId#133866L, marketUnit#133867, scenario#133868, activityId#133869, activityType#133870, workflowType#133871, workflowId#133872, activityAttempt#133873, gitCommitId#133875]
(26) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000002107, false, [activityType#133870], Parquet, [__partition_columns=["activityType"], path=hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000002107], 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#133779, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L]
Arguments: [jobId#133779 ASC NULLS FIRST], false, 0
(29) Sort
Input [4]: [jobId#133852, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: [jobId#133852 ASC NULLS FIRST], false, 0
(30) SortMergeJoin
Left keys [1]: [jobId#133779]
Right keys [1]: [jobId#133852]
Join type: FullOuter
Join condition: None
(31) Project
Output [76]: [coalesce(jobId#133779, jobId#133852) AS jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Input [77]: [jobId#133779, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, jobId#133852, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
(32) Exchange
Input [76]: [jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: hashpartitioning(jobId#133862, 20), ENSURE_REQUIREMENTS, [plan_id=211159]
(33) Sort
Input [76]: [jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L]
Arguments: [jobId#133862 ASC NULLS FIRST], false, 0
(34) Sort
Input [6]: [jobId#133856, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861]
Arguments: [jobId#133856 ASC NULLS FIRST], false, 0
(35) SortMergeJoin
Left keys [1]: [jobId#133862]
Right keys [1]: [jobId#133856]
Join type: FullOuter
Join condition: None
(36) Project
Output [92]: [coalesce(jobId#133862, jobId#133856) AS jobId#133863, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861, 10000002107 AS replenishmentRunId#133864L, 6944346648028224943 AS tenantId#133865, 8378 AS cornerstoneTenantId#133866L, Daily_grocery AS marketUnit#133867, STANDARD AS scenario#133868, 52450e05-18fb-376e-8776-55724393a71c AS activityId#133869, RunStreamWithId AS activityType#133870, CalculateOrderProposalsWorkflow AS workflowType#133871, 46aae8d5-2a38-3d98-8114-7c8102691886 AS workflowId#133872, 1 AS activityAttempt#133873, AS gitCommitId#133875]
Input [82]: [jobId#133862, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L, jobId#133856, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861]
(37) Sort
Input [92]: [jobId#133863, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861, replenishmentRunId#133864L, tenantId#133865, cornerstoneTenantId#133866L, marketUnit#133867, scenario#133868, activityId#133869, activityType#133870, workflowType#133871, workflowId#133872, activityAttempt#133873, gitCommitId#133875]
Arguments: [activityType#133870 ASC NULLS FIRST], false, 0
(38) WriteFiles
Input [92]: [jobId#133863, stageCount#133780L, totalTaskCount#133781L, minTaskCountPerStage#133782L, maxTaskCountPerStage#133783L, medianTaskCountPerStage#133784L, bytesSpilledToDiskSerializedTotal#133785L, bytesSpilledToDiskSerializedMin#133786L, bytesSpilledToDiskSerializedMax#133787L, bytesSpilledToDiskSerializedMedian#133788L, taskCpuTimeTotal#133789L, taskCpuTimeMin#133790L, taskCpuTimeMax#133791L, taskCpuTimeMedian#133792L, taskDeserializeCpuTimeTotal#133793L, taskDeserializeCpuTimeMin#133794L, taskDeserializeCpuTimeMax#133795L, taskDeserializeCpuTimeMedian#133796L, taskDeserializeTimeTotal#133797L, taskDeserializeTimeMin#133798L, taskDeserializeTimeMax#133799L, taskDeserializeTimeMedian#133800L, taskRunTimeTotal#133801L, taskRunTimeMin#133802L, taskRunTimeMax#133803L, taskRunTimeMedian#133804L, jvmGcTimeTotal#133805L, jvmGcTimeMin#133806L, jvmGcTimeMax#133807L, jvmGcTimeMedian#133808L, bytesSpilledToDiskRawTotal#133809L, bytesSpilledToDiskRawMin#133810L, bytesSpilledToDiskRawMax#133811L, bytesSpilledToDiskRawMedian#133812L, resultSerializationTimeTotal#133813L, resultSerializationTimeMin#133814L, resultSerializationTimeMax#133815L, resultSerializationTimeMedian#133816L, resultSizeToDriverTotal#133817L, resultSizeToDriverMin#133818L, resultSizeToDriverMax#133819L, resultSizeToDriverMedian#133820L, taskPeakExecutionMemoryMin#133821L, taskPeakExecutionMemoryMax#133822L, taskPeakExecutionMemoryMedian#133823L, persistencyBytesReadTotal#133824L, persistencyBytesReadMin#133825L, persistencyBytesReadMax#133826L, persistencyBytesReadMedian#133827L, persistencyRecordsReadTotal#133828L, persistencyRecordsReadMin#133829L, persistencyRecordsReadMax#133830L, persistencyRecordsReadMedian#133831L, persistencyBytesWrittenTotal#133832L, persistencyBytesWrittenMin#133833L, persistencyBytesWrittenMax#133834L, persistencyBytesWrittenMedian#133835L, persistencyRecordsWrittenTotal#133836L, persistencyRecordsWrittenMin#133837L, persistencyRecordsWrittenMax#133838L, persistencyRecordsWrittenMedian#133839L, shuffleConsumeRecordsReadTotal#133840L, shuffleConsumeRemoteBlocksFetchedTotal#133841L, shuffleConsumeLocalBlocksFetchedTotal#133842L, shuffleConsumeTotalBlocksFetchedTotal#133843L, shuffleConsumeRemoteBytesReadTotal#133844L, shuffleConsumeLocalBytesReadTotal#133845L, shuffleConsumeTotalBytesReadTotal#133846L, shuffleConsumeRemoteBytesReadToDiskTotal#133847L, shuffleConsumeFetchWaitTimeTotal#133848L, shuffleProduceBytesWrittenTotal#133849L, shuffleProduceRecordsWrittenTotal#133850L, shuffleProduceWriteTimeTotal#133851L, peakExecutionMemory#133853L, peakExecutionMemoryCliqueDuration#133854L, peakExecutionMemoryCliqueSize#133855L, rddStorageDiskSizeTotal#133857L, rddStorageMemSizeTotal#133858L, rddNumCachedPartitionsTotal#133859, rddNumPartitionsTotal#133860, numberOfExecutors#133861, replenishmentRunId#133864L, tenantId#133865, cornerstoneTenantId#133866L, marketUnit#133867, scenario#133868, activityId#133869, activityType#133870, workflowType#133871, workflowId#133872, activityAttempt#133873, gitCommitId#133875]
(39) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000002107, false, [activityType#133870], Parquet, [__partition_columns=["activityType"], path=hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000002107], 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