EVAL1_SPC2 - Details for Query 59

Details for Query 59

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

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: 188 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 187 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 5"]; 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=#1134]

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

Project

Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7580)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7580)), 0000) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7573)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7573)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7578)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7578)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7572)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7572)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7577)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7577)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7576)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7576)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7570)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7570)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7571)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7571)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7579)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7579)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7575)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7575)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7574)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7574)), 0000) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ANATOMYCODE_2770#7570,ANATOMYLABEL_2771#7571,CODEPARENT_2767#7572,CODE_2765#7573,DICTIONARYCODE_2774#7574,ENDDATE_2773#7575,LIBELLEPARENT_2769#7576,LIBELLE_2768#7577,PARENT_2766#7578,STARTDATE_2772#7579,URI_2764#7580] Batched: true, DataFilters: [((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7580)), 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 ==
Aggregate [count(1) AS count#7692L]
+- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7636)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7636)), cast(0000 as string)) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7637)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7637)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7638)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7638)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7639)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7639)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7640)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7640)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7641)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7641)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7642)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7642)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7643)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7643)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7644)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7644)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7645)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7645)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7646)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7646)), cast(0000 as string)) END)
   +- Project [cast(ADICAP_V3_2763_URI_2764#7613 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7636, cast(ADICAP_V3_2763_CODE_2765#7606 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7637, cast(ADICAP_V3_2763_PARENT_2766#7611 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7638, cast(ADICAP_V3_2763_CODEPARENT_2767#7605 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7639, cast(ADICAP_V3_2763_LIBELLE_2768#7610 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7640, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7609 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7641, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7603 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7642, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7604 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7643, cast(ADICAP_V3_2763_STARTDATE_2772#7612 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7644, cast(ADICAP_V3_2763_ENDDATE_2773#7608 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7645, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7607 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7646]
      +- Project [ANATOMYCODE_2770#7570 AS ADICAP_V3_2763_ANATOMYCODE_2770#7603, ANATOMYLABEL_2771#7571 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7604, CODEPARENT_2767#7572 AS ADICAP_V3_2763_CODEPARENT_2767#7605, CODE_2765#7573 AS ADICAP_V3_2763_CODE_2765#7606, DICTIONARYCODE_2774#7574 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7607, ENDDATE_2773#7575 AS ADICAP_V3_2763_ENDDATE_2773#7608, LIBELLEPARENT_2769#7576 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7609, LIBELLE_2768#7577 AS ADICAP_V3_2763_LIBELLE_2768#7610, PARENT_2766#7578 AS ADICAP_V3_2763_PARENT_2766#7611, STARTDATE_2772#7579 AS ADICAP_V3_2763_STARTDATE_2772#7612, URI_2764#7580 AS ADICAP_V3_2763_URI_2764#7613]
         +- SubqueryAlias ADICAP_V3_2763108
            +- Relation[ANATOMYCODE_2770#7570,ANATOMYLABEL_2771#7571,CODEPARENT_2767#7572,CODE_2765#7573,DICTIONARYCODE_2774#7574,ENDDATE_2773#7575,LIBELLEPARENT_2769#7576,LIBELLE_2768#7577,PARENT_2766#7578,STARTDATE_2772#7579,URI_2764#7580] parquet

== Analyzed Logical Plan ==
count: bigint
Aggregate [count(1) AS count#7692L]
+- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7636)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7636)), cast(0000 as string)) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7637)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7637)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7638)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7638)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7639)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7639)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7640)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7640)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7641)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_D472A873_1242_4F73_B703_84133E7F376C#7641)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7642)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7642)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7643)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7643)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7644)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7644)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7645)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7645)), cast(0000 as string)) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7646)), cast(0000 as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_B752B85C_FAFD_434B_BEB1_25579727A129#7646)), cast(0000 as string)) END)
   +- Project [cast(ADICAP_V3_2763_URI_2764#7613 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7636, cast(ADICAP_V3_2763_CODE_2765#7606 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7637, cast(ADICAP_V3_2763_PARENT_2766#7611 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7638, cast(ADICAP_V3_2763_CODEPARENT_2767#7605 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7639, cast(ADICAP_V3_2763_LIBELLE_2768#7610 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7640, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7609 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7641, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7603 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7642, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7604 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7643, cast(ADICAP_V3_2763_STARTDATE_2772#7612 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7644, cast(ADICAP_V3_2763_ENDDATE_2773#7608 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7645, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7607 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7646]
      +- Project [ANATOMYCODE_2770#7570 AS ADICAP_V3_2763_ANATOMYCODE_2770#7603, ANATOMYLABEL_2771#7571 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7604, CODEPARENT_2767#7572 AS ADICAP_V3_2763_CODEPARENT_2767#7605, CODE_2765#7573 AS ADICAP_V3_2763_CODE_2765#7606, DICTIONARYCODE_2774#7574 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7607, ENDDATE_2773#7575 AS ADICAP_V3_2763_ENDDATE_2773#7608, LIBELLEPARENT_2769#7576 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7609, LIBELLE_2768#7577 AS ADICAP_V3_2763_LIBELLE_2768#7610, PARENT_2766#7578 AS ADICAP_V3_2763_PARENT_2766#7611, STARTDATE_2772#7579 AS ADICAP_V3_2763_STARTDATE_2772#7612, URI_2764#7580 AS ADICAP_V3_2763_URI_2764#7613]
         +- SubqueryAlias ADICAP_V3_2763108
            +- Relation[ANATOMYCODE_2770#7570,ANATOMYLABEL_2771#7571,CODEPARENT_2767#7572,CODE_2765#7573,DICTIONARYCODE_2774#7574,ENDDATE_2773#7575,LIBELLEPARENT_2769#7576,LIBELLE_2768#7577,PARENT_2766#7578,STARTDATE_2772#7579,URI_2764#7580] parquet

== Optimized Logical Plan ==
Aggregate [count(1) AS count#7692L]
+- Project
   +- Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7580)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7580)), 0000) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7573)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7573)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7578)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7578)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7572)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7572)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7577)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7577)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7576)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7576)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7570)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7570)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7571)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7571)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7579)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7579)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7575)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7575)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7574)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7574)), 0000) END)
      +- Relation[ANATOMYCODE_2770#7570,ANATOMYLABEL_2771#7571,CODEPARENT_2767#7572,CODE_2765#7573,DICTIONARYCODE_2774#7574,ENDDATE_2773#7575,LIBELLEPARENT_2769#7576,LIBELLE_2768#7577,PARENT_2766#7578,STARTDATE_2772#7579,URI_2764#7580] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- *(2) HashAggregate(keys=[], functions=[count(1)], output=[count#7692L])
   +- ShuffleQueryStage 0
      +- Exchange SinglePartition, true, [id=#1134]
         +- *(1) HashAggregate(keys=[], functions=[partial_count(1)], output=[count#7761L])
            +- *(1) Project
               +- *(1) Filter ((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7580)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(URI_2764#7580)), 0000) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODE_2765#7573)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODE_2765#7573)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PARENT_2766#7578)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(PARENT_2766#7578)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CODEPARENT_2767#7572)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(CODEPARENT_2767#7572)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLE_2768#7577)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLE_2768#7577)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7576)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(LIBELLEPARENT_2769#7576)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYCODE_2770#7570)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYCODE_2770#7570)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7571)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ANATOMYLABEL_2771#7571)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(STARTDATE_2772#7579)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(STARTDATE_2772#7579)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ENDDATE_2773#7575)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(ENDDATE_2773#7575)), 0000) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7574)), 0000)) THEN false ELSE Contains(str_remove_accent(upper(DICTIONARYCODE_2774#7574)), 0000) END)
                  +- *(1) ColumnarToRow
                     +- FileScan parquet [ANATOMYCODE_2770#7570,ANATOMYLABEL_2771#7571,CODEPARENT_2767#7572,CODE_2765#7573,DICTIONARYCODE_2774#7574,ENDDATE_2773#7575,LIBELLEPARENT_2769#7576,LIBELLE_2768#7577,PARENT_2766#7578,STARTDATE_2772#7579,URI_2764#7580] Batched: true, DataFilters: [((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(URI_2764#7580)), 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...