hdh-spark-job - Details for Query 637

Submitted Time: 2026/10/21 21:34:13
Duration: 0.4 s
Succeeded Jobs: 583 584

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: 53 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 52 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 6,195"]; 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: 16 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=12694]

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

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODORG_437971#132661)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODORG_437971#132661)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPORG_437972#132701)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPORG_437972#132701)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOMORG_437973#132682)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NOMORG_437973#132682)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_1_437974#132653)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_1_437974#132653)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_2_437975#132654)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_2_437975#132654)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODPOS_437976#132662)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODPOS_437976#132662)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_VILLE_437977#132702)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_VILLE_437977#132702)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TELBUR_437978#132698)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TELBUR_437978#132698)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FAX_437979#132672)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FAX_437979#132672)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_E_MAIL_437980#132671)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_E_MAIL_437980#132671)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_PREFIX_437981#132692)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_PREFIX_437981#132692)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CONTAC_437982#132666)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CONTAC_437982#132666)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMBOR_437983#132685)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMBOR_437983#132685)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TAUXRE_437984#132697)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TAUXRE_437984#132697)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODREG_437985#132663)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODREG_437985#132663)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCAI_437986#132658)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCAI_437986#132658)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCEN_437987#132660)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCEN_437987#132660)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTELE_437988#132677)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTELE_437988#132677)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATMAJ_437989#132670)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATMAJ_437989#132670)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODUTI_437990#132664)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODUTI_437990#132664)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCCP_437991#132659)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCCP_437991#132659)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTP_437992#132679)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTP_437992#132679)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_IDMUT_437993#132680)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_IDMUT_437993#132680)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTOPR_437994#132678)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTOPR_437994#132678)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_437995#132686)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_437995#132686)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#132656)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#132656)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#132657)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#132657)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELCTX_437998#132694)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RELCTX_437998#132694)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELPAGE_437999#132695)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RELPAGE_437999#132695)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELREF_438000#132696)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RELREF_438000#132696)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATENV_438001#132669)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATENV_438001#132669)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEDE_438002#132667)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEDE_438002#132667)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEFI_438003#132668)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEFI_438003#132668)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPOC_438004#132700)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPOC_438004#132700)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#132691)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#132691)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_3_438006#132655)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_3_438006#132655)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTREL_438007#132684)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTREL_438007#132684)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_COMMENT_438008#132665)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_COMMENT_438008#132665)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPECDEP_438009#132676)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPECDEP_438009#132676)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#132687)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#132687)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPAV_438011#132675)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPAV_438011#132675)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RECLAM_438012#132693)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RECLAM_438012#132693)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TRIREL_438013#132699)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TRIREL_438013#132699)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTBORD_438014#132683)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTBORD_438014#132683)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLCHORUS_438015#132673)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLCHORUS_438015#132673)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMSIR_438016#132690)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMSIR_438016#132690)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLLISENG_438017#132674)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLLISENG_438017#132674)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_MODREG_438018#132681)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_MODREG_438018#132681)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#132688)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#132688)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#132689)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#132689)), ) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [RG_ADR_1_437974#132653,RG_ADR_2_437975#132654,RG_ADR_3_438006#132655,RG_CMPIMP_F_437996#132656,RG_CMPIMP_H_437997#132657,RG_CODCAI_437986#132658,RG_CODCCP_437991#132659,RG_CODCEN_437987#132660,RG_CODORG_437971#132661,RG_CODPOS_437976#132662,RG_CODREG_437985#132663,RG_CODUTI_437990#132664,RG_COMMENT_438008#132665,RG_CONTAC_437982#132666,RG_DATEDE_438002#132667,RG_DATEFI_438003#132668,RG_DATENV_438001#132669,RG_DATMAJ_437989#132670,RG_E_MAIL_437980#132671,RG_FAX_437979#132672,RG_FLCHORUS_438015#132673,RG_FLLISENG_438017#132674,RG_FLPAV_438011#132675,RG_FLPECDEP_438009#132676,... 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#132653, RG_ADR_2_437975#132654, RG_ADR_3_438006#132655, RG_CMPIMP_F_437996#132656, RG_CMPIMP_H_437997#132657, RG_CODCAI_437986#132658, RG_CODCCP_437991#132659, RG_CODCEN_437987#132660, RG_CODORG_437971#132661, RG_CODPOS_437976#132662, RG_CODREG_437985#132663, RG_CODUTI_437990#132664, RG_COMMENT_438008#132665, RG_CONTAC_437982#132666, RG_DATEDE_438002#132667, RG_DATEFI_438003#132668, RG_DATENV_438001#132669, RG_DATMAJ_437989#132670, RG_E_MAIL_437980#132671, RG_FAX_437979#132672, RG_FLCHORUS_438015#132673, RG_FLLISENG_438017#132674, RG_FLPAV_438011#132675, RG_FLPECDEP_438009#132676, RG_FLTELE_437988#132677, RG_FLTOPR_437994#132678, RG_FLTP_437992#132679, RG_IDMUT_437993#132680, RG_MODREG_438018#132681, RG_NOMORG_437973#132682, RG_NOTBORD_438014#132683, RG_NOTREL_438007#132684, RG_NUMBOR_437983#132685, RG_NUMCPT_437995#132686, RG_NUMCPT_A_438010#132687, RG_NUMCPT_C_438019#132688, RG_NUMCPT_C_FT_438020#132689, RG_NUMSIR_438016#132690, RG_ORGPAYEUR_438005#132691, RG_PREFIX_437981#132692, RG_RECLAM_438012#132693, RG_RELCTX_437998#132694, RG_RELPAGE_437999#132695, RG_RELREF_438000#132696, RG_TAUXRE_437984#132697, RG_TELBUR_437978#132698, RG_TRIREL_438013#132699, RG_TYPOC_438004#132700, RG_TYPORG_437972#132701, RG_VILLE_437977#132702]
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#132653, RG_ADR_2_437975#132654, RG_ADR_3_438006#132655, RG_CMPIMP_F_437996#132656, RG_CMPIMP_H_437997#132657, RG_CODCAI_437986#132658, RG_CODCCP_437991#132659, RG_CODCEN_437987#132660, RG_CODORG_437971#132661, RG_CODPOS_437976#132662, RG_CODREG_437985#132663, RG_CODUTI_437990#132664, RG_COMMENT_438008#132665, RG_CONTAC_437982#132666, RG_DATEDE_438002#132667, RG_DATEFI_438003#132668, RG_DATENV_438001#132669, RG_DATMAJ_437989#132670, RG_E_MAIL_437980#132671, RG_FAX_437979#132672, RG_FLCHORUS_438015#132673, RG_FLLISENG_438017#132674, RG_FLPAV_438011#132675, RG_FLPECDEP_438009#132676, RG_FLTELE_437988#132677, RG_FLTOPR_437994#132678, RG_FLTP_437992#132679, RG_IDMUT_437993#132680, RG_MODREG_438018#132681, RG_NOMORG_437973#132682, RG_NOTBORD_438014#132683, RG_NOTREL_438007#132684, RG_NUMBOR_437983#132685, RG_NUMCPT_437995#132686, RG_NUMCPT_A_438010#132687, RG_NUMCPT_C_438019#132688, RG_NUMCPT_C_FT_438020#132689, RG_NUMSIR_438016#132690, RG_ORGPAYEUR_438005#132691, RG_PREFIX_437981#132692, RG_RECLAM_438012#132693, RG_RELCTX_437998#132694, RG_RELPAGE_437999#132695, RG_RELREF_438000#132696, RG_TAUXRE_437984#132697, RG_TELBUR_437978#132698, RG_TRIREL_438013#132699, RG_TYPOC_438004#132700, RG_TYPORG_437972#132701, RG_VILLE_437977#132702]

(3) Filter [codegen id : 1]
Input [50]: [RG_ADR_1_437974#132653, RG_ADR_2_437975#132654, RG_ADR_3_438006#132655, RG_CMPIMP_F_437996#132656, RG_CMPIMP_H_437997#132657, RG_CODCAI_437986#132658, RG_CODCCP_437991#132659, RG_CODCEN_437987#132660, RG_CODORG_437971#132661, RG_CODPOS_437976#132662, RG_CODREG_437985#132663, RG_CODUTI_437990#132664, RG_COMMENT_438008#132665, RG_CONTAC_437982#132666, RG_DATEDE_438002#132667, RG_DATEFI_438003#132668, RG_DATENV_438001#132669, RG_DATMAJ_437989#132670, RG_E_MAIL_437980#132671, RG_FAX_437979#132672, RG_FLCHORUS_438015#132673, RG_FLLISENG_438017#132674, RG_FLPAV_438011#132675, RG_FLPECDEP_438009#132676, RG_FLTELE_437988#132677, RG_FLTOPR_437994#132678, RG_FLTP_437992#132679, RG_IDMUT_437993#132680, RG_MODREG_438018#132681, RG_NOMORG_437973#132682, RG_NOTBORD_438014#132683, RG_NOTREL_438007#132684, RG_NUMBOR_437983#132685, RG_NUMCPT_437995#132686, RG_NUMCPT_A_438010#132687, RG_NUMCPT_C_438019#132688, RG_NUMCPT_C_FT_438020#132689, RG_NUMSIR_438016#132690, RG_ORGPAYEUR_438005#132691, RG_PREFIX_437981#132692, RG_RECLAM_438012#132693, RG_RELCTX_437998#132694, RG_RELPAGE_437999#132695, RG_RELREF_438000#132696, RG_TAUXRE_437984#132697, RG_TELBUR_437978#132698, RG_TRIREL_438013#132699, RG_TYPOC_438004#132700, RG_TYPORG_437972#132701, RG_VILLE_437977#132702]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODORG_437971#132661)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODORG_437971#132661)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPORG_437972#132701)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPORG_437972#132701)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOMORG_437973#132682)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NOMORG_437973#132682)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_1_437974#132653)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_1_437974#132653)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_2_437975#132654)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_2_437975#132654)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODPOS_437976#132662)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODPOS_437976#132662)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_VILLE_437977#132702)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_VILLE_437977#132702)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TELBUR_437978#132698)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TELBUR_437978#132698)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FAX_437979#132672)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FAX_437979#132672)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_E_MAIL_437980#132671)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_E_MAIL_437980#132671)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_PREFIX_437981#132692)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_PREFIX_437981#132692)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CONTAC_437982#132666)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CONTAC_437982#132666)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMBOR_437983#132685)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMBOR_437983#132685)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TAUXRE_437984#132697)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TAUXRE_437984#132697)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODREG_437985#132663)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODREG_437985#132663)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCAI_437986#132658)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCAI_437986#132658)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCEN_437987#132660)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCEN_437987#132660)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTELE_437988#132677)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTELE_437988#132677)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATMAJ_437989#132670)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATMAJ_437989#132670)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODUTI_437990#132664)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODUTI_437990#132664)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCCP_437991#132659)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCCP_437991#132659)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTP_437992#132679)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTP_437992#132679)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_IDMUT_437993#132680)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_IDMUT_437993#132680)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTOPR_437994#132678)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTOPR_437994#132678)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_437995#132686)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_437995#132686)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#132656)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#132656)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#132657)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#132657)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELCTX_437998#132694)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RELCTX_437998#132694)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELPAGE_437999#132695)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RELPAGE_437999#132695)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELREF_438000#132696)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RELREF_438000#132696)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATENV_438001#132669)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATENV_438001#132669)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEDE_438002#132667)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEDE_438002#132667)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEFI_438003#132668)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEFI_438003#132668)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPOC_438004#132700)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPOC_438004#132700)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#132691)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#132691)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_3_438006#132655)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_3_438006#132655)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTREL_438007#132684)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTREL_438007#132684)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_COMMENT_438008#132665)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_COMMENT_438008#132665)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPECDEP_438009#132676)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPECDEP_438009#132676)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#132687)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#132687)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPAV_438011#132675)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPAV_438011#132675)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RECLAM_438012#132693)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RECLAM_438012#132693)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TRIREL_438013#132699)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TRIREL_438013#132699)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTBORD_438014#132683)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTBORD_438014#132683)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLCHORUS_438015#132673)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLCHORUS_438015#132673)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMSIR_438016#132690)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMSIR_438016#132690)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLLISENG_438017#132674)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLLISENG_438017#132674)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_MODREG_438018#132681)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_MODREG_438018#132681)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#132688)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#132688)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#132689)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#132689)), ) END)

(4) Project [codegen id : 1]
Output: []
Input [50]: [RG_ADR_1_437974#132653, RG_ADR_2_437975#132654, RG_ADR_3_438006#132655, RG_CMPIMP_F_437996#132656, RG_CMPIMP_H_437997#132657, RG_CODCAI_437986#132658, RG_CODCCP_437991#132659, RG_CODCEN_437987#132660, RG_CODORG_437971#132661, RG_CODPOS_437976#132662, RG_CODREG_437985#132663, RG_CODUTI_437990#132664, RG_COMMENT_438008#132665, RG_CONTAC_437982#132666, RG_DATEDE_438002#132667, RG_DATEFI_438003#132668, RG_DATENV_438001#132669, RG_DATMAJ_437989#132670, RG_E_MAIL_437980#132671, RG_FAX_437979#132672, RG_FLCHORUS_438015#132673, RG_FLLISENG_438017#132674, RG_FLPAV_438011#132675, RG_FLPECDEP_438009#132676, RG_FLTELE_437988#132677, RG_FLTOPR_437994#132678, RG_FLTP_437992#132679, RG_IDMUT_437993#132680, RG_MODREG_438018#132681, RG_NOMORG_437973#132682, RG_NOTBORD_438014#132683, RG_NOTREL_438007#132684, RG_NUMBOR_437983#132685, RG_NUMCPT_437995#132686, RG_NUMCPT_A_438010#132687, RG_NUMCPT_C_438019#132688, RG_NUMCPT_C_FT_438020#132689, RG_NUMSIR_438016#132690, RG_ORGPAYEUR_438005#132691, RG_PREFIX_437981#132692, RG_RECLAM_438012#132693, RG_RELCTX_437998#132694, RG_RELPAGE_437999#132695, RG_RELREF_438000#132696, RG_TAUXRE_437984#132697, RG_TELBUR_437978#132698, RG_TRIREL_438013#132699, RG_TYPOC_438004#132700, RG_TYPORG_437972#132701, RG_VILLE_437977#132702]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#133383L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#133320L]
Results [1]: [count(1)#133320L AS COL_215da1da-049d-4d49-8e32-29e5b981805f#133323L]

(9) Filter
Input [50]: [RG_ADR_1_437974#132653, RG_ADR_2_437975#132654, RG_ADR_3_438006#132655, RG_CMPIMP_F_437996#132656, RG_CMPIMP_H_437997#132657, RG_CODCAI_437986#132658, RG_CODCCP_437991#132659, RG_CODCEN_437987#132660, RG_CODORG_437971#132661, RG_CODPOS_437976#132662, RG_CODREG_437985#132663, RG_CODUTI_437990#132664, RG_COMMENT_438008#132665, RG_CONTAC_437982#132666, RG_DATEDE_438002#132667, RG_DATEFI_438003#132668, RG_DATENV_438001#132669, RG_DATMAJ_437989#132670, RG_E_MAIL_437980#132671, RG_FAX_437979#132672, RG_FLCHORUS_438015#132673, RG_FLLISENG_438017#132674, RG_FLPAV_438011#132675, RG_FLPECDEP_438009#132676, RG_FLTELE_437988#132677, RG_FLTOPR_437994#132678, RG_FLTP_437992#132679, RG_IDMUT_437993#132680, RG_MODREG_438018#132681, RG_NOMORG_437973#132682, RG_NOTBORD_438014#132683, RG_NOTREL_438007#132684, RG_NUMBOR_437983#132685, RG_NUMCPT_437995#132686, RG_NUMCPT_A_438010#132687, RG_NUMCPT_C_438019#132688, RG_NUMCPT_C_FT_438020#132689, RG_NUMSIR_438016#132690, RG_ORGPAYEUR_438005#132691, RG_PREFIX_437981#132692, RG_RECLAM_438012#132693, RG_RELCTX_437998#132694, RG_RELPAGE_437999#132695, RG_RELREF_438000#132696, RG_TAUXRE_437984#132697, RG_TELBUR_437978#132698, RG_TRIREL_438013#132699, RG_TYPOC_438004#132700, RG_TYPORG_437972#132701, RG_VILLE_437977#132702]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODORG_437971#132661)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODORG_437971#132661)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPORG_437972#132701)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPORG_437972#132701)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOMORG_437973#132682)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NOMORG_437973#132682)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_1_437974#132653)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_1_437974#132653)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_2_437975#132654)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_2_437975#132654)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODPOS_437976#132662)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODPOS_437976#132662)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_VILLE_437977#132702)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_VILLE_437977#132702)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TELBUR_437978#132698)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TELBUR_437978#132698)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FAX_437979#132672)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FAX_437979#132672)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_E_MAIL_437980#132671)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_E_MAIL_437980#132671)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_PREFIX_437981#132692)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_PREFIX_437981#132692)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CONTAC_437982#132666)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CONTAC_437982#132666)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMBOR_437983#132685)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMBOR_437983#132685)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TAUXRE_437984#132697)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TAUXRE_437984#132697)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODREG_437985#132663)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODREG_437985#132663)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCAI_437986#132658)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCAI_437986#132658)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCEN_437987#132660)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCEN_437987#132660)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTELE_437988#132677)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTELE_437988#132677)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATMAJ_437989#132670)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATMAJ_437989#132670)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODUTI_437990#132664)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODUTI_437990#132664)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CODCCP_437991#132659)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CODCCP_437991#132659)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTP_437992#132679)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTP_437992#132679)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_IDMUT_437993#132680)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_IDMUT_437993#132680)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLTOPR_437994#132678)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLTOPR_437994#132678)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_437995#132686)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_437995#132686)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#132656)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_F_437996#132656)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#132657)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_CMPIMP_H_437997#132657)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELCTX_437998#132694)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RELCTX_437998#132694)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELPAGE_437999#132695)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RELPAGE_437999#132695)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RELREF_438000#132696)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RELREF_438000#132696)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATENV_438001#132669)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATENV_438001#132669)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEDE_438002#132667)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEDE_438002#132667)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_DATEFI_438003#132668)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_DATEFI_438003#132668)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TYPOC_438004#132700)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TYPOC_438004#132700)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#132691)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ORGPAYEUR_438005#132691)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_ADR_3_438006#132655)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_ADR_3_438006#132655)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTREL_438007#132684)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTREL_438007#132684)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_COMMENT_438008#132665)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_COMMENT_438008#132665)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPECDEP_438009#132676)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPECDEP_438009#132676)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#132687)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_A_438010#132687)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLPAV_438011#132675)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLPAV_438011#132675)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_RECLAM_438012#132693)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_RECLAM_438012#132693)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_TRIREL_438013#132699)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_TRIREL_438013#132699)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NOTBORD_438014#132683)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NOTBORD_438014#132683)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLCHORUS_438015#132673)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLCHORUS_438015#132673)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMSIR_438016#132690)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMSIR_438016#132690)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_FLLISENG_438017#132674)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_FLLISENG_438017#132674)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_MODREG_438018#132681)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_MODREG_438018#132681)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#132688)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_438019#132688)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#132689)), )) THEN false ELSE Contains(str_remove_accent(upper(RG_NUMCPT_C_FT_438020#132689)), ) END)

(10) Project
Output: []
Input [50]: [RG_ADR_1_437974#132653, RG_ADR_2_437975#132654, RG_ADR_3_438006#132655, RG_CMPIMP_F_437996#132656, RG_CMPIMP_H_437997#132657, RG_CODCAI_437986#132658, RG_CODCCP_437991#132659, RG_CODCEN_437987#132660, RG_CODORG_437971#132661, RG_CODPOS_437976#132662, RG_CODREG_437985#132663, RG_CODUTI_437990#132664, RG_COMMENT_438008#132665, RG_CONTAC_437982#132666, RG_DATEDE_438002#132667, RG_DATEFI_438003#132668, RG_DATENV_438001#132669, RG_DATMAJ_437989#132670, RG_E_MAIL_437980#132671, RG_FAX_437979#132672, RG_FLCHORUS_438015#132673, RG_FLLISENG_438017#132674, RG_FLPAV_438011#132675, RG_FLPECDEP_438009#132676, RG_FLTELE_437988#132677, RG_FLTOPR_437994#132678, RG_FLTP_437992#132679, RG_IDMUT_437993#132680, RG_MODREG_438018#132681, RG_NOMORG_437973#132682, RG_NOTBORD_438014#132683, RG_NOTREL_438007#132684, RG_NUMBOR_437983#132685, RG_NUMCPT_437995#132686, RG_NUMCPT_A_438010#132687, RG_NUMCPT_C_438019#132688, RG_NUMCPT_C_FT_438020#132689, RG_NUMSIR_438016#132690, RG_ORGPAYEUR_438005#132691, RG_PREFIX_437981#132692, RG_RECLAM_438012#132693, RG_RELCTX_437998#132694, RG_RELPAGE_437999#132695, RG_RELREF_438000#132696, RG_TAUXRE_437984#132697, RG_TELBUR_437978#132698, RG_TRIREL_438013#132699, RG_TYPOC_438004#132700, RG_TYPORG_437972#132701, RG_VILLE_437977#132702]

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

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

(13) HashAggregate
Input [1]: [count#133383L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#133320L]
Results [1]: [count(1)#133320L AS COL_215da1da-049d-4d49-8e32-29e5b981805f#133323L]

(14) AdaptiveSparkPlan
Output [1]: [COL_215da1da-049d-4d49-8e32-29e5b981805f#133323L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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