hdh-spark-job - Details for Query 752

Submitted Time: 2026/10/21 21:36:52
Duration: 7 s
Succeeded Jobs: 750 754

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: 56.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: 56.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 670 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 670 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 0"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 9,180 number of input batches: 3"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 8 ms metadata time: 0 ms size of files read: 242.6 KiB number of output rows: 9,180"]; 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=15602]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODVAL_438377#166058)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODVAL_438377#166058)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ANNVAL_438378#166053)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ANNVAL_438378#166053)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_VALCOU_438379#166111)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_VALCOU_438379#166111)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIB30_438380#166073)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIB30_438380#166073)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIBMAJ_438381#166074)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIBMAJ_438381#166074)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_438382#166086)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_438382#166086)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIOR_438383#166080)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIOR_438383#166080)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_438384#166107)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_438384#166107)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATMAJ_438385#166062)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATMAJ_438385#166062)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODUTI_438386#166057)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODUTI_438386#166057)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODSIT_438387#166056)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODSIT_438387#166056)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_MONNAIE_438388#166075)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_MONNAIE_438388#166075)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPEXA_438389#166106)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPEXA_438389#166106)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMBMP_438390#166076)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMBMP_438390#166076)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ORDRE_438391#166078)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ORDRE_438391#166078)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADM_438392#166071)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADM_438392#166071)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ENVADM_438393#166063)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ENVADM_438393#166063)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_T_RED_438394#166109)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_T_RED_438394#166109)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_R_438395#166087)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_R_438395#166087)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FORFAI_438396#166067)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FORFAI_438396#166067)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CLASSE_438397#166054)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CLASSE_438397#166054)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REVERS_438398#166083)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_REVERS_438398#166083)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REMBOURS_438399#166082)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_REMBOURS_438399#166082)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1_438400#166089)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1_438400#166089)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2_438401#166091)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2_438401#166091)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3_438402#166093)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3_438402#166093)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4_438403#166095)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4_438403#166095)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5_438404#166097)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5_438404#166097)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6_438405#166099)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6_438405#166099)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7_438406#166101)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7_438406#166101)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8_438407#166103)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8_438407#166103)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9_438408#166105)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9_438408#166105)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#166088)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#166088)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#166090)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#166090)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#166092)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#166092)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#166094)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#166094)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#166096)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#166096)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#166098)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#166098)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#166100)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#166100)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#166102)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#166102)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#166104)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#166104)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLSEJ_438418#166065)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLSEJ_438418#166065)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLICPT_438419#166064)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLICPT_438419#166064)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEDE_438420#166060)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEDE_438420#166060)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMCPT_438421#166077)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMCPT_438421#166077)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_COMMENT_438422#166059)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_COMMENT_438422#166059)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLTELE_438423#166066)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLTELE_438423#166066)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODCHA_438424#166055)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODCHA_438424#166055)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADS_438425#166072)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADS_438425#166072)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SITES_438426#166084)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_SITES_438426#166084)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_URG_438427#166110)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_URG_438427#166110)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_STD_438428#166070)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_STD_438428#166070)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_SPE_438429#166069)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_SPE_438429#166069)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#166085)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#166085)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_RCP_438431#166081)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_RCP_438431#166081)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEFI_438432#166061)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEFI_438432#166061)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIMAI_438433#166079)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIMAI_438433#166079)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ICD_438434#166068)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ICD_438434#166068)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#166108)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#166108)), A63000893163) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [AL_ANNVAL_438378#166053,AL_CLASSE_438397#166054,AL_CODCHA_438424#166055,AL_CODSIT_438387#166056,AL_CODUTI_438386#166057,AL_CODVAL_438377#166058,AL_COMMENT_438422#166059,AL_DATEDE_438420#166060,AL_DATEFI_438432#166061,AL_DATMAJ_438385#166062,AL_ENVADM_438393#166063,AL_FLICPT_438419#166064,AL_FLSEJ_438418#166065,AL_FLTELE_438423#166066,AL_FORFAI_438396#166067,AL_ICD_438434#166068,AL_INT_SPE_438429#166069,AL_INT_STD_438428#166070,AL_LETADM_438392#166071,AL_LETADS_438425#166072,AL_LIB30_438380#166073,AL_LIBMAJ_438381#166074,AL_MONNAIE_438388#166075,AL_NUMBMP_438390#166076,... 35 more fields] Batched: true, DataFilters: [((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_a..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_VALEU_438376], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<AL_ANNVAL_438378:string,AL_CLASSE_438397:string,AL_CODCHA_438424:string,AL_CODSIT_438387:s...

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 [59]: [AL_ANNVAL_438378#166053, AL_CLASSE_438397#166054, AL_CODCHA_438424#166055, AL_CODSIT_438387#166056, AL_CODUTI_438386#166057, AL_CODVAL_438377#166058, AL_COMMENT_438422#166059, AL_DATEDE_438420#166060, AL_DATEFI_438432#166061, AL_DATMAJ_438385#166062, AL_ENVADM_438393#166063, AL_FLICPT_438419#166064, AL_FLSEJ_438418#166065, AL_FLTELE_438423#166066, AL_FORFAI_438396#166067, AL_ICD_438434#166068, AL_INT_SPE_438429#166069, AL_INT_STD_438428#166070, AL_LETADM_438392#166071, AL_LETADS_438425#166072, AL_LIB30_438380#166073, AL_LIBMAJ_438381#166074, AL_MONNAIE_438388#166075, AL_NUMBMP_438390#166076, AL_NUMCPT_438421#166077, AL_ORDRE_438391#166078, AL_PRIMAI_438433#166079, AL_PRIOR_438383#166080, AL_RCP_438431#166081, AL_REMBOURS_438399#166082, AL_REVERS_438398#166083, AL_SITES_438426#166084, AL_SPL_TRANS_438430#166085, AL_TAUX_438382#166086, AL_TAUX_R_438395#166087, AL_TAUX_T1R_438409#166088, AL_TAUX_T1_438400#166089, AL_TAUX_T2R_438410#166090, AL_TAUX_T2_438401#166091, AL_TAUX_T3R_438411#166092, AL_TAUX_T3_438402#166093, AL_TAUX_T4R_438412#166094, AL_TAUX_T4_438403#166095, AL_TAUX_T5R_438413#166096, AL_TAUX_T5_438404#166097, AL_TAUX_T6R_438414#166098, AL_TAUX_T6_438405#166099, AL_TAUX_T7R_438415#166100, AL_TAUX_T7_438406#166101, AL_TAUX_T8R_438416#166102, AL_TAUX_T8_438407#166103, AL_TAUX_T9R_438417#166104, AL_TAUX_T9_438408#166105, AL_TYPEXA_438389#166106, AL_TYPE_438384#166107, AL_TYPE_ICD_438435#166108, AL_T_RED_438394#166109, AL_URG_438427#166110, AL_VALCOU_438379#166111]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_VALEU_438376]
ReadSchema: struct<AL_ANNVAL_438378:string,AL_CLASSE_438397:string,AL_CODCHA_438424:string,AL_CODSIT_438387:string,AL_CODUTI_438386:string,AL_CODVAL_438377:string,AL_COMMENT_438422:string,AL_DATEDE_438420:string,AL_DATEFI_438432:string,AL_DATMAJ_438385:string,AL_ENVADM_438393:string,AL_FLICPT_438419:string,AL_FLSEJ_438418:string,AL_FLTELE_438423:string,AL_FORFAI_438396:string,AL_ICD_438434:string,AL_INT_SPE_438429:string,AL_INT_STD_438428:string,AL_LETADM_438392:string,AL_LETADS_438425:string,AL_LIB30_438380:string,AL_LIBMAJ_438381:string,AL_MONNAIE_438388:string,AL_NUMBMP_438390:string,AL_NUMCPT_438421:string,AL_ORDRE_438391:string,AL_PRIMAI_438433:string,AL_PRIOR_438383:string,AL_RCP_438431:string,AL_REMBOURS_438399:string,AL_REVERS_438398:string,AL_SITES_438426:string,AL_SPL_TRANS_438430:string,AL_TAUX_438382:string,AL_TAUX_R_438395:string,AL_TAUX_T1R_438409:string,AL_TAUX_T1_438400:string,AL_TAUX_T2R_438410:string,AL_TAUX_T2_438401:string,AL_TAUX_T3R_438411:string,AL_TAUX_T3_438402:string,AL_TAUX_T4R_438412:string,AL_TAUX_T4_438403:string,AL_TAUX_T5R_438413:string,AL_TAUX_T5_438404:string,AL_TAUX_T6R_438414:string,AL_TAUX_T6_438405:string,AL_TAUX_T7R_438415:string,AL_TAUX_T7_438406:string,AL_TAUX_T8R_438416:string,AL_TAUX_T8_438407:string,AL_TAUX_T9R_438417:string,AL_TAUX_T9_438408:string,AL_TYPEXA_438389:string,AL_TYPE_438384:string,AL_TYPE_ICD_438435:string,AL_T_RED_438394:string,AL_URG_438427:string,AL_VALCOU_438379:string>

(2) ColumnarToRow [codegen id : 1]
Input [59]: [AL_ANNVAL_438378#166053, AL_CLASSE_438397#166054, AL_CODCHA_438424#166055, AL_CODSIT_438387#166056, AL_CODUTI_438386#166057, AL_CODVAL_438377#166058, AL_COMMENT_438422#166059, AL_DATEDE_438420#166060, AL_DATEFI_438432#166061, AL_DATMAJ_438385#166062, AL_ENVADM_438393#166063, AL_FLICPT_438419#166064, AL_FLSEJ_438418#166065, AL_FLTELE_438423#166066, AL_FORFAI_438396#166067, AL_ICD_438434#166068, AL_INT_SPE_438429#166069, AL_INT_STD_438428#166070, AL_LETADM_438392#166071, AL_LETADS_438425#166072, AL_LIB30_438380#166073, AL_LIBMAJ_438381#166074, AL_MONNAIE_438388#166075, AL_NUMBMP_438390#166076, AL_NUMCPT_438421#166077, AL_ORDRE_438391#166078, AL_PRIMAI_438433#166079, AL_PRIOR_438383#166080, AL_RCP_438431#166081, AL_REMBOURS_438399#166082, AL_REVERS_438398#166083, AL_SITES_438426#166084, AL_SPL_TRANS_438430#166085, AL_TAUX_438382#166086, AL_TAUX_R_438395#166087, AL_TAUX_T1R_438409#166088, AL_TAUX_T1_438400#166089, AL_TAUX_T2R_438410#166090, AL_TAUX_T2_438401#166091, AL_TAUX_T3R_438411#166092, AL_TAUX_T3_438402#166093, AL_TAUX_T4R_438412#166094, AL_TAUX_T4_438403#166095, AL_TAUX_T5R_438413#166096, AL_TAUX_T5_438404#166097, AL_TAUX_T6R_438414#166098, AL_TAUX_T6_438405#166099, AL_TAUX_T7R_438415#166100, AL_TAUX_T7_438406#166101, AL_TAUX_T8R_438416#166102, AL_TAUX_T8_438407#166103, AL_TAUX_T9R_438417#166104, AL_TAUX_T9_438408#166105, AL_TYPEXA_438389#166106, AL_TYPE_438384#166107, AL_TYPE_ICD_438435#166108, AL_T_RED_438394#166109, AL_URG_438427#166110, AL_VALCOU_438379#166111]

(3) Filter [codegen id : 1]
Input [59]: [AL_ANNVAL_438378#166053, AL_CLASSE_438397#166054, AL_CODCHA_438424#166055, AL_CODSIT_438387#166056, AL_CODUTI_438386#166057, AL_CODVAL_438377#166058, AL_COMMENT_438422#166059, AL_DATEDE_438420#166060, AL_DATEFI_438432#166061, AL_DATMAJ_438385#166062, AL_ENVADM_438393#166063, AL_FLICPT_438419#166064, AL_FLSEJ_438418#166065, AL_FLTELE_438423#166066, AL_FORFAI_438396#166067, AL_ICD_438434#166068, AL_INT_SPE_438429#166069, AL_INT_STD_438428#166070, AL_LETADM_438392#166071, AL_LETADS_438425#166072, AL_LIB30_438380#166073, AL_LIBMAJ_438381#166074, AL_MONNAIE_438388#166075, AL_NUMBMP_438390#166076, AL_NUMCPT_438421#166077, AL_ORDRE_438391#166078, AL_PRIMAI_438433#166079, AL_PRIOR_438383#166080, AL_RCP_438431#166081, AL_REMBOURS_438399#166082, AL_REVERS_438398#166083, AL_SITES_438426#166084, AL_SPL_TRANS_438430#166085, AL_TAUX_438382#166086, AL_TAUX_R_438395#166087, AL_TAUX_T1R_438409#166088, AL_TAUX_T1_438400#166089, AL_TAUX_T2R_438410#166090, AL_TAUX_T2_438401#166091, AL_TAUX_T3R_438411#166092, AL_TAUX_T3_438402#166093, AL_TAUX_T4R_438412#166094, AL_TAUX_T4_438403#166095, AL_TAUX_T5R_438413#166096, AL_TAUX_T5_438404#166097, AL_TAUX_T6R_438414#166098, AL_TAUX_T6_438405#166099, AL_TAUX_T7R_438415#166100, AL_TAUX_T7_438406#166101, AL_TAUX_T8R_438416#166102, AL_TAUX_T8_438407#166103, AL_TAUX_T9R_438417#166104, AL_TAUX_T9_438408#166105, AL_TYPEXA_438389#166106, AL_TYPE_438384#166107, AL_TYPE_ICD_438435#166108, AL_T_RED_438394#166109, AL_URG_438427#166110, AL_VALCOU_438379#166111]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODVAL_438377#166058)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODVAL_438377#166058)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ANNVAL_438378#166053)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ANNVAL_438378#166053)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_VALCOU_438379#166111)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_VALCOU_438379#166111)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIB30_438380#166073)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIB30_438380#166073)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIBMAJ_438381#166074)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIBMAJ_438381#166074)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_438382#166086)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_438382#166086)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIOR_438383#166080)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIOR_438383#166080)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_438384#166107)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_438384#166107)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATMAJ_438385#166062)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATMAJ_438385#166062)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODUTI_438386#166057)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODUTI_438386#166057)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODSIT_438387#166056)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODSIT_438387#166056)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_MONNAIE_438388#166075)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_MONNAIE_438388#166075)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPEXA_438389#166106)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPEXA_438389#166106)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMBMP_438390#166076)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMBMP_438390#166076)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ORDRE_438391#166078)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ORDRE_438391#166078)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADM_438392#166071)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADM_438392#166071)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ENVADM_438393#166063)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ENVADM_438393#166063)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_T_RED_438394#166109)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_T_RED_438394#166109)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_R_438395#166087)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_R_438395#166087)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FORFAI_438396#166067)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FORFAI_438396#166067)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CLASSE_438397#166054)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CLASSE_438397#166054)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REVERS_438398#166083)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_REVERS_438398#166083)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REMBOURS_438399#166082)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_REMBOURS_438399#166082)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1_438400#166089)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1_438400#166089)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2_438401#166091)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2_438401#166091)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3_438402#166093)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3_438402#166093)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4_438403#166095)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4_438403#166095)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5_438404#166097)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5_438404#166097)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6_438405#166099)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6_438405#166099)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7_438406#166101)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7_438406#166101)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8_438407#166103)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8_438407#166103)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9_438408#166105)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9_438408#166105)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#166088)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#166088)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#166090)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#166090)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#166092)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#166092)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#166094)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#166094)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#166096)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#166096)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#166098)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#166098)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#166100)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#166100)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#166102)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#166102)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#166104)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#166104)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLSEJ_438418#166065)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLSEJ_438418#166065)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLICPT_438419#166064)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLICPT_438419#166064)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEDE_438420#166060)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEDE_438420#166060)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMCPT_438421#166077)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMCPT_438421#166077)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_COMMENT_438422#166059)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_COMMENT_438422#166059)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLTELE_438423#166066)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLTELE_438423#166066)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODCHA_438424#166055)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODCHA_438424#166055)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADS_438425#166072)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADS_438425#166072)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SITES_438426#166084)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_SITES_438426#166084)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_URG_438427#166110)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_URG_438427#166110)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_STD_438428#166070)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_STD_438428#166070)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_SPE_438429#166069)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_SPE_438429#166069)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#166085)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#166085)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_RCP_438431#166081)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_RCP_438431#166081)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEFI_438432#166061)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEFI_438432#166061)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIMAI_438433#166079)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIMAI_438433#166079)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ICD_438434#166068)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ICD_438434#166068)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#166108)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#166108)), A63000893163) END)

(4) Project [codegen id : 1]
Output: []
Input [59]: [AL_ANNVAL_438378#166053, AL_CLASSE_438397#166054, AL_CODCHA_438424#166055, AL_CODSIT_438387#166056, AL_CODUTI_438386#166057, AL_CODVAL_438377#166058, AL_COMMENT_438422#166059, AL_DATEDE_438420#166060, AL_DATEFI_438432#166061, AL_DATMAJ_438385#166062, AL_ENVADM_438393#166063, AL_FLICPT_438419#166064, AL_FLSEJ_438418#166065, AL_FLTELE_438423#166066, AL_FORFAI_438396#166067, AL_ICD_438434#166068, AL_INT_SPE_438429#166069, AL_INT_STD_438428#166070, AL_LETADM_438392#166071, AL_LETADS_438425#166072, AL_LIB30_438380#166073, AL_LIBMAJ_438381#166074, AL_MONNAIE_438388#166075, AL_NUMBMP_438390#166076, AL_NUMCPT_438421#166077, AL_ORDRE_438391#166078, AL_PRIMAI_438433#166079, AL_PRIOR_438383#166080, AL_RCP_438431#166081, AL_REMBOURS_438399#166082, AL_REVERS_438398#166083, AL_SITES_438426#166084, AL_SPL_TRANS_438430#166085, AL_TAUX_438382#166086, AL_TAUX_R_438395#166087, AL_TAUX_T1R_438409#166088, AL_TAUX_T1_438400#166089, AL_TAUX_T2R_438410#166090, AL_TAUX_T2_438401#166091, AL_TAUX_T3R_438411#166092, AL_TAUX_T3_438402#166093, AL_TAUX_T4R_438412#166094, AL_TAUX_T4_438403#166095, AL_TAUX_T5R_438413#166096, AL_TAUX_T5_438404#166097, AL_TAUX_T6R_438414#166098, AL_TAUX_T6_438405#166099, AL_TAUX_T7R_438415#166100, AL_TAUX_T7_438406#166101, AL_TAUX_T8R_438416#166102, AL_TAUX_T8_438407#166103, AL_TAUX_T9R_438417#166104, AL_TAUX_T9_438408#166105, AL_TYPEXA_438389#166106, AL_TYPE_438384#166107, AL_TYPE_ICD_438435#166108, AL_T_RED_438394#166109, AL_URG_438427#166110, AL_VALCOU_438379#166111]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#169717L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#168608L]
Results [1]: [count(1)#168608L AS COL_65f0fdb3-3b7f-43ee-a030-89a4cfa11567#168614L]

(9) Filter
Input [59]: [AL_ANNVAL_438378#166053, AL_CLASSE_438397#166054, AL_CODCHA_438424#166055, AL_CODSIT_438387#166056, AL_CODUTI_438386#166057, AL_CODVAL_438377#166058, AL_COMMENT_438422#166059, AL_DATEDE_438420#166060, AL_DATEFI_438432#166061, AL_DATMAJ_438385#166062, AL_ENVADM_438393#166063, AL_FLICPT_438419#166064, AL_FLSEJ_438418#166065, AL_FLTELE_438423#166066, AL_FORFAI_438396#166067, AL_ICD_438434#166068, AL_INT_SPE_438429#166069, AL_INT_STD_438428#166070, AL_LETADM_438392#166071, AL_LETADS_438425#166072, AL_LIB30_438380#166073, AL_LIBMAJ_438381#166074, AL_MONNAIE_438388#166075, AL_NUMBMP_438390#166076, AL_NUMCPT_438421#166077, AL_ORDRE_438391#166078, AL_PRIMAI_438433#166079, AL_PRIOR_438383#166080, AL_RCP_438431#166081, AL_REMBOURS_438399#166082, AL_REVERS_438398#166083, AL_SITES_438426#166084, AL_SPL_TRANS_438430#166085, AL_TAUX_438382#166086, AL_TAUX_R_438395#166087, AL_TAUX_T1R_438409#166088, AL_TAUX_T1_438400#166089, AL_TAUX_T2R_438410#166090, AL_TAUX_T2_438401#166091, AL_TAUX_T3R_438411#166092, AL_TAUX_T3_438402#166093, AL_TAUX_T4R_438412#166094, AL_TAUX_T4_438403#166095, AL_TAUX_T5R_438413#166096, AL_TAUX_T5_438404#166097, AL_TAUX_T6R_438414#166098, AL_TAUX_T6_438405#166099, AL_TAUX_T7R_438415#166100, AL_TAUX_T7_438406#166101, AL_TAUX_T8R_438416#166102, AL_TAUX_T8_438407#166103, AL_TAUX_T9R_438417#166104, AL_TAUX_T9_438408#166105, AL_TYPEXA_438389#166106, AL_TYPE_438384#166107, AL_TYPE_ICD_438435#166108, AL_T_RED_438394#166109, AL_URG_438427#166110, AL_VALCOU_438379#166111]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODVAL_438377#166058)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODVAL_438377#166058)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ANNVAL_438378#166053)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ANNVAL_438378#166053)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_VALCOU_438379#166111)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_VALCOU_438379#166111)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIB30_438380#166073)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIB30_438380#166073)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIBMAJ_438381#166074)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIBMAJ_438381#166074)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_438382#166086)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_438382#166086)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIOR_438383#166080)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIOR_438383#166080)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_438384#166107)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_438384#166107)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATMAJ_438385#166062)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATMAJ_438385#166062)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODUTI_438386#166057)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODUTI_438386#166057)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODSIT_438387#166056)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODSIT_438387#166056)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_MONNAIE_438388#166075)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_MONNAIE_438388#166075)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPEXA_438389#166106)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPEXA_438389#166106)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMBMP_438390#166076)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMBMP_438390#166076)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ORDRE_438391#166078)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ORDRE_438391#166078)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADM_438392#166071)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADM_438392#166071)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ENVADM_438393#166063)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ENVADM_438393#166063)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_T_RED_438394#166109)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_T_RED_438394#166109)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_R_438395#166087)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_R_438395#166087)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FORFAI_438396#166067)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FORFAI_438396#166067)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CLASSE_438397#166054)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CLASSE_438397#166054)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REVERS_438398#166083)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_REVERS_438398#166083)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REMBOURS_438399#166082)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_REMBOURS_438399#166082)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1_438400#166089)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1_438400#166089)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2_438401#166091)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2_438401#166091)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3_438402#166093)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3_438402#166093)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4_438403#166095)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4_438403#166095)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5_438404#166097)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5_438404#166097)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6_438405#166099)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6_438405#166099)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7_438406#166101)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7_438406#166101)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8_438407#166103)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8_438407#166103)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9_438408#166105)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9_438408#166105)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#166088)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#166088)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#166090)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#166090)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#166092)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#166092)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#166094)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#166094)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#166096)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#166096)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#166098)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#166098)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#166100)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#166100)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#166102)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#166102)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#166104)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#166104)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLSEJ_438418#166065)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLSEJ_438418#166065)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLICPT_438419#166064)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLICPT_438419#166064)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEDE_438420#166060)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEDE_438420#166060)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMCPT_438421#166077)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMCPT_438421#166077)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_COMMENT_438422#166059)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_COMMENT_438422#166059)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLTELE_438423#166066)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLTELE_438423#166066)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODCHA_438424#166055)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODCHA_438424#166055)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADS_438425#166072)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADS_438425#166072)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SITES_438426#166084)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_SITES_438426#166084)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_URG_438427#166110)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_URG_438427#166110)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_STD_438428#166070)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_STD_438428#166070)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_SPE_438429#166069)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_SPE_438429#166069)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#166085)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#166085)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_RCP_438431#166081)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_RCP_438431#166081)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEFI_438432#166061)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEFI_438432#166061)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIMAI_438433#166079)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIMAI_438433#166079)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ICD_438434#166068)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_ICD_438434#166068)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#166108)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#166108)), A63000893163) END)

(10) Project
Output: []
Input [59]: [AL_ANNVAL_438378#166053, AL_CLASSE_438397#166054, AL_CODCHA_438424#166055, AL_CODSIT_438387#166056, AL_CODUTI_438386#166057, AL_CODVAL_438377#166058, AL_COMMENT_438422#166059, AL_DATEDE_438420#166060, AL_DATEFI_438432#166061, AL_DATMAJ_438385#166062, AL_ENVADM_438393#166063, AL_FLICPT_438419#166064, AL_FLSEJ_438418#166065, AL_FLTELE_438423#166066, AL_FORFAI_438396#166067, AL_ICD_438434#166068, AL_INT_SPE_438429#166069, AL_INT_STD_438428#166070, AL_LETADM_438392#166071, AL_LETADS_438425#166072, AL_LIB30_438380#166073, AL_LIBMAJ_438381#166074, AL_MONNAIE_438388#166075, AL_NUMBMP_438390#166076, AL_NUMCPT_438421#166077, AL_ORDRE_438391#166078, AL_PRIMAI_438433#166079, AL_PRIOR_438383#166080, AL_RCP_438431#166081, AL_REMBOURS_438399#166082, AL_REVERS_438398#166083, AL_SITES_438426#166084, AL_SPL_TRANS_438430#166085, AL_TAUX_438382#166086, AL_TAUX_R_438395#166087, AL_TAUX_T1R_438409#166088, AL_TAUX_T1_438400#166089, AL_TAUX_T2R_438410#166090, AL_TAUX_T2_438401#166091, AL_TAUX_T3R_438411#166092, AL_TAUX_T3_438402#166093, AL_TAUX_T4R_438412#166094, AL_TAUX_T4_438403#166095, AL_TAUX_T5R_438413#166096, AL_TAUX_T5_438404#166097, AL_TAUX_T6R_438414#166098, AL_TAUX_T6_438405#166099, AL_TAUX_T7R_438415#166100, AL_TAUX_T7_438406#166101, AL_TAUX_T8R_438416#166102, AL_TAUX_T8_438407#166103, AL_TAUX_T9R_438417#166104, AL_TAUX_T9_438408#166105, AL_TYPEXA_438389#166106, AL_TYPE_438384#166107, AL_TYPE_ICD_438435#166108, AL_T_RED_438394#166109, AL_URG_438427#166110, AL_VALCOU_438379#166111]

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

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

(13) HashAggregate
Input [1]: [count#169717L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#168608L]
Results [1]: [count(1)#168608L AS COL_65f0fdb3-3b7f-43ee-a030-89a4cfa11567#168614L]

(14) AdaptiveSparkPlan
Output [1]: [COL_65f0fdb3-3b7f-43ee-a030-89a4cfa11567#168614L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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