EVAL1_SPC2 - Details for Query 36

Details for Query 36

Submitted Time: 2025/09/15 13:37:47
Duration: 95 ms
Succeeded Jobs: 49
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_LOINCNUMBER_2814#5667 AS COL_LOINCNUMBER_2814#5727, COL_LONGCOMMONNAME_2815#5668 AS COL_LONGCOMMONNAME_2815#5728, COL_PARTNUMBER_2816#5669 AS COL_PARTNUMBER_2816#5729, COL_PARTTYPENAME_2817#5670 AS COL_PARTTYPENAME_2817#5730, COL_PARTNAME_2818#5671 AS COL_PARTNAME_2818#5731, COL_PARTSEQUENCEORD_2819#5672 AS COL_PARTSEQUENCEORD_2819#5732, COL_RID_2820#5673 AS COL_RID_2820#5733, COL_PREFERREDNAME_2821#5674 AS COL_PREFERREDNAME_2821#5734, COL_RPID_2822#5675 AS COL_RPID_2822#5735, COL_LONGNAME_2823#5676 AS COL_LONGNAME_2823#5736]
      +- Filter true
         +- Project [COL_LOINCNUMBER_2814#5667, COL_LONGCOMMONNAME_2815#5668, COL_PARTNUMBER_2816#5669, COL_PARTTYPENAME_2817#5670, COL_PARTNAME_2818#5671, COL_PARTSEQUENCEORD_2819#5672, COL_RID_2820#5673, COL_PREFERREDNAME_2821#5674, COL_RPID_2822#5675, COL_LONGNAME_2823#5676]
            +- Project [cast(LOINC_IMAGERIE__2813_LOINCNUMBER_2814#5607 as string) AS COL_LOINCNUMBER_2814#5667, cast(LOINC_IMAGERIE__2813_LONGCOMMONNAME_2815#5608 as string) AS COL_LONGCOMMONNAME_2815#5668, cast(LOINC_IMAGERIE__2813_PARTNUMBER_2816#5611 as string) AS COL_PARTNUMBER_2816#5669, cast(LOINC_IMAGERIE__2813_PARTTYPENAME_2817#5613 as string) AS COL_PARTTYPENAME_2817#5670, cast(LOINC_IMAGERIE__2813_PARTNAME_2818#5610 as string) AS COL_PARTNAME_2818#5671, cast(LOINC_IMAGERIE__2813_PARTSEQUENCEORD_2819#5612 as string) AS COL_PARTSEQUENCEORD_2819#5672, cast(LOINC_IMAGERIE__2813_RID_2820#5615 as string) AS COL_RID_2820#5673, cast(LOINC_IMAGERIE__2813_PREFERREDNAME_2821#5614 as string) AS COL_PREFERREDNAME_2821#5674, cast(LOINC_IMAGERIE__2813_RPID_2822#5616 as string) AS COL_RPID_2822#5675, cast(LOINC_IMAGERIE__2813_LONGNAME_2823#5609 as string) AS COL_LONGNAME_2823#5676]
               +- Project [LOINCNUMBER_2814#5517 AS LOINC_IMAGERIE__2813_LOINCNUMBER_2814#5607, LONGCOMMONNAME_2815#5518 AS LOINC_IMAGERIE__2813_LONGCOMMONNAME_2815#5608, LONGNAME_2823#5519 AS LOINC_IMAGERIE__2813_LONGNAME_2823#5609, PARTNAME_2818#5520 AS LOINC_IMAGERIE__2813_PARTNAME_2818#5610, PARTNUMBER_2816#5521 AS LOINC_IMAGERIE__2813_PARTNUMBER_2816#5611, PARTSEQUENCEORD_2819#5523 AS LOINC_IMAGERIE__2813_PARTSEQUENCEORD_2819#5612, PARTTYPENAME_2817#5525 AS LOINC_IMAGERIE__2813_PARTTYPENAME_2817#5613, PREFERREDNAME_2821#5526 AS LOINC_IMAGERIE__2813_PREFERREDNAME_2821#5614, RID_2820#5529 AS LOINC_IMAGERIE__2813_RID_2820#5615, RPID_2822#5531 AS LOINC_IMAGERIE__2813_RPID_2822#5616]
                  +- SubqueryAlias LOINC_IMAGERIE__2813113
                     +- Project [LOINCNUMBER_2814#5517, LONGCOMMONNAME_2815#5518, LONGNAME_2823#5519, PARTNAME_2818#5520, PARTNUMBER_2816#5521, PARTSEQUENCEORD_2819#5523, PARTTYPENAME_2817#5525, PREFERREDNAME_2821#5526, RID_2820#5529, RPID_2822#5531]
                        +- Project [LoincNumber#5457 AS LOINCNUMBER_2814#5517, LongCommonName#5458 AS LONGCOMMONNAME_2815#5518, LongName#5470 AS LONGNAME_2823#5519, PartName#5461 AS PARTNAME_2818#5520, PartNumber#5459 AS PARTNUMBER_2816#5521, PartSequenceOrder#5463 AS PARTSEQUENCEORD_2819#5523, PartTypeName#5460 AS PARTTYPENAME_2817#5525, PreferredName#5467 AS PREFERREDNAME_2821#5526, RID#5465 AS RID_2820#5529, RPID#5469 AS RPID_2822#5531]
                           +- Project [LoincNumber#5457, LongCommonName#5458, PartNumber#5459, PartTypeName#5460, PartName#5461, PartSequenceOrder#5463, RID#5465, PreferredName#5467, RPID#5469, LongName#5470]
                              +- Project [LoincNumber#5397 AS LoincNumber#5457, LongCommonName#5398 AS LongCommonName#5458, PartNumber#5399 AS PartNumber#5459, PartTypeName#5400 AS PartTypeName#5460, PartName#5401 AS PartName#5461, PartSequenceOrder#5402 AS PartSequenceOrder#5463, RID#5403 AS RID#5465, PreferredName#5404 AS PreferredName#5467, RPID#5405 AS RPID#5469, LongName#5406 AS LongName#5470]
                                 +- Relation[LoincNumber#5397,LongCommonName#5398,PartNumber#5399,PartTypeName#5400,PartName#5401,PartSequenceOrder#5402,RID#5403,PreferredName#5404,RPID#5405,LongName#5406] csv

== Analyzed Logical Plan ==
COL_LOINCNUMBER_2814: string, COL_LONGCOMMONNAME_2815: string, COL_PARTNUMBER_2816: string, COL_PARTTYPENAME_2817: string, COL_PARTNAME_2818: string, COL_PARTSEQUENCEORD_2819: string, COL_RID_2820: string, COL_PREFERREDNAME_2821: string, COL_RPID_2822: string, COL_LONGNAME_2823: string
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_LOINCNUMBER_2814#5667 AS COL_LOINCNUMBER_2814#5727, COL_LONGCOMMONNAME_2815#5668 AS COL_LONGCOMMONNAME_2815#5728, COL_PARTNUMBER_2816#5669 AS COL_PARTNUMBER_2816#5729, COL_PARTTYPENAME_2817#5670 AS COL_PARTTYPENAME_2817#5730, COL_PARTNAME_2818#5671 AS COL_PARTNAME_2818#5731, COL_PARTSEQUENCEORD_2819#5672 AS COL_PARTSEQUENCEORD_2819#5732, COL_RID_2820#5673 AS COL_RID_2820#5733, COL_PREFERREDNAME_2821#5674 AS COL_PREFERREDNAME_2821#5734, COL_RPID_2822#5675 AS COL_RPID_2822#5735, COL_LONGNAME_2823#5676 AS COL_LONGNAME_2823#5736]
      +- Filter true
         +- Project [COL_LOINCNUMBER_2814#5667, COL_LONGCOMMONNAME_2815#5668, COL_PARTNUMBER_2816#5669, COL_PARTTYPENAME_2817#5670, COL_PARTNAME_2818#5671, COL_PARTSEQUENCEORD_2819#5672, COL_RID_2820#5673, COL_PREFERREDNAME_2821#5674, COL_RPID_2822#5675, COL_LONGNAME_2823#5676]
            +- Project [cast(LOINC_IMAGERIE__2813_LOINCNUMBER_2814#5607 as string) AS COL_LOINCNUMBER_2814#5667, cast(LOINC_IMAGERIE__2813_LONGCOMMONNAME_2815#5608 as string) AS COL_LONGCOMMONNAME_2815#5668, cast(LOINC_IMAGERIE__2813_PARTNUMBER_2816#5611 as string) AS COL_PARTNUMBER_2816#5669, cast(LOINC_IMAGERIE__2813_PARTTYPENAME_2817#5613 as string) AS COL_PARTTYPENAME_2817#5670, cast(LOINC_IMAGERIE__2813_PARTNAME_2818#5610 as string) AS COL_PARTNAME_2818#5671, cast(LOINC_IMAGERIE__2813_PARTSEQUENCEORD_2819#5612 as string) AS COL_PARTSEQUENCEORD_2819#5672, cast(LOINC_IMAGERIE__2813_RID_2820#5615 as string) AS COL_RID_2820#5673, cast(LOINC_IMAGERIE__2813_PREFERREDNAME_2821#5614 as string) AS COL_PREFERREDNAME_2821#5674, cast(LOINC_IMAGERIE__2813_RPID_2822#5616 as string) AS COL_RPID_2822#5675, cast(LOINC_IMAGERIE__2813_LONGNAME_2823#5609 as string) AS COL_LONGNAME_2823#5676]
               +- Project [LOINCNUMBER_2814#5517 AS LOINC_IMAGERIE__2813_LOINCNUMBER_2814#5607, LONGCOMMONNAME_2815#5518 AS LOINC_IMAGERIE__2813_LONGCOMMONNAME_2815#5608, LONGNAME_2823#5519 AS LOINC_IMAGERIE__2813_LONGNAME_2823#5609, PARTNAME_2818#5520 AS LOINC_IMAGERIE__2813_PARTNAME_2818#5610, PARTNUMBER_2816#5521 AS LOINC_IMAGERIE__2813_PARTNUMBER_2816#5611, PARTSEQUENCEORD_2819#5523 AS LOINC_IMAGERIE__2813_PARTSEQUENCEORD_2819#5612, PARTTYPENAME_2817#5525 AS LOINC_IMAGERIE__2813_PARTTYPENAME_2817#5613, PREFERREDNAME_2821#5526 AS LOINC_IMAGERIE__2813_PREFERREDNAME_2821#5614, RID_2820#5529 AS LOINC_IMAGERIE__2813_RID_2820#5615, RPID_2822#5531 AS LOINC_IMAGERIE__2813_RPID_2822#5616]
                  +- SubqueryAlias LOINC_IMAGERIE__2813113
                     +- Project [LOINCNUMBER_2814#5517, LONGCOMMONNAME_2815#5518, LONGNAME_2823#5519, PARTNAME_2818#5520, PARTNUMBER_2816#5521, PARTSEQUENCEORD_2819#5523, PARTTYPENAME_2817#5525, PREFERREDNAME_2821#5526, RID_2820#5529, RPID_2822#5531]
                        +- Project [LoincNumber#5457 AS LOINCNUMBER_2814#5517, LongCommonName#5458 AS LONGCOMMONNAME_2815#5518, LongName#5470 AS LONGNAME_2823#5519, PartName#5461 AS PARTNAME_2818#5520, PartNumber#5459 AS PARTNUMBER_2816#5521, PartSequenceOrder#5463 AS PARTSEQUENCEORD_2819#5523, PartTypeName#5460 AS PARTTYPENAME_2817#5525, PreferredName#5467 AS PREFERREDNAME_2821#5526, RID#5465 AS RID_2820#5529, RPID#5469 AS RPID_2822#5531]
                           +- Project [LoincNumber#5457, LongCommonName#5458, PartNumber#5459, PartTypeName#5460, PartName#5461, PartSequenceOrder#5463, RID#5465, PreferredName#5467, RPID#5469, LongName#5470]
                              +- Project [LoincNumber#5397 AS LoincNumber#5457, LongCommonName#5398 AS LongCommonName#5458, PartNumber#5399 AS PartNumber#5459, PartTypeName#5400 AS PartTypeName#5460, PartName#5401 AS PartName#5461, PartSequenceOrder#5402 AS PartSequenceOrder#5463, RID#5403 AS RID#5465, PreferredName#5404 AS PreferredName#5467, RPID#5405 AS RPID#5469, LongName#5406 AS LongName#5470]
                                 +- Relation[LoincNumber#5397,LongCommonName#5398,PartNumber#5399,PartTypeName#5400,PartName#5401,PartSequenceOrder#5402,RID#5403,PreferredName#5404,RPID#5405,LongName#5406] csv

== Optimized Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [LoincNumber#5397 AS COL_LOINCNUMBER_2814#5727, LongCommonName#5398 AS COL_LONGCOMMONNAME_2815#5728, PartNumber#5399 AS COL_PARTNUMBER_2816#5729, PartTypeName#5400 AS COL_PARTTYPENAME_2817#5730, PartName#5401 AS COL_PARTNAME_2818#5731, PartSequenceOrder#5402 AS COL_PARTSEQUENCEORD_2819#5732, RID#5403 AS COL_RID_2820#5733, PreferredName#5404 AS COL_PREFERREDNAME_2821#5734, RPID#5405 AS COL_RPID_2822#5735, LongName#5406 AS COL_LONGNAME_2823#5736]
      +- Relation[LoincNumber#5397,LongCommonName#5398,PartNumber#5399,PartTypeName#5400,PartName#5401,PartSequenceOrder#5402,RID#5403,PreferredName#5404,RPID#5405,LongName#5406] csv

== Physical Plan ==
CollectLimit 1500
+- *(1) Project [LoincNumber#5397 AS COL_LOINCNUMBER_2814#5727, LongCommonName#5398 AS COL_LONGCOMMONNAME_2815#5728, PartNumber#5399 AS COL_PARTNUMBER_2816#5729, PartTypeName#5400 AS COL_PARTTYPENAME_2817#5730, PartName#5401 AS COL_PARTNAME_2818#5731, PartSequenceOrder#5402 AS COL_PARTSEQUENCEORD_2819#5732, RID#5403 AS COL_RID_2820#5733, PreferredName#5404 AS COL_PREFERREDNAME_2821#5734, RPID#5405 AS COL_RPID_2822#5735, LongName#5406 AS COL_LONGNAME_2823#5736]
   +- FileScan csv [LoincNumber#5397,LongCommonName#5398,PartNumber#5399,PartTypeName#5400,PartName#5401,PartSequenceOrder#5402,RID#5403,PreferredName#5404,RPID#5405,LongName#5406] 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...