== 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=87.0 KiB, rowCount=141)
: +- Exchange (13)
: +- * Project (12)
: +- * SortMergeJoin FullOuter (11)
: :- * Sort (5)
: : +- AQEShuffleRead (4)
: : +- ShuffleQueryStage (3), Statistics(sizeInBytes=83.7 KiB, rowCount=141)
: : +- Exchange (2)
: : +- LocalTableScan (1)
: +- * Sort (10)
: +- AQEShuffleRead (9)
: +- ShuffleQueryStage (8), Statistics(sizeInBytes=6.6 KiB, rowCount=141)
: +- Exchange (7)
: +- LocalTableScan (6)
+- * Sort (21)
+- AQEShuffleRead (20)
+- ShuffleQueryStage (19), Statistics(sizeInBytes=8.8 KiB, rowCount=141)
+- 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#14689, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L]
Arguments: [jobId#14689, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, ... 48 more fields]
(2) Exchange
Input [73]: [jobId#14689, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L]
Arguments: hashpartitioning(jobId#14689, 10), ENSURE_REQUIREMENTS, [plan_id=108132]
(3) ShuffleQueryStage
Output [73]: [jobId#14689, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L]
Arguments: 0
(4) AQEShuffleRead
Input [73]: [jobId#14689, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L]
Arguments: coalesced
(5) Sort [codegen id : 1]
Input [73]: [jobId#14689, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L]
Arguments: [jobId#14689 ASC NULLS FIRST], false, 0
(6) LocalTableScan
Output [4]: [jobId#14762, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: [jobId#14762, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
(7) Exchange
Input [4]: [jobId#14762, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: hashpartitioning(jobId#14762, 10), ENSURE_REQUIREMENTS, [plan_id=108133]
(8) ShuffleQueryStage
Output [4]: [jobId#14762, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: 1
(9) AQEShuffleRead
Input [4]: [jobId#14762, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: coalesced
(10) Sort [codegen id : 2]
Input [4]: [jobId#14762, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: [jobId#14762 ASC NULLS FIRST], false, 0
(11) SortMergeJoin [codegen id : 3]
Left keys [1]: [jobId#14689]
Right keys [1]: [jobId#14762]
Join type: FullOuter
Join condition: None
(12) Project [codegen id : 3]
Output [76]: [coalesce(jobId#14689, jobId#14762) AS jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Input [77]: [jobId#14689, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, jobId#14762, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
(13) Exchange
Input [76]: [jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: hashpartitioning(jobId#14772, 10), ENSURE_REQUIREMENTS, [plan_id=108337]
(14) ShuffleQueryStage
Output [76]: [jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: 3
(15) AQEShuffleRead
Input [76]: [jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: coalesced
(16) Sort [codegen id : 4]
Input [76]: [jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: [jobId#14772 ASC NULLS FIRST], false, 0
(17) LocalTableScan
Output [6]: [jobId#14766, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771]
Arguments: [jobId#14766, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771]
(18) Exchange
Input [6]: [jobId#14766, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771]
Arguments: hashpartitioning(jobId#14766, 10), ENSURE_REQUIREMENTS, [plan_id=108141]
(19) ShuffleQueryStage
Output [6]: [jobId#14766, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771]
Arguments: 2
(20) AQEShuffleRead
Input [6]: [jobId#14766, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771]
Arguments: coalesced
(21) Sort [codegen id : 5]
Input [6]: [jobId#14766, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771]
Arguments: [jobId#14766 ASC NULLS FIRST], false, 0
(22) SortMergeJoin [codegen id : 6]
Left keys [1]: [jobId#14772]
Right keys [1]: [jobId#14766]
Join type: FullOuter
Join condition: None
(23) Project [codegen id : 6]
Output [92]: [coalesce(jobId#14772, jobId#14766) AS jobId#14773, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771, 10000000004 AS replenishmentRunId#14774L, 5330363489248697092 AS tenantId#14775, 8495 AS cornerstoneTenantId#14776L, DIP_1691 AS marketUnit#14777, STANDARD AS scenario#14778, 09785261-aed7-318f-b28f-968b3af2f741 AS activityId#14779, BufferDataSnapShot AS activityType#14780, KpiPrepareDataSnapshotWorkflow AS workflowType#14781, ded8c757-741b-355d-93e6-1bd2774ed8f7 AS workflowId#14782, 1 AS activityAttempt#14783, AS gitCommitId#14785]
Input [82]: [jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L, jobId#14766, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771]
(24) Sort [codegen id : 6]
Input [92]: [jobId#14773, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771, replenishmentRunId#14774L, tenantId#14775, cornerstoneTenantId#14776L, marketUnit#14777, scenario#14778, activityId#14779, activityType#14780, workflowType#14781, workflowId#14782, activityAttempt#14783, gitCommitId#14785]
Arguments: [activityType#14780 ASC NULLS FIRST], false, 0
(25) WriteFiles
Input [92]: [jobId#14773, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771, replenishmentRunId#14774L, tenantId#14775, cornerstoneTenantId#14776L, marketUnit#14777, scenario#14778, activityId#14779, activityType#14780, workflowType#14781, workflowId#14782, activityAttempt#14783, gitCommitId#14785]
(26) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://9b46f9d5-066e-49af-bc5c-7af37534ca4d.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000004, false, [activityType#14780], Parquet, [__partition_columns=["activityType"], path=hdlfs://9b46f9d5-066e-49af-bc5c-7af37534ca4d.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000004], 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#14689, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L]
Arguments: [jobId#14689 ASC NULLS FIRST], false, 0
(29) Sort
Input [4]: [jobId#14762, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: [jobId#14762 ASC NULLS FIRST], false, 0
(30) SortMergeJoin
Left keys [1]: [jobId#14689]
Right keys [1]: [jobId#14762]
Join type: FullOuter
Join condition: None
(31) Project
Output [76]: [coalesce(jobId#14689, jobId#14762) AS jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Input [77]: [jobId#14689, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, jobId#14762, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
(32) Exchange
Input [76]: [jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: hashpartitioning(jobId#14772, 10), ENSURE_REQUIREMENTS, [plan_id=108140]
(33) Sort
Input [76]: [jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L]
Arguments: [jobId#14772 ASC NULLS FIRST], false, 0
(34) Sort
Input [6]: [jobId#14766, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771]
Arguments: [jobId#14766 ASC NULLS FIRST], false, 0
(35) SortMergeJoin
Left keys [1]: [jobId#14772]
Right keys [1]: [jobId#14766]
Join type: FullOuter
Join condition: None
(36) Project
Output [92]: [coalesce(jobId#14772, jobId#14766) AS jobId#14773, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771, 10000000004 AS replenishmentRunId#14774L, 5330363489248697092 AS tenantId#14775, 8495 AS cornerstoneTenantId#14776L, DIP_1691 AS marketUnit#14777, STANDARD AS scenario#14778, 09785261-aed7-318f-b28f-968b3af2f741 AS activityId#14779, BufferDataSnapShot AS activityType#14780, KpiPrepareDataSnapshotWorkflow AS workflowType#14781, ded8c757-741b-355d-93e6-1bd2774ed8f7 AS workflowId#14782, 1 AS activityAttempt#14783, AS gitCommitId#14785]
Input [82]: [jobId#14772, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L, jobId#14766, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771]
(37) Sort
Input [92]: [jobId#14773, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771, replenishmentRunId#14774L, tenantId#14775, cornerstoneTenantId#14776L, marketUnit#14777, scenario#14778, activityId#14779, activityType#14780, workflowType#14781, workflowId#14782, activityAttempt#14783, gitCommitId#14785]
Arguments: [activityType#14780 ASC NULLS FIRST], false, 0
(38) WriteFiles
Input [92]: [jobId#14773, stageCount#14690L, totalTaskCount#14691L, minTaskCountPerStage#14692L, maxTaskCountPerStage#14693L, medianTaskCountPerStage#14694L, bytesSpilledToDiskSerializedTotal#14695L, bytesSpilledToDiskSerializedMin#14696L, bytesSpilledToDiskSerializedMax#14697L, bytesSpilledToDiskSerializedMedian#14698L, taskCpuTimeTotal#14699L, taskCpuTimeMin#14700L, taskCpuTimeMax#14701L, taskCpuTimeMedian#14702L, taskDeserializeCpuTimeTotal#14703L, taskDeserializeCpuTimeMin#14704L, taskDeserializeCpuTimeMax#14705L, taskDeserializeCpuTimeMedian#14706L, taskDeserializeTimeTotal#14707L, taskDeserializeTimeMin#14708L, taskDeserializeTimeMax#14709L, taskDeserializeTimeMedian#14710L, taskRunTimeTotal#14711L, taskRunTimeMin#14712L, taskRunTimeMax#14713L, taskRunTimeMedian#14714L, jvmGcTimeTotal#14715L, jvmGcTimeMin#14716L, jvmGcTimeMax#14717L, jvmGcTimeMedian#14718L, bytesSpilledToDiskRawTotal#14719L, bytesSpilledToDiskRawMin#14720L, bytesSpilledToDiskRawMax#14721L, bytesSpilledToDiskRawMedian#14722L, resultSerializationTimeTotal#14723L, resultSerializationTimeMin#14724L, resultSerializationTimeMax#14725L, resultSerializationTimeMedian#14726L, resultSizeToDriverTotal#14727L, resultSizeToDriverMin#14728L, resultSizeToDriverMax#14729L, resultSizeToDriverMedian#14730L, taskPeakExecutionMemoryMin#14731L, taskPeakExecutionMemoryMax#14732L, taskPeakExecutionMemoryMedian#14733L, persistencyBytesReadTotal#14734L, persistencyBytesReadMin#14735L, persistencyBytesReadMax#14736L, persistencyBytesReadMedian#14737L, persistencyRecordsReadTotal#14738L, persistencyRecordsReadMin#14739L, persistencyRecordsReadMax#14740L, persistencyRecordsReadMedian#14741L, persistencyBytesWrittenTotal#14742L, persistencyBytesWrittenMin#14743L, persistencyBytesWrittenMax#14744L, persistencyBytesWrittenMedian#14745L, persistencyRecordsWrittenTotal#14746L, persistencyRecordsWrittenMin#14747L, persistencyRecordsWrittenMax#14748L, persistencyRecordsWrittenMedian#14749L, shuffleConsumeRecordsReadTotal#14750L, shuffleConsumeRemoteBlocksFetchedTotal#14751L, shuffleConsumeLocalBlocksFetchedTotal#14752L, shuffleConsumeTotalBlocksFetchedTotal#14753L, shuffleConsumeRemoteBytesReadTotal#14754L, shuffleConsumeLocalBytesReadTotal#14755L, shuffleConsumeTotalBytesReadTotal#14756L, shuffleConsumeRemoteBytesReadToDiskTotal#14757L, shuffleConsumeFetchWaitTimeTotal#14758L, shuffleProduceBytesWrittenTotal#14759L, shuffleProduceRecordsWrittenTotal#14760L, shuffleProduceWriteTimeTotal#14761L, peakExecutionMemory#14763L, peakExecutionMemoryCliqueDuration#14764L, peakExecutionMemoryCliqueSize#14765L, rddStorageDiskSizeTotal#14767L, rddStorageMemSizeTotal#14768L, rddNumCachedPartitionsTotal#14769, rddNumPartitionsTotal#14770, numberOfExecutors#14771, replenishmentRunId#14774L, tenantId#14775, cornerstoneTenantId#14776L, marketUnit#14777, scenario#14778, activityId#14779, activityType#14780, workflowType#14781, workflowId#14782, activityAttempt#14783, gitCommitId#14785]
(39) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: hdlfs://9b46f9d5-066e-49af-bc5c-7af37534ca4d.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000004, false, [activityType#14780], Parquet, [__partition_columns=["activityType"], path=hdlfs://9b46f9d5-066e-49af-bc5c-7af37534ca4d.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-quantity-kpi-service/internal/performance-metrics/10000000004], 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