EVAL1_SPC2 - Details for Query 55

Details for Query 55

Submitted Time: 2025/09/15 13:45:41
Duration: 0.6 s
Succeeded Jobs: 78

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: 335 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 42"]; 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: 15 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#7442 AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7498, CODE_2765#7435 AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7499, PARENT_2766#7440 AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7500, CODEPARENT_2767#7434 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7501, LIBELLE_2768#7439 AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7502, LIBELLEPARENT_2769#7438 AS COL_D472A873_1242_4F73_B703_84133E7F376C#7503, ANATOMYCODE_2770#7432 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7504, ANATOMYLABEL_2771#7433 AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7505, STARTDATE_2772#7441 AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7506, ENDDATE_2773#7437 AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7507, DICTIONARYCODE_2774#7436 AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7508]

Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7442)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7442)), PF0500) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7435)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7435)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7440)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7440)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7434)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7434)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7439)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7439)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7438)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7438)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7432)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7432)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7433)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7433)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7441)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7441)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7437)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7437)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7436)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7436)), PF0500) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ANATOMYCODE_2770#7432,ANATOMYLABEL_2771#7433,CODEPARENT_2767#7434,CODE_2765#7435,DICTIONARYCODE_2774#7436,ENDDATE_2773#7437,LIBELLEPARENT_2769#7438,LIBELLE_2768#7439,PARENT_2766#7440,STARTDATE_2772#7441,URI_2764#7442] Batched: true, DataFilters: [((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7442)), PF0500)) THEN false..., 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#7498)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7498)), cast(PF0500 as string)) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7499)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7499)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7500)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7500)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7501)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7501)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7502)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7502)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7503)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7503)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7504)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7504)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7505)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7505)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7506)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7506)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7507)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7507)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7508)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7508)), cast(PF0500 as string)) END)
      +- Project [cast(ADICAP_V3_2763_URI_2764#7475 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7498, cast(ADICAP_V3_2763_CODE_2765#7468 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7499, cast(ADICAP_V3_2763_PARENT_2766#7473 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7500, cast(ADICAP_V3_2763_CODEPARENT_2767#7467 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7501, cast(ADICAP_V3_2763_LIBELLE_2768#7472 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7502, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7471 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7503, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7465 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7504, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7466 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7505, cast(ADICAP_V3_2763_STARTDATE_2772#7474 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7506, cast(ADICAP_V3_2763_ENDDATE_2773#7470 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7507, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7469 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7508]
         +- Project [ANATOMYCODE_2770#7432 AS ADICAP_V3_2763_ANATOMYCODE_2770#7465, ANATOMYLABEL_2771#7433 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7466, CODEPARENT_2767#7434 AS ADICAP_V3_2763_CODEPARENT_2767#7467, CODE_2765#7435 AS ADICAP_V3_2763_CODE_2765#7468, DICTIONARYCODE_2774#7436 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7469, ENDDATE_2773#7437 AS ADICAP_V3_2763_ENDDATE_2773#7470, LIBELLEPARENT_2769#7438 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7471, LIBELLE_2768#7439 AS ADICAP_V3_2763_LIBELLE_2768#7472, PARENT_2766#7440 AS ADICAP_V3_2763_PARENT_2766#7473, STARTDATE_2772#7441 AS ADICAP_V3_2763_STARTDATE_2772#7474, URI_2764#7442 AS ADICAP_V3_2763_URI_2764#7475]
            +- SubqueryAlias ADICAP_V3_2763113
               +- Relation[ANATOMYCODE_2770#7432,ANATOMYLABEL_2771#7433,CODEPARENT_2767#7434,CODE_2765#7435,DICTIONARYCODE_2774#7436,ENDDATE_2773#7437,LIBELLEPARENT_2769#7438,LIBELLE_2768#7439,PARENT_2766#7440,STARTDATE_2772#7441,URI_2764#7442] 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#7498)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7498)), cast(PF0500 as string)) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7499)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7499)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7500)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7500)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7501)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7501)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7502)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7502)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7503)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7503)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7504)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7504)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7505)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7505)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7506)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7506)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7507)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7507)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7508)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7508)), cast(PF0500 as string)) END)
      +- Project [cast(ADICAP_V3_2763_URI_2764#7475 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7498, cast(ADICAP_V3_2763_CODE_2765#7468 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7499, cast(ADICAP_V3_2763_PARENT_2766#7473 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7500, cast(ADICAP_V3_2763_CODEPARENT_2767#7467 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7501, cast(ADICAP_V3_2763_LIBELLE_2768#7472 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7502, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7471 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7503, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7465 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7504, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7466 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7505, cast(ADICAP_V3_2763_STARTDATE_2772#7474 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7506, cast(ADICAP_V3_2763_ENDDATE_2773#7470 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7507, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7469 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7508]
         +- Project [ANATOMYCODE_2770#7432 AS ADICAP_V3_2763_ANATOMYCODE_2770#7465, ANATOMYLABEL_2771#7433 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7466, CODEPARENT_2767#7434 AS ADICAP_V3_2763_CODEPARENT_2767#7467, CODE_2765#7435 AS ADICAP_V3_2763_CODE_2765#7468, DICTIONARYCODE_2774#7436 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7469, ENDDATE_2773#7437 AS ADICAP_V3_2763_ENDDATE_2773#7470, LIBELLEPARENT_2769#7438 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7471, LIBELLE_2768#7439 AS ADICAP_V3_2763_LIBELLE_2768#7472, PARENT_2766#7440 AS ADICAP_V3_2763_PARENT_2766#7473, STARTDATE_2772#7441 AS ADICAP_V3_2763_STARTDATE_2772#7474, URI_2764#7442 AS ADICAP_V3_2763_URI_2764#7475]
            +- SubqueryAlias ADICAP_V3_2763113
               +- Relation[ANATOMYCODE_2770#7432,ANATOMYLABEL_2771#7433,CODEPARENT_2767#7434,CODE_2765#7435,DICTIONARYCODE_2774#7436,ENDDATE_2773#7437,LIBELLEPARENT_2769#7438,LIBELLE_2768#7439,PARENT_2766#7440,STARTDATE_2772#7441,URI_2764#7442] parquet

== Optimized Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [URI_2764#7442 AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7498, CODE_2765#7435 AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7499, PARENT_2766#7440 AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7500, CODEPARENT_2767#7434 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7501, LIBELLE_2768#7439 AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7502, LIBELLEPARENT_2769#7438 AS COL_D472A873_1242_4F73_B703_84133E7F376C#7503, ANATOMYCODE_2770#7432 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7504, ANATOMYLABEL_2771#7433 AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7505, STARTDATE_2772#7441 AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7506, ENDDATE_2773#7437 AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7507, DICTIONARYCODE_2774#7436 AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7508]
      +- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7442)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7442)), PF0500) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7435)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7435)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7440)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7440)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7434)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7434)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7439)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7439)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7438)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7438)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7432)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7432)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7433)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7433)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7441)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7441)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7437)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7437)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7436)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7436)), PF0500) END)
         +- Relation[ANATOMYCODE_2770#7432,ANATOMYLABEL_2771#7433,CODEPARENT_2767#7434,CODE_2765#7435,DICTIONARYCODE_2774#7436,ENDDATE_2773#7437,LIBELLEPARENT_2769#7438,LIBELLE_2768#7439,PARENT_2766#7440,STARTDATE_2772#7441,URI_2764#7442] parquet

== Physical Plan ==
CollectLimit 1500
+- *(1) Project [URI_2764#7442 AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7498, CODE_2765#7435 AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7499, PARENT_2766#7440 AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7500, CODEPARENT_2767#7434 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7501, LIBELLE_2768#7439 AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7502, LIBELLEPARENT_2769#7438 AS COL_D472A873_1242_4F73_B703_84133E7F376C#7503, ANATOMYCODE_2770#7432 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7504, ANATOMYLABEL_2771#7433 AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7505, STARTDATE_2772#7441 AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7506, ENDDATE_2773#7437 AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7507, DICTIONARYCODE_2774#7436 AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7508]
   +- *(1) Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7442)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7442)), PF0500) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7435)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7435)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7440)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7440)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7434)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7434)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7439)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7439)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7438)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7438)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7432)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7432)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7433)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7433)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7441)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7441)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7437)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7437)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7436)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7436)), PF0500) END)
      +- *(1) ColumnarToRow
         +- FileScan parquet [ANATOMYCODE_2770#7432,ANATOMYLABEL_2771#7433,CODEPARENT_2767#7434,CODE_2765#7435,DICTIONARYCODE_2774#7436,ENDDATE_2773#7437,LIBELLEPARENT_2769#7438,LIBELLE_2768#7439,PARENT_2766#7440,STARTDATE_2772#7441,URI_2764#7442] Batched: true, DataFilters: [((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7442)), PF0500)) THEN false..., 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...