hdh-spark-job - Details for Query 601

Submitted Time: 2026/10/21 21:31:49
Duration: 0.8 s
Succeeded Jobs: 533 536

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 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 221 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 220 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 1"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 6,195 number of input batches: 2"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 9 ms metadata time: 0 ms size of files read: 314.4 KiB number of output rows: 6,195"]; 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, ENSURE_REQUIREMENTS, [plan_id=11851]

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

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODORG_437971#122931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODORG_437971#122931)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPORG_437972#122971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPORG_437972#122971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOMORG_437973#122952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NOMORG_437973#122952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_1_437974#122923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_1_437974#122923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_2_437975#122924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_2_437975#122924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODPOS_437976#122932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODPOS_437976#122932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_VILLE_437977#122972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_VILLE_437977#122972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TELBUR_437978#122968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TELBUR_437978#122968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FAX_437979#122942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FAX_437979#122942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_E_MAIL_437980#122941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_E_MAIL_437980#122941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_PREFIX_437981#122962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_PREFIX_437981#122962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CONTAC_437982#122936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CONTAC_437982#122936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMBOR_437983#122955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMBOR_437983#122955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TAUXRE_437984#122967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TAUXRE_437984#122967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODREG_437985#122933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODREG_437985#122933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCAI_437986#122928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCAI_437986#122928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCEN_437987#122930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCEN_437987#122930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTELE_437988#122947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTELE_437988#122947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATMAJ_437989#122940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATMAJ_437989#122940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODUTI_437990#122934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODUTI_437990#122934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCCP_437991#122929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCCP_437991#122929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTP_437992#122949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTP_437992#122949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_IDMUT_437993#122950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_IDMUT_437993#122950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTOPR_437994#122948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTOPR_437994#122948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_437995#122956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_437995#122956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#122926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#122926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#122927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#122927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELCTX_437998#122964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RELCTX_437998#122964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELPAGE_437999#122965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RELPAGE_437999#122965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELREF_438000#122966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RELREF_438000#122966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATENV_438001#122939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATENV_438001#122939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEDE_438002#122937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEDE_438002#122937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEFI_438003#122938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEFI_438003#122938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPOC_438004#122970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPOC_438004#122970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#122961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#122961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_3_438006#122925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_3_438006#122925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTREL_438007#122954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTREL_438007#122954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_COMMENT_438008#122935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_COMMENT_438008#122935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPECDEP_438009#122946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPECDEP_438009#122946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#122957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#122957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPAV_438011#122945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPAV_438011#122945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RECLAM_438012#122963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RECLAM_438012#122963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TRIREL_438013#122969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TRIREL_438013#122969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTBORD_438014#122953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTBORD_438014#122953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLCHORUS_438015#122943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLCHORUS_438015#122943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMSIR_438016#122960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMSIR_438016#122960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLLISENG_438017#122944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLLISENG_438017#122944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_MODREG_438018#122951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_MODREG_438018#122951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#122958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#122958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#122959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#122959)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [RG_ADR_1_437974#122923,RG_ADR_2_437975#122924,RG_ADR_3_438006#122925,RG_CMPIMP_F_437996#122926,RG_CMPIMP_H_437997#122927,RG_CODCAI_437986#122928,RG_CODCCP_437991#122929,RG_CODCEN_437987#122930,RG_CODORG_437971#122931,RG_CODPOS_437976#122932,RG_CODREG_437985#122933,RG_CODUTI_437990#122934,RG_COMMENT_438008#122935,RG_CONTAC_437982#122936,RG_DATEDE_438002#122937,RG_DATEFI_438003#122938,RG_DATENV_438001#122939,RG_DATMAJ_437989#122940,RG_E_MAIL_437980#122941,RG_FAX_437979#122942,RG_FLCHORUS_438015#122943,RG_FLLISENG_438017#122944,RG_FLPAV_438011#122945,RG_FLPECDEP_438009#122946,... 26 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upp..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_ORGAN_437970], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<RG_ADR_1_437974:string,RG_ADR_2_437975:string,RG_ADR_3_438006:string,RG_CMPIMP_F_437996:st...

Details

== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
   * HashAggregate (8)
   +- ShuffleQueryStage (7), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (6)
         +- * HashAggregate (5)
            +- * Project (4)
               +- * Filter (3)
                  +- * ColumnarToRow (2)
                     +- Scan parquet  (1)
+- == Initial Plan ==
   HashAggregate (13)
   +- Exchange (12)
      +- HashAggregate (11)
         +- Project (10)
            +- Filter (9)
               +- Scan parquet  (1)


(1) Scan parquet 
Output [50]: [RG_ADR_1_437974#122923, RG_ADR_2_437975#122924, RG_ADR_3_438006#122925, RG_CMPIMP_F_437996#122926, RG_CMPIMP_H_437997#122927, RG_CODCAI_437986#122928, RG_CODCCP_437991#122929, RG_CODCEN_437987#122930, RG_CODORG_437971#122931, RG_CODPOS_437976#122932, RG_CODREG_437985#122933, RG_CODUTI_437990#122934, RG_COMMENT_438008#122935, RG_CONTAC_437982#122936, RG_DATEDE_438002#122937, RG_DATEFI_438003#122938, RG_DATENV_438001#122939, RG_DATMAJ_437989#122940, RG_E_MAIL_437980#122941, RG_FAX_437979#122942, RG_FLCHORUS_438015#122943, RG_FLLISENG_438017#122944, RG_FLPAV_438011#122945, RG_FLPECDEP_438009#122946, RG_FLTELE_437988#122947, RG_FLTOPR_437994#122948, RG_FLTP_437992#122949, RG_IDMUT_437993#122950, RG_MODREG_438018#122951, RG_NOMORG_437973#122952, RG_NOTBORD_438014#122953, RG_NOTREL_438007#122954, RG_NUMBOR_437983#122955, RG_NUMCPT_437995#122956, RG_NUMCPT_A_438010#122957, RG_NUMCPT_C_438019#122958, RG_NUMCPT_C_FT_438020#122959, RG_NUMSIR_438016#122960, RG_ORGPAYEUR_438005#122961, RG_PREFIX_437981#122962, RG_RECLAM_438012#122963, RG_RELCTX_437998#122964, RG_RELPAGE_437999#122965, RG_RELREF_438000#122966, RG_TAUXRE_437984#122967, RG_TELBUR_437978#122968, RG_TRIREL_438013#122969, RG_TYPOC_438004#122970, RG_TYPORG_437972#122971, RG_VILLE_437977#122972]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_ORGAN_437970]
ReadSchema: struct<RG_ADR_1_437974:string,RG_ADR_2_437975:string,RG_ADR_3_438006:string,RG_CMPIMP_F_437996:string,RG_CMPIMP_H_437997:string,RG_CODCAI_437986:string,RG_CODCCP_437991:string,RG_CODCEN_437987:string,RG_CODORG_437971:string,RG_CODPOS_437976:string,RG_CODREG_437985:string,RG_CODUTI_437990:string,RG_COMMENT_438008:string,RG_CONTAC_437982:string,RG_DATEDE_438002:string,RG_DATEFI_438003:string,RG_DATENV_438001:string,RG_DATMAJ_437989:string,RG_E_MAIL_437980:string,RG_FAX_437979:string,RG_FLCHORUS_438015:string,RG_FLLISENG_438017:string,RG_FLPAV_438011:string,RG_FLPECDEP_438009:string,RG_FLTELE_437988:string,RG_FLTOPR_437994:string,RG_FLTP_437992:string,RG_IDMUT_437993:string,RG_MODREG_438018:string,RG_NOMORG_437973:string,RG_NOTBORD_438014:string,RG_NOTREL_438007:string,RG_NUMBOR_437983:string,RG_NUMCPT_437995:string,RG_NUMCPT_A_438010:string,RG_NUMCPT_C_438019:string,RG_NUMCPT_C_FT_438020:string,RG_NUMSIR_438016:string,RG_ORGPAYEUR_438005:string,RG_PREFIX_437981:string,RG_RECLAM_438012:string,RG_RELCTX_437998:string,RG_RELPAGE_437999:string,RG_RELREF_438000:string,RG_TAUXRE_437984:string,RG_TELBUR_437978:string,RG_TRIREL_438013:string,RG_TYPOC_438004:string,RG_TYPORG_437972:string,RG_VILLE_437977:string>

(2) ColumnarToRow [codegen id : 1]
Input [50]: [RG_ADR_1_437974#122923, RG_ADR_2_437975#122924, RG_ADR_3_438006#122925, RG_CMPIMP_F_437996#122926, RG_CMPIMP_H_437997#122927, RG_CODCAI_437986#122928, RG_CODCCP_437991#122929, RG_CODCEN_437987#122930, RG_CODORG_437971#122931, RG_CODPOS_437976#122932, RG_CODREG_437985#122933, RG_CODUTI_437990#122934, RG_COMMENT_438008#122935, RG_CONTAC_437982#122936, RG_DATEDE_438002#122937, RG_DATEFI_438003#122938, RG_DATENV_438001#122939, RG_DATMAJ_437989#122940, RG_E_MAIL_437980#122941, RG_FAX_437979#122942, RG_FLCHORUS_438015#122943, RG_FLLISENG_438017#122944, RG_FLPAV_438011#122945, RG_FLPECDEP_438009#122946, RG_FLTELE_437988#122947, RG_FLTOPR_437994#122948, RG_FLTP_437992#122949, RG_IDMUT_437993#122950, RG_MODREG_438018#122951, RG_NOMORG_437973#122952, RG_NOTBORD_438014#122953, RG_NOTREL_438007#122954, RG_NUMBOR_437983#122955, RG_NUMCPT_437995#122956, RG_NUMCPT_A_438010#122957, RG_NUMCPT_C_438019#122958, RG_NUMCPT_C_FT_438020#122959, RG_NUMSIR_438016#122960, RG_ORGPAYEUR_438005#122961, RG_PREFIX_437981#122962, RG_RECLAM_438012#122963, RG_RELCTX_437998#122964, RG_RELPAGE_437999#122965, RG_RELREF_438000#122966, RG_TAUXRE_437984#122967, RG_TELBUR_437978#122968, RG_TRIREL_438013#122969, RG_TYPOC_438004#122970, RG_TYPORG_437972#122971, RG_VILLE_437977#122972]

(3) Filter [codegen id : 1]
Input [50]: [RG_ADR_1_437974#122923, RG_ADR_2_437975#122924, RG_ADR_3_438006#122925, RG_CMPIMP_F_437996#122926, RG_CMPIMP_H_437997#122927, RG_CODCAI_437986#122928, RG_CODCCP_437991#122929, RG_CODCEN_437987#122930, RG_CODORG_437971#122931, RG_CODPOS_437976#122932, RG_CODREG_437985#122933, RG_CODUTI_437990#122934, RG_COMMENT_438008#122935, RG_CONTAC_437982#122936, RG_DATEDE_438002#122937, RG_DATEFI_438003#122938, RG_DATENV_438001#122939, RG_DATMAJ_437989#122940, RG_E_MAIL_437980#122941, RG_FAX_437979#122942, RG_FLCHORUS_438015#122943, RG_FLLISENG_438017#122944, RG_FLPAV_438011#122945, RG_FLPECDEP_438009#122946, RG_FLTELE_437988#122947, RG_FLTOPR_437994#122948, RG_FLTP_437992#122949, RG_IDMUT_437993#122950, RG_MODREG_438018#122951, RG_NOMORG_437973#122952, RG_NOTBORD_438014#122953, RG_NOTREL_438007#122954, RG_NUMBOR_437983#122955, RG_NUMCPT_437995#122956, RG_NUMCPT_A_438010#122957, RG_NUMCPT_C_438019#122958, RG_NUMCPT_C_FT_438020#122959, RG_NUMSIR_438016#122960, RG_ORGPAYEUR_438005#122961, RG_PREFIX_437981#122962, RG_RECLAM_438012#122963, RG_RELCTX_437998#122964, RG_RELPAGE_437999#122965, RG_RELREF_438000#122966, RG_TAUXRE_437984#122967, RG_TELBUR_437978#122968, RG_TRIREL_438013#122969, RG_TYPOC_438004#122970, RG_TYPORG_437972#122971, RG_VILLE_437977#122972]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODORG_437971#122931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODORG_437971#122931)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPORG_437972#122971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPORG_437972#122971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOMORG_437973#122952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NOMORG_437973#122952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_1_437974#122923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_1_437974#122923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_2_437975#122924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_2_437975#122924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODPOS_437976#122932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODPOS_437976#122932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_VILLE_437977#122972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_VILLE_437977#122972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TELBUR_437978#122968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TELBUR_437978#122968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FAX_437979#122942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FAX_437979#122942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_E_MAIL_437980#122941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_E_MAIL_437980#122941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_PREFIX_437981#122962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_PREFIX_437981#122962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CONTAC_437982#122936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CONTAC_437982#122936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMBOR_437983#122955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMBOR_437983#122955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TAUXRE_437984#122967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TAUXRE_437984#122967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODREG_437985#122933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODREG_437985#122933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCAI_437986#122928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCAI_437986#122928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCEN_437987#122930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCEN_437987#122930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTELE_437988#122947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTELE_437988#122947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATMAJ_437989#122940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATMAJ_437989#122940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODUTI_437990#122934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODUTI_437990#122934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCCP_437991#122929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCCP_437991#122929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTP_437992#122949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTP_437992#122949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_IDMUT_437993#122950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_IDMUT_437993#122950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTOPR_437994#122948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTOPR_437994#122948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_437995#122956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_437995#122956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#122926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#122926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#122927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#122927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELCTX_437998#122964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RELCTX_437998#122964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELPAGE_437999#122965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RELPAGE_437999#122965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELREF_438000#122966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RELREF_438000#122966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATENV_438001#122939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATENV_438001#122939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEDE_438002#122937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEDE_438002#122937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEFI_438003#122938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEFI_438003#122938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPOC_438004#122970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPOC_438004#122970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#122961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#122961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_3_438006#122925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_3_438006#122925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTREL_438007#122954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTREL_438007#122954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_COMMENT_438008#122935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_COMMENT_438008#122935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPECDEP_438009#122946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPECDEP_438009#122946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#122957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#122957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPAV_438011#122945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPAV_438011#122945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RECLAM_438012#122963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RECLAM_438012#122963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TRIREL_438013#122969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TRIREL_438013#122969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTBORD_438014#122953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTBORD_438014#122953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLCHORUS_438015#122943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLCHORUS_438015#122943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMSIR_438016#122960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMSIR_438016#122960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLLISENG_438017#122944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLLISENG_438017#122944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_MODREG_438018#122951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_MODREG_438018#122951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#122958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#122958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#122959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#122959)), MARX) END)

(4) Project [codegen id : 1]
Output: []
Input [50]: [RG_ADR_1_437974#122923, RG_ADR_2_437975#122924, RG_ADR_3_438006#122925, RG_CMPIMP_F_437996#122926, RG_CMPIMP_H_437997#122927, RG_CODCAI_437986#122928, RG_CODCCP_437991#122929, RG_CODCEN_437987#122930, RG_CODORG_437971#122931, RG_CODPOS_437976#122932, RG_CODREG_437985#122933, RG_CODUTI_437990#122934, RG_COMMENT_438008#122935, RG_CONTAC_437982#122936, RG_DATEDE_438002#122937, RG_DATEFI_438003#122938, RG_DATENV_438001#122939, RG_DATMAJ_437989#122940, RG_E_MAIL_437980#122941, RG_FAX_437979#122942, RG_FLCHORUS_438015#122943, RG_FLLISENG_438017#122944, RG_FLPAV_438011#122945, RG_FLPECDEP_438009#122946, RG_FLTELE_437988#122947, RG_FLTOPR_437994#122948, RG_FLTP_437992#122949, RG_IDMUT_437993#122950, RG_MODREG_438018#122951, RG_NOMORG_437973#122952, RG_NOTBORD_438014#122953, RG_NOTREL_438007#122954, RG_NUMBOR_437983#122955, RG_NUMCPT_437995#122956, RG_NUMCPT_A_438010#122957, RG_NUMCPT_C_438019#122958, RG_NUMCPT_C_FT_438020#122959, RG_NUMSIR_438016#122960, RG_ORGPAYEUR_438005#122961, RG_PREFIX_437981#122962, RG_RECLAM_438012#122963, RG_RELCTX_437998#122964, RG_RELPAGE_437999#122965, RG_RELREF_438000#122966, RG_TAUXRE_437984#122967, RG_TELBUR_437978#122968, RG_TRIREL_438013#122969, RG_TYPOC_438004#122970, RG_TYPORG_437972#122971, RG_VILLE_437977#122972]

(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#124253L]
Results [1]: [count#124254L]

(6) Exchange
Input [1]: [count#124254L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=11851]

(7) ShuffleQueryStage
Output [1]: [count#124254L]
Arguments: 0

(8) HashAggregate [codegen id : 2]
Input [1]: [count#124254L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#123370L]
Results [1]: [count(1)#123370L AS COL_a884066c-303c-4c8f-83c6-60f85f4ff50e#123372L]

(9) Filter
Input [50]: [RG_ADR_1_437974#122923, RG_ADR_2_437975#122924, RG_ADR_3_438006#122925, RG_CMPIMP_F_437996#122926, RG_CMPIMP_H_437997#122927, RG_CODCAI_437986#122928, RG_CODCCP_437991#122929, RG_CODCEN_437987#122930, RG_CODORG_437971#122931, RG_CODPOS_437976#122932, RG_CODREG_437985#122933, RG_CODUTI_437990#122934, RG_COMMENT_438008#122935, RG_CONTAC_437982#122936, RG_DATEDE_438002#122937, RG_DATEFI_438003#122938, RG_DATENV_438001#122939, RG_DATMAJ_437989#122940, RG_E_MAIL_437980#122941, RG_FAX_437979#122942, RG_FLCHORUS_438015#122943, RG_FLLISENG_438017#122944, RG_FLPAV_438011#122945, RG_FLPECDEP_438009#122946, RG_FLTELE_437988#122947, RG_FLTOPR_437994#122948, RG_FLTP_437992#122949, RG_IDMUT_437993#122950, RG_MODREG_438018#122951, RG_NOMORG_437973#122952, RG_NOTBORD_438014#122953, RG_NOTREL_438007#122954, RG_NUMBOR_437983#122955, RG_NUMCPT_437995#122956, RG_NUMCPT_A_438010#122957, RG_NUMCPT_C_438019#122958, RG_NUMCPT_C_FT_438020#122959, RG_NUMSIR_438016#122960, RG_ORGPAYEUR_438005#122961, RG_PREFIX_437981#122962, RG_RECLAM_438012#122963, RG_RELCTX_437998#122964, RG_RELPAGE_437999#122965, RG_RELREF_438000#122966, RG_TAUXRE_437984#122967, RG_TELBUR_437978#122968, RG_TRIREL_438013#122969, RG_TYPOC_438004#122970, RG_TYPORG_437972#122971, RG_VILLE_437977#122972]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODORG_437971#122931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODORG_437971#122931)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPORG_437972#122971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPORG_437972#122971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOMORG_437973#122952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NOMORG_437973#122952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_1_437974#122923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_1_437974#122923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_2_437975#122924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_2_437975#122924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODPOS_437976#122932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODPOS_437976#122932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_VILLE_437977#122972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_VILLE_437977#122972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TELBUR_437978#122968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TELBUR_437978#122968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FAX_437979#122942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FAX_437979#122942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_E_MAIL_437980#122941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_E_MAIL_437980#122941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_PREFIX_437981#122962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_PREFIX_437981#122962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CONTAC_437982#122936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CONTAC_437982#122936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMBOR_437983#122955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMBOR_437983#122955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TAUXRE_437984#122967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TAUXRE_437984#122967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODREG_437985#122933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODREG_437985#122933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCAI_437986#122928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCAI_437986#122928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCEN_437987#122930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCEN_437987#122930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTELE_437988#122947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTELE_437988#122947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATMAJ_437989#122940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATMAJ_437989#122940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODUTI_437990#122934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODUTI_437990#122934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCCP_437991#122929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCCP_437991#122929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTP_437992#122949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTP_437992#122949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_IDMUT_437993#122950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_IDMUT_437993#122950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTOPR_437994#122948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTOPR_437994#122948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_437995#122956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_437995#122956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#122926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#122926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#122927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#122927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELCTX_437998#122964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RELCTX_437998#122964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELPAGE_437999#122965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RELPAGE_437999#122965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELREF_438000#122966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RELREF_438000#122966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATENV_438001#122939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATENV_438001#122939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEDE_438002#122937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEDE_438002#122937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEFI_438003#122938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEFI_438003#122938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPOC_438004#122970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPOC_438004#122970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#122961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#122961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_3_438006#122925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_3_438006#122925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTREL_438007#122954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTREL_438007#122954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_COMMENT_438008#122935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_COMMENT_438008#122935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPECDEP_438009#122946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPECDEP_438009#122946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#122957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#122957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPAV_438011#122945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPAV_438011#122945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RECLAM_438012#122963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_RECLAM_438012#122963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TRIREL_438013#122969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_TRIREL_438013#122969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTBORD_438014#122953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTBORD_438014#122953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLCHORUS_438015#122943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLCHORUS_438015#122943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMSIR_438016#122960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMSIR_438016#122960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLLISENG_438017#122944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_FLLISENG_438017#122944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_MODREG_438018#122951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_MODREG_438018#122951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#122958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#122958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#122959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#122959)), MARX) END)

(10) Project
Output: []
Input [50]: [RG_ADR_1_437974#122923, RG_ADR_2_437975#122924, RG_ADR_3_438006#122925, RG_CMPIMP_F_437996#122926, RG_CMPIMP_H_437997#122927, RG_CODCAI_437986#122928, RG_CODCCP_437991#122929, RG_CODCEN_437987#122930, RG_CODORG_437971#122931, RG_CODPOS_437976#122932, RG_CODREG_437985#122933, RG_CODUTI_437990#122934, RG_COMMENT_438008#122935, RG_CONTAC_437982#122936, RG_DATEDE_438002#122937, RG_DATEFI_438003#122938, RG_DATENV_438001#122939, RG_DATMAJ_437989#122940, RG_E_MAIL_437980#122941, RG_FAX_437979#122942, RG_FLCHORUS_438015#122943, RG_FLLISENG_438017#122944, RG_FLPAV_438011#122945, RG_FLPECDEP_438009#122946, RG_FLTELE_437988#122947, RG_FLTOPR_437994#122948, RG_FLTP_437992#122949, RG_IDMUT_437993#122950, RG_MODREG_438018#122951, RG_NOMORG_437973#122952, RG_NOTBORD_438014#122953, RG_NOTREL_438007#122954, RG_NUMBOR_437983#122955, RG_NUMCPT_437995#122956, RG_NUMCPT_A_438010#122957, RG_NUMCPT_C_438019#122958, RG_NUMCPT_C_FT_438020#122959, RG_NUMSIR_438016#122960, RG_ORGPAYEUR_438005#122961, RG_PREFIX_437981#122962, RG_RECLAM_438012#122963, RG_RELCTX_437998#122964, RG_RELPAGE_437999#122965, RG_RELREF_438000#122966, RG_TAUXRE_437984#122967, RG_TELBUR_437978#122968, RG_TRIREL_438013#122969, RG_TYPOC_438004#122970, RG_TYPORG_437972#122971, RG_VILLE_437977#122972]

(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#124253L]
Results [1]: [count#124254L]

(12) Exchange
Input [1]: [count#124254L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=11831]

(13) HashAggregate
Input [1]: [count#124254L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#123370L]
Results [1]: [count(1)#123370L AS COL_a884066c-303c-4c8f-83c6-60f85f4ff50e#123372L]

(14) AdaptiveSparkPlan
Output [1]: [COL_a884066c-303c-4c8f-83c6-60f85f4ff50e#123372L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet