EVAL1_SPC2 - Details for Query 60

Details for Query 60

Submitted Time: 2025/09/15 13:48:35
Duration: 0.3 s
Succeeded Jobs: 83

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 200 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 5"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 9,683 number of input batches: 3"]; } 5 [labelType="html" label="Scan parquet number of files read: 1 scan time: 8 ms metadata time: 0 ms size of files read: 327.8 KiB number of output rows: 9,683"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 1500

Project [URI_2764#7668 AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7738, CODE_2765#7661 AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7739, PARENT_2766#7666 AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7740, CODEPARENT_2767#7660 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7741, LIBELLE_2768#7665 AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7742, LIBELLEPARENT_2769#7664 AS COL_D472A873_1242_4F73_B703_84133E7F376C#7743, ANATOMYCODE_2770#7658 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7744, ANATOMYLABEL_2771#7659 AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7745, STARTDATE_2772#7667 AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7746, ENDDATE_2773#7663 AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7747, DICTIONARYCODE_2774#7662 AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7748]

Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7668)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7668)), 0000) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7661)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7661)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7666)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7666)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7660)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7660)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7665)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7665)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7664)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7664)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7658)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7658)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7659)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7659)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7667)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7667)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7663)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7663)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7662)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7662)), 0000) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ANATOMYCODE_2770#7658,ANATOMYLABEL_2771#7659,CODEPARENT_2767#7660,CODE_2765#7661,DICTIONARYCODE_2774#7662,ENDDATE_2773#7663,LIBELLEPARENT_2769#7664,LIBELLE_2768#7665,PARENT_2766#7666,STARTDATE_2772#7667,URI_2764#7668] Batched: true, DataFilters: [((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7668)), 0000)) THEN false E..., Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/ADICAP_V3_2763], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ANATOMYCODE_2770:string,ANATOMYLABEL_2771:string,CODEPARENT_2767:string,CODE_2765:string,D...

Details

== Parsed Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7738)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7738)), cast(0000 as string)) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7739)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7739)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7740)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7740)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7741)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7741)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7742)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7742)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7743)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7743)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7744)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7744)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7745)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7745)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7746)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7746)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7747)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7747)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7748)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7748)), cast(0000 as string)) END)
      +- Project [cast(ADICAP_V3_2763_URI_2764#7714 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7738, cast(ADICAP_V3_2763_CODE_2765#7707 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7739, cast(ADICAP_V3_2763_PARENT_2766#7712 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7740, cast(ADICAP_V3_2763_CODEPARENT_2767#7706 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7741, cast(ADICAP_V3_2763_LIBELLE_2768#7711 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7742, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7710 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7743, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7704 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7744, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7705 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7745, cast(ADICAP_V3_2763_STARTDATE_2772#7713 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7746, cast(ADICAP_V3_2763_ENDDATE_2773#7709 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7747, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7708 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7748]
         +- Project [ANATOMYCODE_2770#7658 AS ADICAP_V3_2763_ANATOMYCODE_2770#7704, ANATOMYLABEL_2771#7659 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7705, CODEPARENT_2767#7660 AS ADICAP_V3_2763_CODEPARENT_2767#7706, CODE_2765#7661 AS ADICAP_V3_2763_CODE_2765#7707, DICTIONARYCODE_2774#7662 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7708, ENDDATE_2773#7663 AS ADICAP_V3_2763_ENDDATE_2773#7709, LIBELLEPARENT_2769#7664 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7710, LIBELLE_2768#7665 AS ADICAP_V3_2763_LIBELLE_2768#7711, PARENT_2766#7666 AS ADICAP_V3_2763_PARENT_2766#7712, STARTDATE_2772#7667 AS ADICAP_V3_2763_STARTDATE_2772#7713, URI_2764#7668 AS ADICAP_V3_2763_URI_2764#7714]
            +- SubqueryAlias ADICAP_V3_2763111
               +- Relation[ANATOMYCODE_2770#7658,ANATOMYLABEL_2771#7659,CODEPARENT_2767#7660,CODE_2765#7661,DICTIONARYCODE_2774#7662,ENDDATE_2773#7663,LIBELLEPARENT_2769#7664,LIBELLE_2768#7665,PARENT_2766#7666,STARTDATE_2772#7667,URI_2764#7668] parquet

== Analyzed Logical Plan ==
COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC: string, COL_F5FF90C9_04E5_46B3_8805_3F1026104464: string, COL_A397999A_66EC_4CA1_8A3D_38331A08634E: string, COL_62572762_1407_4D4C_905B_2FDF6DB67E90: string, COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38: string, COL_D472A873_1242_4F73_B703_84133E7F376C: string, COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94: string, COL_A7E2BC98_F636_45B9_8094_DA576E390BE8: string, COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649: string, COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8: string, COL_B752B85C_FAFD_434B_BEB1_25579727A129: string
GlobalLimit 1500
+- LocalLimit 1500
   +- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7738)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7738)), cast(0000 as string)) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7739)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7739)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7740)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7740)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7741)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7741)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7742)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7742)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7743)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7743)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7744)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7744)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7745)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7745)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7746)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7746)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7747)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7747)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7748)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7748)), cast(0000 as string)) END)
      +- Project [cast(ADICAP_V3_2763_URI_2764#7714 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7738, cast(ADICAP_V3_2763_CODE_2765#7707 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7739, cast(ADICAP_V3_2763_PARENT_2766#7712 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7740, cast(ADICAP_V3_2763_CODEPARENT_2767#7706 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7741, cast(ADICAP_V3_2763_LIBELLE_2768#7711 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7742, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7710 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7743, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7704 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7744, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7705 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7745, cast(ADICAP_V3_2763_STARTDATE_2772#7713 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7746, cast(ADICAP_V3_2763_ENDDATE_2773#7709 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7747, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7708 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7748]
         +- Project [ANATOMYCODE_2770#7658 AS ADICAP_V3_2763_ANATOMYCODE_2770#7704, ANATOMYLABEL_2771#7659 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7705, CODEPARENT_2767#7660 AS ADICAP_V3_2763_CODEPARENT_2767#7706, CODE_2765#7661 AS ADICAP_V3_2763_CODE_2765#7707, DICTIONARYCODE_2774#7662 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7708, ENDDATE_2773#7663 AS ADICAP_V3_2763_ENDDATE_2773#7709, LIBELLEPARENT_2769#7664 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7710, LIBELLE_2768#7665 AS ADICAP_V3_2763_LIBELLE_2768#7711, PARENT_2766#7666 AS ADICAP_V3_2763_PARENT_2766#7712, STARTDATE_2772#7667 AS ADICAP_V3_2763_STARTDATE_2772#7713, URI_2764#7668 AS ADICAP_V3_2763_URI_2764#7714]
            +- SubqueryAlias ADICAP_V3_2763111
               +- Relation[ANATOMYCODE_2770#7658,ANATOMYLABEL_2771#7659,CODEPARENT_2767#7660,CODE_2765#7661,DICTIONARYCODE_2774#7662,ENDDATE_2773#7663,LIBELLEPARENT_2769#7664,LIBELLE_2768#7665,PARENT_2766#7666,STARTDATE_2772#7667,URI_2764#7668] parquet

== Optimized Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [URI_2764#7668 AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7738, CODE_2765#7661 AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7739, PARENT_2766#7666 AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7740, CODEPARENT_2767#7660 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7741, LIBELLE_2768#7665 AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7742, LIBELLEPARENT_2769#7664 AS COL_D472A873_1242_4F73_B703_84133E7F376C#7743, ANATOMYCODE_2770#7658 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7744, ANATOMYLABEL_2771#7659 AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7745, STARTDATE_2772#7667 AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7746, ENDDATE_2773#7663 AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7747, DICTIONARYCODE_2774#7662 AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7748]
      +- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7668)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7668)), 0000) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7661)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7661)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7666)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7666)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7660)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7660)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7665)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7665)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7664)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7664)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7658)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7658)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7659)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7659)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7667)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7667)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7663)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7663)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7662)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7662)), 0000) END)
         +- Relation[ANATOMYCODE_2770#7658,ANATOMYLABEL_2771#7659,CODEPARENT_2767#7660,CODE_2765#7661,DICTIONARYCODE_2774#7662,ENDDATE_2773#7663,LIBELLEPARENT_2769#7664,LIBELLE_2768#7665,PARENT_2766#7666,STARTDATE_2772#7667,URI_2764#7668] parquet

== Physical Plan ==
CollectLimit 1500
+- *(1) Project [URI_2764#7668 AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7738, CODE_2765#7661 AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7739, PARENT_2766#7666 AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7740, CODEPARENT_2767#7660 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7741, LIBELLE_2768#7665 AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7742, LIBELLEPARENT_2769#7664 AS COL_D472A873_1242_4F73_B703_84133E7F376C#7743, ANATOMYCODE_2770#7658 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7744, ANATOMYLABEL_2771#7659 AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7745, STARTDATE_2772#7667 AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7746, ENDDATE_2773#7663 AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7747, DICTIONARYCODE_2774#7662 AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7748]
   +- *(1) Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7668)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7668)), 0000) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7661)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7661)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7666)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7666)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7660)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7660)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7665)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7665)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7664)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7664)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7658)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7658)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7659)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7659)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7667)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7667)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7663)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7663)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7662)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7662)), 0000) END)
      +- *(1) ColumnarToRow
         +- FileScan parquet [ANATOMYCODE_2770#7658,ANATOMYLABEL_2771#7659,CODEPARENT_2767#7660,CODE_2765#7661,DICTIONARYCODE_2774#7662,ENDDATE_2773#7663,LIBELLEPARENT_2769#7664,LIBELLE_2768#7665,PARENT_2766#7666,STARTDATE_2772#7667,URI_2764#7668] Batched: true, DataFilters: [((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7668)), 0000)) THEN false E..., Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/ADICAP_V3_2763], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ANATOMYCODE_2770:string,ANATOMYLABEL_2771:string,CODEPARENT_2767:string,CODE_2765:string,D...