== 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=632.0 B, rowCount=1)
: +- Exchange (13)
: +- * Project (12)
: +- * SortMergeJoin FullOuter (11)
: :- * Sort (5)
: : +- AQEShuffleRead (4)
: : +- ShuffleQueryStage (3), Statistics(sizeInBytes=608.0 B, rowCount=1)
: : +- Exchange (2)
: : +- LocalTableScan (1)
: +- * Sort (10)
: +- AQEShuffleRead (9)
: +- ShuffleQueryStage (8), Statistics(sizeInBytes=48.0 B, rowCount=1)
: +- Exchange (7)
: +- LocalTableScan (6)
+- * Sort (21)
+- AQEShuffleRead (20)
+- ShuffleQueryStage (19), Statistics(sizeInBytes=64.0 B, rowCount=1)
+- 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#22646, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L]
Arguments: [jobId#22646, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, ... 48 more fields]
(2) Exchange
Input [73]: [jobId#22646, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L]
Arguments: hashpartitioning(jobId#22646, 37), ENSURE_REQUIREMENTS, [plan_id=16441]
(3) ShuffleQueryStage
Output [73]: [jobId#22646, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L]
Arguments: 0
(4) AQEShuffleRead
Input [73]: [jobId#22646, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L]
Arguments: coalesced
(5) Sort [codegen id : 1]
Input [73]: [jobId#22646, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L]
Arguments: [jobId#22646 ASC NULLS FIRST], false, 0
(6) LocalTableScan
Output [4]: [jobId#22719, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: [jobId#22719, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
(7) Exchange
Input [4]: [jobId#22719, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: hashpartitioning(jobId#22719, 37), ENSURE_REQUIREMENTS, [plan_id=16442]
(8) ShuffleQueryStage
Output [4]: [jobId#22719, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: 1
(9) AQEShuffleRead
Input [4]: [jobId#22719, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: coalesced
(10) Sort [codegen id : 2]
Input [4]: [jobId#22719, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: [jobId#22719 ASC NULLS FIRST], false, 0
(11) SortMergeJoin [codegen id : 3]
Left keys [1]: [jobId#22646]
Right keys [1]: [jobId#22719]
Join type: FullOuter
Join condition: None
(12) Project [codegen id : 3]
Output [76]: [coalesce(jobId#22646, jobId#22719) AS jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Input [77]: [jobId#22646, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, jobId#22719, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
(13) Exchange
Input [76]: [jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: hashpartitioning(jobId#22729, 37), ENSURE_REQUIREMENTS, [plan_id=16605]
(14) ShuffleQueryStage
Output [76]: [jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: 3
(15) AQEShuffleRead
Input [76]: [jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: coalesced
(16) Sort [codegen id : 4]
Input [76]: [jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: [jobId#22729 ASC NULLS FIRST], false, 0
(17) LocalTableScan
Output [6]: [jobId#22723, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728]
Arguments: [jobId#22723, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728]
(18) Exchange
Input [6]: [jobId#22723, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728]
Arguments: hashpartitioning(jobId#22723, 37), ENSURE_REQUIREMENTS, [plan_id=16450]
(19) ShuffleQueryStage
Output [6]: [jobId#22723, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728]
Arguments: 2
(20) AQEShuffleRead
Input [6]: [jobId#22723, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728]
Arguments: coalesced
(21) Sort [codegen id : 5]
Input [6]: [jobId#22723, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728]
Arguments: [jobId#22723 ASC NULLS FIRST], false, 0
(22) SortMergeJoin [codegen id : 6]
Left keys [1]: [jobId#22729]
Right keys [1]: [jobId#22723]
Join type: FullOuter
Join condition: None
(23) Project [codegen id : 6]
Output [92]: [coalesce(jobId#22729, jobId#22723) AS jobId#22730, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728, 10000001338 AS replenishmentRunId#22731L, 7233423560970044043 AS tenantId#22732, 8469 AS cornerstoneTenantId#22733L, MU_01 AS marketUnit#22734, STANDARD AS scenario#22735, 8d375b85-29f5-3916-bd97-9cc1e4eb0616 AS activityId#22736, PrepareStreams AS activityType#22737, CalculateOrderProposalsWorkflow AS workflowType#22738, 84c12296-0d1a-3dff-9c34-356ca71cbc58 AS workflowId#22739, 1 AS activityAttempt#22740, AS gitCommitId#22742]
Input [82]: [jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L, jobId#22723, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728]
(24) Sort [codegen id : 6]
Input [92]: [jobId#22730, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728, replenishmentRunId#22731L, tenantId#22732, cornerstoneTenantId#22733L, marketUnit#22734, scenario#22735, activityId#22736, activityType#22737, workflowType#22738, workflowId#22739, activityAttempt#22740, gitCommitId#22742]
Arguments: [activityType#22737 ASC NULLS FIRST], false, 0
(25) WriteFiles
Input [92]: [jobId#22730, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728, replenishmentRunId#22731L, tenantId#22732, cornerstoneTenantId#22733L, marketUnit#22734, scenario#22735, activityId#22736, activityType#22737, workflowType#22738, workflowId#22739, activityAttempt#22740, gitCommitId#22742]
(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/10000001338, false, [activityType#22737], 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/10000001338], 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#22646, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L]
Arguments: [jobId#22646 ASC NULLS FIRST], false, 0
(29) Sort
Input [4]: [jobId#22719, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: [jobId#22719 ASC NULLS FIRST], false, 0
(30) SortMergeJoin
Left keys [1]: [jobId#22646]
Right keys [1]: [jobId#22719]
Join type: FullOuter
Join condition: None
(31) Project
Output [76]: [coalesce(jobId#22646, jobId#22719) AS jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Input [77]: [jobId#22646, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, jobId#22719, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
(32) Exchange
Input [76]: [jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: hashpartitioning(jobId#22729, 37), ENSURE_REQUIREMENTS, [plan_id=16449]
(33) Sort
Input [76]: [jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L]
Arguments: [jobId#22729 ASC NULLS FIRST], false, 0
(34) Sort
Input [6]: [jobId#22723, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728]
Arguments: [jobId#22723 ASC NULLS FIRST], false, 0
(35) SortMergeJoin
Left keys [1]: [jobId#22729]
Right keys [1]: [jobId#22723]
Join type: FullOuter
Join condition: None
(36) Project
Output [92]: [coalesce(jobId#22729, jobId#22723) AS jobId#22730, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728, 10000001338 AS replenishmentRunId#22731L, 7233423560970044043 AS tenantId#22732, 8469 AS cornerstoneTenantId#22733L, MU_01 AS marketUnit#22734, STANDARD AS scenario#22735, 8d375b85-29f5-3916-bd97-9cc1e4eb0616 AS activityId#22736, PrepareStreams AS activityType#22737, CalculateOrderProposalsWorkflow AS workflowType#22738, 84c12296-0d1a-3dff-9c34-356ca71cbc58 AS workflowId#22739, 1 AS activityAttempt#22740, AS gitCommitId#22742]
Input [82]: [jobId#22729, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L, jobId#22723, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728]
(37) Sort
Input [92]: [jobId#22730, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728, replenishmentRunId#22731L, tenantId#22732, cornerstoneTenantId#22733L, marketUnit#22734, scenario#22735, activityId#22736, activityType#22737, workflowType#22738, workflowId#22739, activityAttempt#22740, gitCommitId#22742]
Arguments: [activityType#22737 ASC NULLS FIRST], false, 0
(38) WriteFiles
Input [92]: [jobId#22730, stageCount#22647L, totalTaskCount#22648L, minTaskCountPerStage#22649L, maxTaskCountPerStage#22650L, medianTaskCountPerStage#22651L, bytesSpilledToDiskSerializedTotal#22652L, bytesSpilledToDiskSerializedMin#22653L, bytesSpilledToDiskSerializedMax#22654L, bytesSpilledToDiskSerializedMedian#22655L, taskCpuTimeTotal#22656L, taskCpuTimeMin#22657L, taskCpuTimeMax#22658L, taskCpuTimeMedian#22659L, taskDeserializeCpuTimeTotal#22660L, taskDeserializeCpuTimeMin#22661L, taskDeserializeCpuTimeMax#22662L, taskDeserializeCpuTimeMedian#22663L, taskDeserializeTimeTotal#22664L, taskDeserializeTimeMin#22665L, taskDeserializeTimeMax#22666L, taskDeserializeTimeMedian#22667L, taskRunTimeTotal#22668L, taskRunTimeMin#22669L, taskRunTimeMax#22670L, taskRunTimeMedian#22671L, jvmGcTimeTotal#22672L, jvmGcTimeMin#22673L, jvmGcTimeMax#22674L, jvmGcTimeMedian#22675L, bytesSpilledToDiskRawTotal#22676L, bytesSpilledToDiskRawMin#22677L, bytesSpilledToDiskRawMax#22678L, bytesSpilledToDiskRawMedian#22679L, resultSerializationTimeTotal#22680L, resultSerializationTimeMin#22681L, resultSerializationTimeMax#22682L, resultSerializationTimeMedian#22683L, resultSizeToDriverTotal#22684L, resultSizeToDriverMin#22685L, resultSizeToDriverMax#22686L, resultSizeToDriverMedian#22687L, taskPeakExecutionMemoryMin#22688L, taskPeakExecutionMemoryMax#22689L, taskPeakExecutionMemoryMedian#22690L, persistencyBytesReadTotal#22691L, persistencyBytesReadMin#22692L, persistencyBytesReadMax#22693L, persistencyBytesReadMedian#22694L, persistencyRecordsReadTotal#22695L, persistencyRecordsReadMin#22696L, persistencyRecordsReadMax#22697L, persistencyRecordsReadMedian#22698L, persistencyBytesWrittenTotal#22699L, persistencyBytesWrittenMin#22700L, persistencyBytesWrittenMax#22701L, persistencyBytesWrittenMedian#22702L, persistencyRecordsWrittenTotal#22703L, persistencyRecordsWrittenMin#22704L, persistencyRecordsWrittenMax#22705L, persistencyRecordsWrittenMedian#22706L, shuffleConsumeRecordsReadTotal#22707L, shuffleConsumeRemoteBlocksFetchedTotal#22708L, shuffleConsumeLocalBlocksFetchedTotal#22709L, shuffleConsumeTotalBlocksFetchedTotal#22710L, shuffleConsumeRemoteBytesReadTotal#22711L, shuffleConsumeLocalBytesReadTotal#22712L, shuffleConsumeTotalBytesReadTotal#22713L, shuffleConsumeRemoteBytesReadToDiskTotal#22714L, shuffleConsumeFetchWaitTimeTotal#22715L, shuffleProduceBytesWrittenTotal#22716L, shuffleProduceRecordsWrittenTotal#22717L, shuffleProduceWriteTimeTotal#22718L, peakExecutionMemory#22720L, peakExecutionMemoryCliqueDuration#22721L, peakExecutionMemoryCliqueSize#22722L, rddStorageDiskSizeTotal#22724L, rddStorageMemSizeTotal#22725L, rddNumCachedPartitionsTotal#22726, rddNumPartitionsTotal#22727, numberOfExecutors#22728, replenishmentRunId#22731L, tenantId#22732, cornerstoneTenantId#22733L, marketUnit#22734, scenario#22735, activityId#22736, activityType#22737, workflowType#22738, workflowId#22739, activityAttempt#22740, gitCommitId#22742]
(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/10000001338, false, [activityType#22737], 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/10000001338], 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