== 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=2.5 KiB, rowCount=4)
: +- Exchange (13)
: +- * Project (12)
: +- * SortMergeJoin FullOuter (11)
: :- * Sort (5)
: : +- AQEShuffleRead (4)
: : +- ShuffleQueryStage (3), Statistics(sizeInBytes=2.4 KiB, rowCount=4)
: : +- Exchange (2)
: : +- LocalTableScan (1)
: +- * Sort (10)
: +- AQEShuffleRead (9)
: +- ShuffleQueryStage (8), Statistics(sizeInBytes=192.0 B, rowCount=4)
: +- Exchange (7)
: +- LocalTableScan (6)
+- * Sort (21)
+- AQEShuffleRead (20)
+- ShuffleQueryStage (19), Statistics(sizeInBytes=256.0 B, rowCount=4)
+- 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#68868, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L]
Arguments: [jobId#68868, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, ... 48 more fields]
(2) Exchange
Input [73]: [jobId#68868, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L]
Arguments: hashpartitioning(jobId#68868, 20), ENSURE_REQUIREMENTS, [plan_id=27415]
(3) ShuffleQueryStage
Output [73]: [jobId#68868, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L]
Arguments: 0
(4) AQEShuffleRead
Input [73]: [jobId#68868, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L]
Arguments: coalesced
(5) Sort [codegen id : 1]
Input [73]: [jobId#68868, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L]
Arguments: [jobId#68868 ASC NULLS FIRST], false, 0
(6) LocalTableScan
Output [4]: [jobId#68941, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: [jobId#68941, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
(7) Exchange
Input [4]: [jobId#68941, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: hashpartitioning(jobId#68941, 20), ENSURE_REQUIREMENTS, [plan_id=27416]
(8) ShuffleQueryStage
Output [4]: [jobId#68941, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: 1
(9) AQEShuffleRead
Input [4]: [jobId#68941, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: coalesced
(10) Sort [codegen id : 2]
Input [4]: [jobId#68941, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: [jobId#68941 ASC NULLS FIRST], false, 0
(11) SortMergeJoin [codegen id : 3]
Left keys [1]: [jobId#68868]
Right keys [1]: [jobId#68941]
Join type: FullOuter
Join condition: None
(12) Project [codegen id : 3]
Output [76]: [coalesce(jobId#68868, jobId#68941) AS jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Input [77]: [jobId#68868, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, jobId#68941, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
(13) Exchange
Input [76]: [jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: hashpartitioning(jobId#68951, 20), ENSURE_REQUIREMENTS, [plan_id=27579]
(14) ShuffleQueryStage
Output [76]: [jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: 3
(15) AQEShuffleRead
Input [76]: [jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: coalesced
(16) Sort [codegen id : 4]
Input [76]: [jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: [jobId#68951 ASC NULLS FIRST], false, 0
(17) LocalTableScan
Output [6]: [jobId#68945, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950]
Arguments: [jobId#68945, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950]
(18) Exchange
Input [6]: [jobId#68945, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950]
Arguments: hashpartitioning(jobId#68945, 20), ENSURE_REQUIREMENTS, [plan_id=27424]
(19) ShuffleQueryStage
Output [6]: [jobId#68945, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950]
Arguments: 2
(20) AQEShuffleRead
Input [6]: [jobId#68945, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950]
Arguments: coalesced
(21) Sort [codegen id : 5]
Input [6]: [jobId#68945, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950]
Arguments: [jobId#68945 ASC NULLS FIRST], false, 0
(22) SortMergeJoin [codegen id : 6]
Left keys [1]: [jobId#68951]
Right keys [1]: [jobId#68945]
Join type: FullOuter
Join condition: None
(23) Project [codegen id : 6]
Output [92]: [coalesce(jobId#68951, jobId#68945) AS jobId#68952, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950, 10000002107 AS replenishmentRunId#68953L, 6944346648028224943 AS tenantId#68954, 8378 AS cornerstoneTenantId#68955L, Daily_grocery AS marketUnit#68956, STANDARD AS scenario#68957, 52450e05-18fb-376e-8776-55724393a71c AS activityId#68958, RunStreamWithId AS activityType#68959, CalculateOrderProposalsWorkflow AS workflowType#68960, 46aae8d5-2a38-3d98-8114-7c8102691886 AS workflowId#68961, 1 AS activityAttempt#68962, AS gitCommitId#68964]
Input [82]: [jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L, jobId#68945, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950]
(24) Sort [codegen id : 6]
Input [92]: [jobId#68952, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950, replenishmentRunId#68953L, tenantId#68954, cornerstoneTenantId#68955L, marketUnit#68956, scenario#68957, activityId#68958, activityType#68959, workflowType#68960, workflowId#68961, activityAttempt#68962, gitCommitId#68964]
Arguments: [activityType#68959 ASC NULLS FIRST], false, 0
(25) WriteFiles
Input [92]: [jobId#68952, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950, replenishmentRunId#68953L, tenantId#68954, cornerstoneTenantId#68955L, marketUnit#68956, scenario#68957, activityId#68958, activityType#68959, workflowType#68960, workflowId#68961, activityAttempt#68962, gitCommitId#68964]
(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#68959], 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#68868, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L]
Arguments: [jobId#68868 ASC NULLS FIRST], false, 0
(29) Sort
Input [4]: [jobId#68941, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: [jobId#68941 ASC NULLS FIRST], false, 0
(30) SortMergeJoin
Left keys [1]: [jobId#68868]
Right keys [1]: [jobId#68941]
Join type: FullOuter
Join condition: None
(31) Project
Output [76]: [coalesce(jobId#68868, jobId#68941) AS jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Input [77]: [jobId#68868, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, jobId#68941, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
(32) Exchange
Input [76]: [jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: hashpartitioning(jobId#68951, 20), ENSURE_REQUIREMENTS, [plan_id=27423]
(33) Sort
Input [76]: [jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L]
Arguments: [jobId#68951 ASC NULLS FIRST], false, 0
(34) Sort
Input [6]: [jobId#68945, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950]
Arguments: [jobId#68945 ASC NULLS FIRST], false, 0
(35) SortMergeJoin
Left keys [1]: [jobId#68951]
Right keys [1]: [jobId#68945]
Join type: FullOuter
Join condition: None
(36) Project
Output [92]: [coalesce(jobId#68951, jobId#68945) AS jobId#68952, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950, 10000002107 AS replenishmentRunId#68953L, 6944346648028224943 AS tenantId#68954, 8378 AS cornerstoneTenantId#68955L, Daily_grocery AS marketUnit#68956, STANDARD AS scenario#68957, 52450e05-18fb-376e-8776-55724393a71c AS activityId#68958, RunStreamWithId AS activityType#68959, CalculateOrderProposalsWorkflow AS workflowType#68960, 46aae8d5-2a38-3d98-8114-7c8102691886 AS workflowId#68961, 1 AS activityAttempt#68962, AS gitCommitId#68964]
Input [82]: [jobId#68951, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L, jobId#68945, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950]
(37) Sort
Input [92]: [jobId#68952, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950, replenishmentRunId#68953L, tenantId#68954, cornerstoneTenantId#68955L, marketUnit#68956, scenario#68957, activityId#68958, activityType#68959, workflowType#68960, workflowId#68961, activityAttempt#68962, gitCommitId#68964]
Arguments: [activityType#68959 ASC NULLS FIRST], false, 0
(38) WriteFiles
Input [92]: [jobId#68952, stageCount#68869L, totalTaskCount#68870L, minTaskCountPerStage#68871L, maxTaskCountPerStage#68872L, medianTaskCountPerStage#68873L, bytesSpilledToDiskSerializedTotal#68874L, bytesSpilledToDiskSerializedMin#68875L, bytesSpilledToDiskSerializedMax#68876L, bytesSpilledToDiskSerializedMedian#68877L, taskCpuTimeTotal#68878L, taskCpuTimeMin#68879L, taskCpuTimeMax#68880L, taskCpuTimeMedian#68881L, taskDeserializeCpuTimeTotal#68882L, taskDeserializeCpuTimeMin#68883L, taskDeserializeCpuTimeMax#68884L, taskDeserializeCpuTimeMedian#68885L, taskDeserializeTimeTotal#68886L, taskDeserializeTimeMin#68887L, taskDeserializeTimeMax#68888L, taskDeserializeTimeMedian#68889L, taskRunTimeTotal#68890L, taskRunTimeMin#68891L, taskRunTimeMax#68892L, taskRunTimeMedian#68893L, jvmGcTimeTotal#68894L, jvmGcTimeMin#68895L, jvmGcTimeMax#68896L, jvmGcTimeMedian#68897L, bytesSpilledToDiskRawTotal#68898L, bytesSpilledToDiskRawMin#68899L, bytesSpilledToDiskRawMax#68900L, bytesSpilledToDiskRawMedian#68901L, resultSerializationTimeTotal#68902L, resultSerializationTimeMin#68903L, resultSerializationTimeMax#68904L, resultSerializationTimeMedian#68905L, resultSizeToDriverTotal#68906L, resultSizeToDriverMin#68907L, resultSizeToDriverMax#68908L, resultSizeToDriverMedian#68909L, taskPeakExecutionMemoryMin#68910L, taskPeakExecutionMemoryMax#68911L, taskPeakExecutionMemoryMedian#68912L, persistencyBytesReadTotal#68913L, persistencyBytesReadMin#68914L, persistencyBytesReadMax#68915L, persistencyBytesReadMedian#68916L, persistencyRecordsReadTotal#68917L, persistencyRecordsReadMin#68918L, persistencyRecordsReadMax#68919L, persistencyRecordsReadMedian#68920L, persistencyBytesWrittenTotal#68921L, persistencyBytesWrittenMin#68922L, persistencyBytesWrittenMax#68923L, persistencyBytesWrittenMedian#68924L, persistencyRecordsWrittenTotal#68925L, persistencyRecordsWrittenMin#68926L, persistencyRecordsWrittenMax#68927L, persistencyRecordsWrittenMedian#68928L, shuffleConsumeRecordsReadTotal#68929L, shuffleConsumeRemoteBlocksFetchedTotal#68930L, shuffleConsumeLocalBlocksFetchedTotal#68931L, shuffleConsumeTotalBlocksFetchedTotal#68932L, shuffleConsumeRemoteBytesReadTotal#68933L, shuffleConsumeLocalBytesReadTotal#68934L, shuffleConsumeTotalBytesReadTotal#68935L, shuffleConsumeRemoteBytesReadToDiskTotal#68936L, shuffleConsumeFetchWaitTimeTotal#68937L, shuffleProduceBytesWrittenTotal#68938L, shuffleProduceRecordsWrittenTotal#68939L, shuffleProduceWriteTimeTotal#68940L, peakExecutionMemory#68942L, peakExecutionMemoryCliqueDuration#68943L, peakExecutionMemoryCliqueSize#68944L, rddStorageDiskSizeTotal#68946L, rddStorageMemSizeTotal#68947L, rddNumCachedPartitionsTotal#68948, rddNumPartitionsTotal#68949, numberOfExecutors#68950, replenishmentRunId#68953L, tenantId#68954, cornerstoneTenantId#68955L, marketUnit#68956, scenario#68957, activityId#68958, activityType#68959, workflowType#68960, workflowId#68961, activityAttempt#68962, gitCommitId#68964]
(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#68959], 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