== 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=14.8 KiB, rowCount=24)
: +- Exchange (13)
: +- * Project (12)
: +- * SortMergeJoin FullOuter (11)
: :- * Sort (5)
: : +- AQEShuffleRead (4)
: : +- ShuffleQueryStage (3), Statistics(sizeInBytes=14.3 KiB, rowCount=24)
: : +- Exchange (2)
: : +- LocalTableScan (1)
: +- * Sort (10)
: +- AQEShuffleRead (9)
: +- ShuffleQueryStage (8), Statistics(sizeInBytes=1152.0 B, rowCount=24)
: +- Exchange (7)
: +- LocalTableScan (6)
+- * Sort (21)
+- AQEShuffleRead (20)
+- ShuffleQueryStage (19), Statistics(sizeInBytes=1536.0 B, rowCount=24)
+- 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#881971, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L]
Arguments: [jobId#881971, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, ... 48 more fields]
(2) Exchange
Input [73]: [jobId#881971, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L]
Arguments: hashpartitioning(jobId#881971, 37), ENSURE_REQUIREMENTS, [plan_id=1387588]
(3) ShuffleQueryStage
Output [73]: [jobId#881971, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L]
Arguments: 0
(4) AQEShuffleRead
Input [73]: [jobId#881971, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L]
Arguments: coalesced
(5) Sort [codegen id : 1]
Input [73]: [jobId#881971, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L]
Arguments: [jobId#881971 ASC NULLS FIRST], false, 0
(6) LocalTableScan
Output [4]: [jobId#882044, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: [jobId#882044, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
(7) Exchange
Input [4]: [jobId#882044, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: hashpartitioning(jobId#882044, 37), ENSURE_REQUIREMENTS, [plan_id=1387589]
(8) ShuffleQueryStage
Output [4]: [jobId#882044, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: 1
(9) AQEShuffleRead
Input [4]: [jobId#882044, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: coalesced
(10) Sort [codegen id : 2]
Input [4]: [jobId#882044, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: [jobId#882044 ASC NULLS FIRST], false, 0
(11) SortMergeJoin [codegen id : 3]
Left keys [1]: [jobId#881971]
Right keys [1]: [jobId#882044]
Join type: FullOuter
Join condition: None
(12) Project [codegen id : 3]
Output [76]: [coalesce(jobId#881971, jobId#882044) AS jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Input [77]: [jobId#881971, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, jobId#882044, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
(13) Exchange
Input [76]: [jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: hashpartitioning(jobId#882054, 37), ENSURE_REQUIREMENTS, [plan_id=1387793]
(14) ShuffleQueryStage
Output [76]: [jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: 3
(15) AQEShuffleRead
Input [76]: [jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: coalesced
(16) Sort [codegen id : 4]
Input [76]: [jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: [jobId#882054 ASC NULLS FIRST], false, 0
(17) LocalTableScan
Output [6]: [jobId#882048, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053]
Arguments: [jobId#882048, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053]
(18) Exchange
Input [6]: [jobId#882048, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053]
Arguments: hashpartitioning(jobId#882048, 37), ENSURE_REQUIREMENTS, [plan_id=1387597]
(19) ShuffleQueryStage
Output [6]: [jobId#882048, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053]
Arguments: 2
(20) AQEShuffleRead
Input [6]: [jobId#882048, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053]
Arguments: coalesced
(21) Sort [codegen id : 5]
Input [6]: [jobId#882048, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053]
Arguments: [jobId#882048 ASC NULLS FIRST], false, 0
(22) SortMergeJoin [codegen id : 6]
Left keys [1]: [jobId#882054]
Right keys [1]: [jobId#882048]
Join type: FullOuter
Join condition: None
(23) Project [codegen id : 6]
Output [92]: [coalesce(jobId#882054, jobId#882048) AS jobId#882055, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053, 10000000347 AS replenishmentRunId#882056L, 7233423560970044043 AS tenantId#882057, 8469 AS cornerstoneTenantId#882058L, STEPHI_MU AS marketUnit#882059, STANDARD AS scenario#882060, 9cfe86ea-f294-3eaf-a931-f395154bbeb6 AS activityId#882061, RunStreamWithId AS activityType#882062, CalculateOrderProposalsWorkflow AS workflowType#882063, dc3e00f8-08cf-3185-b0ed-f6fee1ddd61a AS workflowId#882064, 1 AS activityAttempt#882065, AS gitCommitId#882067]
Input [82]: [jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L, jobId#882048, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053]
(24) Sort [codegen id : 6]
Input [92]: [jobId#882055, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053, replenishmentRunId#882056L, tenantId#882057, cornerstoneTenantId#882058L, marketUnit#882059, scenario#882060, activityId#882061, activityType#882062, workflowType#882063, workflowId#882064, activityAttempt#882065, gitCommitId#882067]
Arguments: [activityType#882062 ASC NULLS FIRST], false, 0
(25) WriteFiles
Input [92]: [jobId#882055, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053, replenishmentRunId#882056L, tenantId#882057, cornerstoneTenantId#882058L, marketUnit#882059, scenario#882060, activityId#882061, activityType#882062, workflowType#882063, workflowId#882064, activityAttempt#882065, gitCommitId#882067]
(26) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000347, false, [activityType#882062], Parquet, [__partition_columns=["activityType"], path=hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000347], 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#881971, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L]
Arguments: [jobId#881971 ASC NULLS FIRST], false, 0
(29) Sort
Input [4]: [jobId#882044, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: [jobId#882044 ASC NULLS FIRST], false, 0
(30) SortMergeJoin
Left keys [1]: [jobId#881971]
Right keys [1]: [jobId#882044]
Join type: FullOuter
Join condition: None
(31) Project
Output [76]: [coalesce(jobId#881971, jobId#882044) AS jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Input [77]: [jobId#881971, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, jobId#882044, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
(32) Exchange
Input [76]: [jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: hashpartitioning(jobId#882054, 37), ENSURE_REQUIREMENTS, [plan_id=1387596]
(33) Sort
Input [76]: [jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L]
Arguments: [jobId#882054 ASC NULLS FIRST], false, 0
(34) Sort
Input [6]: [jobId#882048, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053]
Arguments: [jobId#882048 ASC NULLS FIRST], false, 0
(35) SortMergeJoin
Left keys [1]: [jobId#882054]
Right keys [1]: [jobId#882048]
Join type: FullOuter
Join condition: None
(36) Project
Output [92]: [coalesce(jobId#882054, jobId#882048) AS jobId#882055, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053, 10000000347 AS replenishmentRunId#882056L, 7233423560970044043 AS tenantId#882057, 8469 AS cornerstoneTenantId#882058L, STEPHI_MU AS marketUnit#882059, STANDARD AS scenario#882060, 9cfe86ea-f294-3eaf-a931-f395154bbeb6 AS activityId#882061, RunStreamWithId AS activityType#882062, CalculateOrderProposalsWorkflow AS workflowType#882063, dc3e00f8-08cf-3185-b0ed-f6fee1ddd61a AS workflowId#882064, 1 AS activityAttempt#882065, AS gitCommitId#882067]
Input [82]: [jobId#882054, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L, jobId#882048, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053]
(37) Sort
Input [92]: [jobId#882055, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053, replenishmentRunId#882056L, tenantId#882057, cornerstoneTenantId#882058L, marketUnit#882059, scenario#882060, activityId#882061, activityType#882062, workflowType#882063, workflowId#882064, activityAttempt#882065, gitCommitId#882067]
Arguments: [activityType#882062 ASC NULLS FIRST], false, 0
(38) WriteFiles
Input [92]: [jobId#882055, stageCount#881972L, totalTaskCount#881973L, minTaskCountPerStage#881974L, maxTaskCountPerStage#881975L, medianTaskCountPerStage#881976L, bytesSpilledToDiskSerializedTotal#881977L, bytesSpilledToDiskSerializedMin#881978L, bytesSpilledToDiskSerializedMax#881979L, bytesSpilledToDiskSerializedMedian#881980L, taskCpuTimeTotal#881981L, taskCpuTimeMin#881982L, taskCpuTimeMax#881983L, taskCpuTimeMedian#881984L, taskDeserializeCpuTimeTotal#881985L, taskDeserializeCpuTimeMin#881986L, taskDeserializeCpuTimeMax#881987L, taskDeserializeCpuTimeMedian#881988L, taskDeserializeTimeTotal#881989L, taskDeserializeTimeMin#881990L, taskDeserializeTimeMax#881991L, taskDeserializeTimeMedian#881992L, taskRunTimeTotal#881993L, taskRunTimeMin#881994L, taskRunTimeMax#881995L, taskRunTimeMedian#881996L, jvmGcTimeTotal#881997L, jvmGcTimeMin#881998L, jvmGcTimeMax#881999L, jvmGcTimeMedian#882000L, bytesSpilledToDiskRawTotal#882001L, bytesSpilledToDiskRawMin#882002L, bytesSpilledToDiskRawMax#882003L, bytesSpilledToDiskRawMedian#882004L, resultSerializationTimeTotal#882005L, resultSerializationTimeMin#882006L, resultSerializationTimeMax#882007L, resultSerializationTimeMedian#882008L, resultSizeToDriverTotal#882009L, resultSizeToDriverMin#882010L, resultSizeToDriverMax#882011L, resultSizeToDriverMedian#882012L, taskPeakExecutionMemoryMin#882013L, taskPeakExecutionMemoryMax#882014L, taskPeakExecutionMemoryMedian#882015L, persistencyBytesReadTotal#882016L, persistencyBytesReadMin#882017L, persistencyBytesReadMax#882018L, persistencyBytesReadMedian#882019L, persistencyRecordsReadTotal#882020L, persistencyRecordsReadMin#882021L, persistencyRecordsReadMax#882022L, persistencyRecordsReadMedian#882023L, persistencyBytesWrittenTotal#882024L, persistencyBytesWrittenMin#882025L, persistencyBytesWrittenMax#882026L, persistencyBytesWrittenMedian#882027L, persistencyRecordsWrittenTotal#882028L, persistencyRecordsWrittenMin#882029L, persistencyRecordsWrittenMax#882030L, persistencyRecordsWrittenMedian#882031L, shuffleConsumeRecordsReadTotal#882032L, shuffleConsumeRemoteBlocksFetchedTotal#882033L, shuffleConsumeLocalBlocksFetchedTotal#882034L, shuffleConsumeTotalBlocksFetchedTotal#882035L, shuffleConsumeRemoteBytesReadTotal#882036L, shuffleConsumeLocalBytesReadTotal#882037L, shuffleConsumeTotalBytesReadTotal#882038L, shuffleConsumeRemoteBytesReadToDiskTotal#882039L, shuffleConsumeFetchWaitTimeTotal#882040L, shuffleProduceBytesWrittenTotal#882041L, shuffleProduceRecordsWrittenTotal#882042L, shuffleProduceWriteTimeTotal#882043L, peakExecutionMemory#882045L, peakExecutionMemoryCliqueDuration#882046L, peakExecutionMemoryCliqueSize#882047L, rddStorageDiskSizeTotal#882049L, rddStorageMemSizeTotal#882050L, rddNumCachedPartitionsTotal#882051, rddNumPartitionsTotal#882052, numberOfExecutors#882053, replenishmentRunId#882056L, tenantId#882057, cornerstoneTenantId#882058L, marketUnit#882059, scenario#882060, activityId#882061, activityType#882062, workflowType#882063, workflowId#882064, activityAttempt#882065, gitCommitId#882067]
(39) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000347, false, [activityType#882062], Parquet, [__partition_columns=["activityType"], path=hdlfs://ced12e6d-bca7-47af-9525-449cba9023d7.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000347], 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