EVAL1_SPC2 - Details for Query 38

Details for Query 38

Submitted Time: 2025/09/15 13:42:37
Duration: 0.5 s
Succeeded Jobs: 53

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand number of written files: 2 written output: 490.4 KiB number of output rows: 48,285 number of dynamic part: 0"]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n506 ms (213 ms, 293 ms, 293 ms (stage 58.0: task 79))"; 2 [labelType="html" label=" Project "]; } 3 [labelType="html" label="Scan csv number of output rows: 48,285 number of files read: 1 metadata time: 0 ms size of files read: 6.9 MiB"]; 2->0; 3->2; }

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_IMAGERIE__2813, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_IMAGERIE__2813], Overwrite, [LOINCNUMBER_2814, LONGCOMMONNAME_2815, LONGNAME_2823, PARTNAME_2818, PARTNUMBER_2816, PARTSEQUENCEORD_2819, PARTTYPENAME_2817, PREFERREDNAME_2821, RID_2820, RPID_2822]

Project [LoincNumber#5829 AS LOINCNUMBER_2814#5889, LongCommonName#5830 AS LONGCOMMONNAME_2815#5890, LongName#5838 AS LONGNAME_2823#5891, PartName#5833 AS PARTNAME_2818#5892, PartNumber#5831 AS PARTNUMBER_2816#5893, PartSequenceOrder#5834 AS PARTSEQUENCEORD_2819#5894, PartTypeName#5832 AS PARTTYPENAME_2817#5895, PreferredName#5836 AS PREFERREDNAME_2821#5896, RID#5835 AS RID_2820#5897, RPID#5837 AS RPID_2822#5898]

WholeStageCodegen (1)

FileScan csv [LoincNumber#5829,LongCommonName#5830,PartNumber#5831,PartTypeName#5832,PartName#5833,PartSequenceOrder#5834,RID#5835,PreferredName#5836,RPID#5837,LongName#5838] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex[file:/data/input/depot/csv/execution/63EA4041_AA71_4F64_B13B_1B63A995EF0A/curre..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<LoincNumber:string,LongCommonName:string,PartNumber:string,PartTypeName:string,PartName:st...

Details

== Parsed Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_IMAGERIE__2813, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_IMAGERIE__2813], Overwrite, [LOINCNUMBER_2814, LONGCOMMONNAME_2815, LONGNAME_2823, PARTNAME_2818, PARTNUMBER_2816, PARTSEQUENCEORD_2819, PARTTYPENAME_2817, PREFERREDNAME_2821, RID_2820, RPID_2822]
+- Project [LOINCNUMBER_2814#5889, LONGCOMMONNAME_2815#5890, LONGNAME_2823#5891, PARTNAME_2818#5892, PARTNUMBER_2816#5893, PARTSEQUENCEORD_2819#5894, PARTTYPENAME_2817#5895, PREFERREDNAME_2821#5896, RID_2820#5897, RPID_2822#5898]
   +- Project [LoincNumber#5859 AS LOINCNUMBER_2814#5889, LongCommonName#5860 AS LONGCOMMONNAME_2815#5890, LongName#5868 AS LONGNAME_2823#5891, PartName#5863 AS PARTNAME_2818#5892, PartNumber#5861 AS PARTNUMBER_2816#5893, PartSequenceOrder#5864 AS PARTSEQUENCEORD_2819#5894, PartTypeName#5862 AS PARTTYPENAME_2817#5895, PreferredName#5866 AS PREFERREDNAME_2821#5896, RID#5865 AS RID_2820#5897, RPID#5867 AS RPID_2822#5898]
      +- Project [LoincNumber#5859, LongCommonName#5860, PartNumber#5861, PartTypeName#5862, PartName#5863, PartSequenceOrder#5864, RID#5865, PreferredName#5866, RPID#5867, LongName#5868]
         +- Project [LoincNumber#5829 AS LoincNumber#5859, LongCommonName#5830 AS LongCommonName#5860, PartNumber#5831 AS PartNumber#5861, PartTypeName#5832 AS PartTypeName#5862, PartName#5833 AS PartName#5863, PartSequenceOrder#5834 AS PartSequenceOrder#5864, RID#5835 AS RID#5865, PreferredName#5836 AS PreferredName#5866, RPID#5837 AS RPID#5867, LongName#5838 AS LongName#5868]
            +- Relation[LoincNumber#5829,LongCommonName#5830,PartNumber#5831,PartTypeName#5832,PartName#5833,PartSequenceOrder#5834,RID#5835,PreferredName#5836,RPID#5837,LongName#5838] csv

== Analyzed Logical Plan ==

InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_IMAGERIE__2813, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_IMAGERIE__2813], Overwrite, [LOINCNUMBER_2814, LONGCOMMONNAME_2815, LONGNAME_2823, PARTNAME_2818, PARTNUMBER_2816, PARTSEQUENCEORD_2819, PARTTYPENAME_2817, PREFERREDNAME_2821, RID_2820, RPID_2822]
+- Project [LOINCNUMBER_2814#5889, LONGCOMMONNAME_2815#5890, LONGNAME_2823#5891, PARTNAME_2818#5892, PARTNUMBER_2816#5893, PARTSEQUENCEORD_2819#5894, PARTTYPENAME_2817#5895, PREFERREDNAME_2821#5896, RID_2820#5897, RPID_2822#5898]
   +- Project [LoincNumber#5859 AS LOINCNUMBER_2814#5889, LongCommonName#5860 AS LONGCOMMONNAME_2815#5890, LongName#5868 AS LONGNAME_2823#5891, PartName#5863 AS PARTNAME_2818#5892, PartNumber#5861 AS PARTNUMBER_2816#5893, PartSequenceOrder#5864 AS PARTSEQUENCEORD_2819#5894, PartTypeName#5862 AS PARTTYPENAME_2817#5895, PreferredName#5866 AS PREFERREDNAME_2821#5896, RID#5865 AS RID_2820#5897, RPID#5867 AS RPID_2822#5898]
      +- Project [LoincNumber#5859, LongCommonName#5860, PartNumber#5861, PartTypeName#5862, PartName#5863, PartSequenceOrder#5864, RID#5865, PreferredName#5866, RPID#5867, LongName#5868]
         +- Project [LoincNumber#5829 AS LoincNumber#5859, LongCommonName#5830 AS LongCommonName#5860, PartNumber#5831 AS PartNumber#5861, PartTypeName#5832 AS PartTypeName#5862, PartName#5833 AS PartName#5863, PartSequenceOrder#5834 AS PartSequenceOrder#5864, RID#5835 AS RID#5865, PreferredName#5836 AS PreferredName#5866, RPID#5837 AS RPID#5867, LongName#5838 AS LongName#5868]
            +- Relation[LoincNumber#5829,LongCommonName#5830,PartNumber#5831,PartTypeName#5832,PartName#5833,PartSequenceOrder#5834,RID#5835,PreferredName#5836,RPID#5837,LongName#5838] csv

== Optimized Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_IMAGERIE__2813, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_IMAGERIE__2813], Overwrite, [LOINCNUMBER_2814, LONGCOMMONNAME_2815, LONGNAME_2823, PARTNAME_2818, PARTNUMBER_2816, PARTSEQUENCEORD_2819, PARTTYPENAME_2817, PREFERREDNAME_2821, RID_2820, RPID_2822]
+- Project [LoincNumber#5829 AS LOINCNUMBER_2814#5889, LongCommonName#5830 AS LONGCOMMONNAME_2815#5890, LongName#5838 AS LONGNAME_2823#5891, PartName#5833 AS PARTNAME_2818#5892, PartNumber#5831 AS PARTNUMBER_2816#5893, PartSequenceOrder#5834 AS PARTSEQUENCEORD_2819#5894, PartTypeName#5832 AS PARTTYPENAME_2817#5895, PreferredName#5836 AS PREFERREDNAME_2821#5896, RID#5835 AS RID_2820#5897, RPID#5837 AS RPID_2822#5898]
   +- Relation[LoincNumber#5829,LongCommonName#5830,PartNumber#5831,PartTypeName#5832,PartName#5833,PartSequenceOrder#5834,RID#5835,PreferredName#5836,RPID#5837,LongName#5838] csv

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_IMAGERIE__2813, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_IMAGERIE__2813], Overwrite, [LOINCNUMBER_2814, LONGCOMMONNAME_2815, LONGNAME_2823, PARTNAME_2818, PARTNUMBER_2816, PARTSEQUENCEORD_2819, PARTTYPENAME_2817, PREFERREDNAME_2821, RID_2820, RPID_2822]
+- *(1) Project [LoincNumber#5829 AS LOINCNUMBER_2814#5889, LongCommonName#5830 AS LONGCOMMONNAME_2815#5890, LongName#5838 AS LONGNAME_2823#5891, PartName#5833 AS PARTNAME_2818#5892, PartNumber#5831 AS PARTNUMBER_2816#5893, PartSequenceOrder#5834 AS PARTSEQUENCEORD_2819#5894, PartTypeName#5832 AS PARTTYPENAME_2817#5895, PreferredName#5836 AS PREFERREDNAME_2821#5896, RID#5835 AS RID_2820#5897, RPID#5837 AS RPID_2822#5898]
   +- FileScan csv [LoincNumber#5829,LongCommonName#5830,PartNumber#5831,PartTypeName#5832,PartName#5833,PartSequenceOrder#5834,RID#5835,PreferredName#5836,RPID#5837,LongName#5838] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex[file:/data/input/depot/csv/execution/63EA4041_AA71_4F64_B13B_1B63A995EF0A/curre..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<LoincNumber:string,LongCommonName:string,PartNumber:string,PartTypeName:string,PartName:st...