EVAL1_SPC2 - Details for Query 56

Details for Query 56

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

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 shuffle write time: 0 ms records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B local blocks read: 1 remote blocks read: 0 data size: 16.0 B remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 307 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 306 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 42"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 9,683 number of input batches: 3"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 10 ms metadata time: 0 ms size of files read: 327.8 KiB number of output rows: 9,683"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 9->8; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (2)

Exchange SinglePartition, true, [id=#1077]

HashAggregate(keys=[], functions=[partial_count(1)])

Project

Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7354)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7354)), PF0500) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7347)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7347)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7352)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7352)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7346)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7346)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7351)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7351)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7350)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7350)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7344)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7344)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7345)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7345)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7353)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7353)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7349)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7349)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7348)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7348)), PF0500) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ANATOMYCODE_2770#7344,ANATOMYLABEL_2771#7345,CODEPARENT_2767#7346,CODE_2765#7347,DICTIONARYCODE_2774#7348,ENDDATE_2773#7349,LIBELLEPARENT_2769#7350,LIBELLE_2768#7351,PARENT_2766#7352,STARTDATE_2772#7353,URI_2764#7354] Batched: true, DataFilters: [((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7354)), 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 ==
Aggregate [count(1) AS count#7532L]
+- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7410)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7410)), cast(PF0500 as string)) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7411)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7411)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7412)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7412)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7413)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7413)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7414)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7414)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7415)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7415)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7416)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7416)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7417)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7417)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7418)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7418)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7419)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7419)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7420)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7420)), cast(PF0500 as string)) END)
   +- Project [cast(ADICAP_V3_2763_URI_2764#7387 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7410, cast(ADICAP_V3_2763_CODE_2765#7380 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7411, cast(ADICAP_V3_2763_PARENT_2766#7385 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7412, cast(ADICAP_V3_2763_CODEPARENT_2767#7379 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7413, cast(ADICAP_V3_2763_LIBELLE_2768#7384 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7414, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7383 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7415, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7377 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7416, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7378 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7417, cast(ADICAP_V3_2763_STARTDATE_2772#7386 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7418, cast(ADICAP_V3_2763_ENDDATE_2773#7382 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7419, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7381 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7420]
      +- Project [ANATOMYCODE_2770#7344 AS ADICAP_V3_2763_ANATOMYCODE_2770#7377, ANATOMYLABEL_2771#7345 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7378, CODEPARENT_2767#7346 AS ADICAP_V3_2763_CODEPARENT_2767#7379, CODE_2765#7347 AS ADICAP_V3_2763_CODE_2765#7380, DICTIONARYCODE_2774#7348 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7381, ENDDATE_2773#7349 AS ADICAP_V3_2763_ENDDATE_2773#7382, LIBELLEPARENT_2769#7350 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7383, LIBELLE_2768#7351 AS ADICAP_V3_2763_LIBELLE_2768#7384, PARENT_2766#7352 AS ADICAP_V3_2763_PARENT_2766#7385, STARTDATE_2772#7353 AS ADICAP_V3_2763_STARTDATE_2772#7386, URI_2764#7354 AS ADICAP_V3_2763_URI_2764#7387]
         +- SubqueryAlias ADICAP_V3_2763112
            +- Relation[ANATOMYCODE_2770#7344,ANATOMYLABEL_2771#7345,CODEPARENT_2767#7346,CODE_2765#7347,DICTIONARYCODE_2774#7348,ENDDATE_2773#7349,LIBELLEPARENT_2769#7350,LIBELLE_2768#7351,PARENT_2766#7352,STARTDATE_2772#7353,URI_2764#7354] parquet

== Analyzed Logical Plan ==
count: bigint
Aggregate [count(1) AS count#7532L]
+- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7410)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7410)), cast(PF0500 as string)) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7411)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7411)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7412)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7412)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7413)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7413)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7414)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7414)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7415)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7415)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7416)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7416)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7417)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7417)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7418)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7418)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7419)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7419)), cast(PF0500 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7420)), cast(PF0500 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7420)), cast(PF0500 as string)) END)
   +- Project [cast(ADICAP_V3_2763_URI_2764#7387 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7410, cast(ADICAP_V3_2763_CODE_2765#7380 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7411, cast(ADICAP_V3_2763_PARENT_2766#7385 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7412, cast(ADICAP_V3_2763_CODEPARENT_2767#7379 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7413, cast(ADICAP_V3_2763_LIBELLE_2768#7384 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7414, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7383 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7415, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7377 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7416, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7378 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7417, cast(ADICAP_V3_2763_STARTDATE_2772#7386 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7418, cast(ADICAP_V3_2763_ENDDATE_2773#7382 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7419, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7381 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7420]
      +- Project [ANATOMYCODE_2770#7344 AS ADICAP_V3_2763_ANATOMYCODE_2770#7377, ANATOMYLABEL_2771#7345 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7378, CODEPARENT_2767#7346 AS ADICAP_V3_2763_CODEPARENT_2767#7379, CODE_2765#7347 AS ADICAP_V3_2763_CODE_2765#7380, DICTIONARYCODE_2774#7348 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7381, ENDDATE_2773#7349 AS ADICAP_V3_2763_ENDDATE_2773#7382, LIBELLEPARENT_2769#7350 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7383, LIBELLE_2768#7351 AS ADICAP_V3_2763_LIBELLE_2768#7384, PARENT_2766#7352 AS ADICAP_V3_2763_PARENT_2766#7385, STARTDATE_2772#7353 AS ADICAP_V3_2763_STARTDATE_2772#7386, URI_2764#7354 AS ADICAP_V3_2763_URI_2764#7387]
         +- SubqueryAlias ADICAP_V3_2763112
            +- Relation[ANATOMYCODE_2770#7344,ANATOMYLABEL_2771#7345,CODEPARENT_2767#7346,CODE_2765#7347,DICTIONARYCODE_2774#7348,ENDDATE_2773#7349,LIBELLEPARENT_2769#7350,LIBELLE_2768#7351,PARENT_2766#7352,STARTDATE_2772#7353,URI_2764#7354] parquet

== Optimized Logical Plan ==
Aggregate [count(1) AS count#7532L]
+- Project
   +- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7354)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7354)), PF0500) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7347)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7347)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7352)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7352)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7346)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7346)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7351)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7351)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7350)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7350)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7344)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7344)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7345)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7345)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7353)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7353)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7349)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7349)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7348)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7348)), PF0500) END)
      +- Relation[ANATOMYCODE_2770#7344,ANATOMYLABEL_2771#7345,CODEPARENT_2767#7346,CODE_2765#7347,DICTIONARYCODE_2774#7348,ENDDATE_2773#7349,LIBELLEPARENT_2769#7350,LIBELLE_2768#7351,PARENT_2766#7352,STARTDATE_2772#7353,URI_2764#7354] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- *(2) HashAggregate(keys=[], functions=[count(1)], output=[count#7532L])
   +- ShuffleQueryStage 0
      +- Exchange SinglePartition, true, [id=#1077]
         +- *(1) HashAggregate(keys=[], functions=[partial_count(1)], output=[count#7535L])
            +- *(1) Project
               +- *(1) Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7354)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7354)), PF0500) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7347)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7347)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7352)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7352)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7346)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7346)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7351)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7351)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7350)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7350)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7344)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7344)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7345)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7345)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7353)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7353)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7349)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7349)), PF0500) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7348)), PF0500)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7348)), PF0500) END)
                  +- *(1) ColumnarToRow
                     +- FileScan parquet [ANATOMYCODE_2770#7344,ANATOMYLABEL_2771#7345,CODEPARENT_2767#7346,CODE_2765#7347,DICTIONARYCODE_2774#7348,ENDDATE_2773#7349,LIBELLEPARENT_2769#7350,LIBELLE_2768#7351,PARENT_2766#7352,STARTDATE_2772#7353,URI_2764#7354] Batched: true, DataFilters: [((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7354)), 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...