hdh-spark-job - Details for Query 630

Submitted Time: 2026/10/21 21:34:13
Duration: 0.4 s
Succeeded Jobs: 578 580

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: 92 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 92 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 9,180"]; 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: 10 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=12520]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODVAL_438377#130978)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODVAL_438377#130978)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ANNVAL_438378#130973)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ANNVAL_438378#130973)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_VALCOU_438379#131031)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_VALCOU_438379#131031)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIB30_438380#130993)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LIB30_438380#130993)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIBMAJ_438381#130994)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LIBMAJ_438381#130994)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_438382#131006)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_438382#131006)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIOR_438383#131000)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIOR_438383#131000)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_438384#131027)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_438384#131027)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATMAJ_438385#130982)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_DATMAJ_438385#130982)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODUTI_438386#130977)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODUTI_438386#130977)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODSIT_438387#130976)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODSIT_438387#130976)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_MONNAIE_438388#130995)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_MONNAIE_438388#130995)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPEXA_438389#131026)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPEXA_438389#131026)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMBMP_438390#130996)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMBMP_438390#130996)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ORDRE_438391#130998)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ORDRE_438391#130998)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADM_438392#130991)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADM_438392#130991)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ENVADM_438393#130983)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ENVADM_438393#130983)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_T_RED_438394#131029)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_T_RED_438394#131029)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_R_438395#131007)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_R_438395#131007)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FORFAI_438396#130987)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FORFAI_438396#130987)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CLASSE_438397#130974)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CLASSE_438397#130974)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REVERS_438398#131003)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_REVERS_438398#131003)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REMBOURS_438399#131002)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_REMBOURS_438399#131002)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1_438400#131009)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1_438400#131009)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2_438401#131011)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2_438401#131011)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3_438402#131013)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3_438402#131013)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4_438403#131015)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4_438403#131015)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5_438404#131017)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5_438404#131017)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6_438405#131019)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6_438405#131019)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7_438406#131021)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7_438406#131021)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8_438407#131023)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8_438407#131023)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9_438408#131025)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9_438408#131025)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#131008)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#131008)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#131010)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#131010)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#131012)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#131012)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#131014)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#131014)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#131016)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#131016)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#131018)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#131018)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#131020)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#131020)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#131022)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#131022)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#131024)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#131024)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLSEJ_438418#130985)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FLSEJ_438418#130985)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLICPT_438419#130984)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FLICPT_438419#130984)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEDE_438420#130980)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEDE_438420#130980)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMCPT_438421#130997)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMCPT_438421#130997)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_COMMENT_438422#130979)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_COMMENT_438422#130979)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLTELE_438423#130986)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FLTELE_438423#130986)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODCHA_438424#130975)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODCHA_438424#130975)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADS_438425#130992)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADS_438425#130992)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SITES_438426#131004)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_SITES_438426#131004)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_URG_438427#131030)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_URG_438427#131030)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_STD_438428#130990)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_STD_438428#130990)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_SPE_438429#130989)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_SPE_438429#130989)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#131005)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#131005)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_RCP_438431#131001)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_RCP_438431#131001)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEFI_438432#130981)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEFI_438432#130981)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIMAI_438433#130999)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIMAI_438433#130999)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ICD_438434#130988)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ICD_438434#130988)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#131028)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#131028)), ) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [AL_ANNVAL_438378#130973,AL_CLASSE_438397#130974,AL_CODCHA_438424#130975,AL_CODSIT_438387#130976,AL_CODUTI_438386#130977,AL_CODVAL_438377#130978,AL_COMMENT_438422#130979,AL_DATEDE_438420#130980,AL_DATEFI_438432#130981,AL_DATMAJ_438385#130982,AL_ENVADM_438393#130983,AL_FLICPT_438419#130984,AL_FLSEJ_438418#130985,AL_FLTELE_438423#130986,AL_FORFAI_438396#130987,AL_ICD_438434#130988,AL_INT_SPE_438429#130989,AL_INT_STD_438428#130990,AL_LETADM_438392#130991,AL_LETADS_438425#130992,AL_LIB30_438380#130993,AL_LIBMAJ_438381#130994,AL_MONNAIE_438388#130995,AL_NUMBMP_438390#130996,... 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#130973, AL_CLASSE_438397#130974, AL_CODCHA_438424#130975, AL_CODSIT_438387#130976, AL_CODUTI_438386#130977, AL_CODVAL_438377#130978, AL_COMMENT_438422#130979, AL_DATEDE_438420#130980, AL_DATEFI_438432#130981, AL_DATMAJ_438385#130982, AL_ENVADM_438393#130983, AL_FLICPT_438419#130984, AL_FLSEJ_438418#130985, AL_FLTELE_438423#130986, AL_FORFAI_438396#130987, AL_ICD_438434#130988, AL_INT_SPE_438429#130989, AL_INT_STD_438428#130990, AL_LETADM_438392#130991, AL_LETADS_438425#130992, AL_LIB30_438380#130993, AL_LIBMAJ_438381#130994, AL_MONNAIE_438388#130995, AL_NUMBMP_438390#130996, AL_NUMCPT_438421#130997, AL_ORDRE_438391#130998, AL_PRIMAI_438433#130999, AL_PRIOR_438383#131000, AL_RCP_438431#131001, AL_REMBOURS_438399#131002, AL_REVERS_438398#131003, AL_SITES_438426#131004, AL_SPL_TRANS_438430#131005, AL_TAUX_438382#131006, AL_TAUX_R_438395#131007, AL_TAUX_T1R_438409#131008, AL_TAUX_T1_438400#131009, AL_TAUX_T2R_438410#131010, AL_TAUX_T2_438401#131011, AL_TAUX_T3R_438411#131012, AL_TAUX_T3_438402#131013, AL_TAUX_T4R_438412#131014, AL_TAUX_T4_438403#131015, AL_TAUX_T5R_438413#131016, AL_TAUX_T5_438404#131017, AL_TAUX_T6R_438414#131018, AL_TAUX_T6_438405#131019, AL_TAUX_T7R_438415#131020, AL_TAUX_T7_438406#131021, AL_TAUX_T8R_438416#131022, AL_TAUX_T8_438407#131023, AL_TAUX_T9R_438417#131024, AL_TAUX_T9_438408#131025, AL_TYPEXA_438389#131026, AL_TYPE_438384#131027, AL_TYPE_ICD_438435#131028, AL_T_RED_438394#131029, AL_URG_438427#131030, AL_VALCOU_438379#131031]
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#130973, AL_CLASSE_438397#130974, AL_CODCHA_438424#130975, AL_CODSIT_438387#130976, AL_CODUTI_438386#130977, AL_CODVAL_438377#130978, AL_COMMENT_438422#130979, AL_DATEDE_438420#130980, AL_DATEFI_438432#130981, AL_DATMAJ_438385#130982, AL_ENVADM_438393#130983, AL_FLICPT_438419#130984, AL_FLSEJ_438418#130985, AL_FLTELE_438423#130986, AL_FORFAI_438396#130987, AL_ICD_438434#130988, AL_INT_SPE_438429#130989, AL_INT_STD_438428#130990, AL_LETADM_438392#130991, AL_LETADS_438425#130992, AL_LIB30_438380#130993, AL_LIBMAJ_438381#130994, AL_MONNAIE_438388#130995, AL_NUMBMP_438390#130996, AL_NUMCPT_438421#130997, AL_ORDRE_438391#130998, AL_PRIMAI_438433#130999, AL_PRIOR_438383#131000, AL_RCP_438431#131001, AL_REMBOURS_438399#131002, AL_REVERS_438398#131003, AL_SITES_438426#131004, AL_SPL_TRANS_438430#131005, AL_TAUX_438382#131006, AL_TAUX_R_438395#131007, AL_TAUX_T1R_438409#131008, AL_TAUX_T1_438400#131009, AL_TAUX_T2R_438410#131010, AL_TAUX_T2_438401#131011, AL_TAUX_T3R_438411#131012, AL_TAUX_T3_438402#131013, AL_TAUX_T4R_438412#131014, AL_TAUX_T4_438403#131015, AL_TAUX_T5R_438413#131016, AL_TAUX_T5_438404#131017, AL_TAUX_T6R_438414#131018, AL_TAUX_T6_438405#131019, AL_TAUX_T7R_438415#131020, AL_TAUX_T7_438406#131021, AL_TAUX_T8R_438416#131022, AL_TAUX_T8_438407#131023, AL_TAUX_T9R_438417#131024, AL_TAUX_T9_438408#131025, AL_TYPEXA_438389#131026, AL_TYPE_438384#131027, AL_TYPE_ICD_438435#131028, AL_T_RED_438394#131029, AL_URG_438427#131030, AL_VALCOU_438379#131031]

(3) Filter [codegen id : 1]
Input [59]: [AL_ANNVAL_438378#130973, AL_CLASSE_438397#130974, AL_CODCHA_438424#130975, AL_CODSIT_438387#130976, AL_CODUTI_438386#130977, AL_CODVAL_438377#130978, AL_COMMENT_438422#130979, AL_DATEDE_438420#130980, AL_DATEFI_438432#130981, AL_DATMAJ_438385#130982, AL_ENVADM_438393#130983, AL_FLICPT_438419#130984, AL_FLSEJ_438418#130985, AL_FLTELE_438423#130986, AL_FORFAI_438396#130987, AL_ICD_438434#130988, AL_INT_SPE_438429#130989, AL_INT_STD_438428#130990, AL_LETADM_438392#130991, AL_LETADS_438425#130992, AL_LIB30_438380#130993, AL_LIBMAJ_438381#130994, AL_MONNAIE_438388#130995, AL_NUMBMP_438390#130996, AL_NUMCPT_438421#130997, AL_ORDRE_438391#130998, AL_PRIMAI_438433#130999, AL_PRIOR_438383#131000, AL_RCP_438431#131001, AL_REMBOURS_438399#131002, AL_REVERS_438398#131003, AL_SITES_438426#131004, AL_SPL_TRANS_438430#131005, AL_TAUX_438382#131006, AL_TAUX_R_438395#131007, AL_TAUX_T1R_438409#131008, AL_TAUX_T1_438400#131009, AL_TAUX_T2R_438410#131010, AL_TAUX_T2_438401#131011, AL_TAUX_T3R_438411#131012, AL_TAUX_T3_438402#131013, AL_TAUX_T4R_438412#131014, AL_TAUX_T4_438403#131015, AL_TAUX_T5R_438413#131016, AL_TAUX_T5_438404#131017, AL_TAUX_T6R_438414#131018, AL_TAUX_T6_438405#131019, AL_TAUX_T7R_438415#131020, AL_TAUX_T7_438406#131021, AL_TAUX_T8R_438416#131022, AL_TAUX_T8_438407#131023, AL_TAUX_T9R_438417#131024, AL_TAUX_T9_438408#131025, AL_TYPEXA_438389#131026, AL_TYPE_438384#131027, AL_TYPE_ICD_438435#131028, AL_T_RED_438394#131029, AL_URG_438427#131030, AL_VALCOU_438379#131031]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODVAL_438377#130978)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODVAL_438377#130978)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ANNVAL_438378#130973)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ANNVAL_438378#130973)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_VALCOU_438379#131031)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_VALCOU_438379#131031)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIB30_438380#130993)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LIB30_438380#130993)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIBMAJ_438381#130994)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LIBMAJ_438381#130994)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_438382#131006)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_438382#131006)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIOR_438383#131000)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIOR_438383#131000)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_438384#131027)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_438384#131027)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATMAJ_438385#130982)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_DATMAJ_438385#130982)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODUTI_438386#130977)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODUTI_438386#130977)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODSIT_438387#130976)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODSIT_438387#130976)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_MONNAIE_438388#130995)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_MONNAIE_438388#130995)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPEXA_438389#131026)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPEXA_438389#131026)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMBMP_438390#130996)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMBMP_438390#130996)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ORDRE_438391#130998)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ORDRE_438391#130998)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADM_438392#130991)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADM_438392#130991)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ENVADM_438393#130983)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ENVADM_438393#130983)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_T_RED_438394#131029)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_T_RED_438394#131029)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_R_438395#131007)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_R_438395#131007)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FORFAI_438396#130987)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FORFAI_438396#130987)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CLASSE_438397#130974)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CLASSE_438397#130974)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REVERS_438398#131003)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_REVERS_438398#131003)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REMBOURS_438399#131002)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_REMBOURS_438399#131002)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1_438400#131009)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1_438400#131009)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2_438401#131011)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2_438401#131011)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3_438402#131013)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3_438402#131013)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4_438403#131015)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4_438403#131015)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5_438404#131017)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5_438404#131017)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6_438405#131019)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6_438405#131019)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7_438406#131021)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7_438406#131021)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8_438407#131023)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8_438407#131023)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9_438408#131025)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9_438408#131025)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#131008)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#131008)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#131010)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#131010)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#131012)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#131012)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#131014)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#131014)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#131016)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#131016)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#131018)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#131018)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#131020)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#131020)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#131022)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#131022)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#131024)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#131024)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLSEJ_438418#130985)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FLSEJ_438418#130985)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLICPT_438419#130984)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FLICPT_438419#130984)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEDE_438420#130980)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEDE_438420#130980)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMCPT_438421#130997)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMCPT_438421#130997)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_COMMENT_438422#130979)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_COMMENT_438422#130979)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLTELE_438423#130986)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FLTELE_438423#130986)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODCHA_438424#130975)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODCHA_438424#130975)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADS_438425#130992)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADS_438425#130992)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SITES_438426#131004)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_SITES_438426#131004)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_URG_438427#131030)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_URG_438427#131030)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_STD_438428#130990)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_STD_438428#130990)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_SPE_438429#130989)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_SPE_438429#130989)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#131005)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#131005)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_RCP_438431#131001)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_RCP_438431#131001)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEFI_438432#130981)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEFI_438432#130981)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIMAI_438433#130999)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIMAI_438433#130999)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ICD_438434#130988)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ICD_438434#130988)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#131028)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#131028)), ) END)

(4) Project [codegen id : 1]
Output: []
Input [59]: [AL_ANNVAL_438378#130973, AL_CLASSE_438397#130974, AL_CODCHA_438424#130975, AL_CODSIT_438387#130976, AL_CODUTI_438386#130977, AL_CODVAL_438377#130978, AL_COMMENT_438422#130979, AL_DATEDE_438420#130980, AL_DATEFI_438432#130981, AL_DATMAJ_438385#130982, AL_ENVADM_438393#130983, AL_FLICPT_438419#130984, AL_FLSEJ_438418#130985, AL_FLTELE_438423#130986, AL_FORFAI_438396#130987, AL_ICD_438434#130988, AL_INT_SPE_438429#130989, AL_INT_STD_438428#130990, AL_LETADM_438392#130991, AL_LETADS_438425#130992, AL_LIB30_438380#130993, AL_LIBMAJ_438381#130994, AL_MONNAIE_438388#130995, AL_NUMBMP_438390#130996, AL_NUMCPT_438421#130997, AL_ORDRE_438391#130998, AL_PRIMAI_438433#130999, AL_PRIOR_438383#131000, AL_RCP_438431#131001, AL_REMBOURS_438399#131002, AL_REVERS_438398#131003, AL_SITES_438426#131004, AL_SPL_TRANS_438430#131005, AL_TAUX_438382#131006, AL_TAUX_R_438395#131007, AL_TAUX_T1R_438409#131008, AL_TAUX_T1_438400#131009, AL_TAUX_T2R_438410#131010, AL_TAUX_T2_438401#131011, AL_TAUX_T3R_438411#131012, AL_TAUX_T3_438402#131013, AL_TAUX_T4R_438412#131014, AL_TAUX_T4_438403#131015, AL_TAUX_T5R_438413#131016, AL_TAUX_T5_438404#131017, AL_TAUX_T6R_438414#131018, AL_TAUX_T6_438405#131019, AL_TAUX_T7R_438415#131020, AL_TAUX_T7_438406#131021, AL_TAUX_T8R_438416#131022, AL_TAUX_T8_438407#131023, AL_TAUX_T9R_438417#131024, AL_TAUX_T9_438408#131025, AL_TYPEXA_438389#131026, AL_TYPE_438384#131027, AL_TYPE_ICD_438435#131028, AL_T_RED_438394#131029, AL_URG_438427#131030, AL_VALCOU_438379#131031]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#132342L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#132228L]
Results [1]: [count(1)#132228L AS COL_350a0ffb-bc9b-46e7-9ab0-7160bafa6952#132230L]

(9) Filter
Input [59]: [AL_ANNVAL_438378#130973, AL_CLASSE_438397#130974, AL_CODCHA_438424#130975, AL_CODSIT_438387#130976, AL_CODUTI_438386#130977, AL_CODVAL_438377#130978, AL_COMMENT_438422#130979, AL_DATEDE_438420#130980, AL_DATEFI_438432#130981, AL_DATMAJ_438385#130982, AL_ENVADM_438393#130983, AL_FLICPT_438419#130984, AL_FLSEJ_438418#130985, AL_FLTELE_438423#130986, AL_FORFAI_438396#130987, AL_ICD_438434#130988, AL_INT_SPE_438429#130989, AL_INT_STD_438428#130990, AL_LETADM_438392#130991, AL_LETADS_438425#130992, AL_LIB30_438380#130993, AL_LIBMAJ_438381#130994, AL_MONNAIE_438388#130995, AL_NUMBMP_438390#130996, AL_NUMCPT_438421#130997, AL_ORDRE_438391#130998, AL_PRIMAI_438433#130999, AL_PRIOR_438383#131000, AL_RCP_438431#131001, AL_REMBOURS_438399#131002, AL_REVERS_438398#131003, AL_SITES_438426#131004, AL_SPL_TRANS_438430#131005, AL_TAUX_438382#131006, AL_TAUX_R_438395#131007, AL_TAUX_T1R_438409#131008, AL_TAUX_T1_438400#131009, AL_TAUX_T2R_438410#131010, AL_TAUX_T2_438401#131011, AL_TAUX_T3R_438411#131012, AL_TAUX_T3_438402#131013, AL_TAUX_T4R_438412#131014, AL_TAUX_T4_438403#131015, AL_TAUX_T5R_438413#131016, AL_TAUX_T5_438404#131017, AL_TAUX_T6R_438414#131018, AL_TAUX_T6_438405#131019, AL_TAUX_T7R_438415#131020, AL_TAUX_T7_438406#131021, AL_TAUX_T8R_438416#131022, AL_TAUX_T8_438407#131023, AL_TAUX_T9R_438417#131024, AL_TAUX_T9_438408#131025, AL_TYPEXA_438389#131026, AL_TYPE_438384#131027, AL_TYPE_ICD_438435#131028, AL_T_RED_438394#131029, AL_URG_438427#131030, AL_VALCOU_438379#131031]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODVAL_438377#130978)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODVAL_438377#130978)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ANNVAL_438378#130973)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ANNVAL_438378#130973)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_VALCOU_438379#131031)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_VALCOU_438379#131031)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIB30_438380#130993)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LIB30_438380#130993)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIBMAJ_438381#130994)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LIBMAJ_438381#130994)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_438382#131006)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_438382#131006)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIOR_438383#131000)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIOR_438383#131000)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_438384#131027)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_438384#131027)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATMAJ_438385#130982)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_DATMAJ_438385#130982)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODUTI_438386#130977)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODUTI_438386#130977)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODSIT_438387#130976)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODSIT_438387#130976)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_MONNAIE_438388#130995)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_MONNAIE_438388#130995)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPEXA_438389#131026)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPEXA_438389#131026)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMBMP_438390#130996)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMBMP_438390#130996)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ORDRE_438391#130998)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ORDRE_438391#130998)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADM_438392#130991)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADM_438392#130991)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ENVADM_438393#130983)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ENVADM_438393#130983)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_T_RED_438394#131029)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_T_RED_438394#131029)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_R_438395#131007)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_R_438395#131007)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FORFAI_438396#130987)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FORFAI_438396#130987)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CLASSE_438397#130974)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CLASSE_438397#130974)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REVERS_438398#131003)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_REVERS_438398#131003)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REMBOURS_438399#131002)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_REMBOURS_438399#131002)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1_438400#131009)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1_438400#131009)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2_438401#131011)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2_438401#131011)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3_438402#131013)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3_438402#131013)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4_438403#131015)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4_438403#131015)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5_438404#131017)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5_438404#131017)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6_438405#131019)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6_438405#131019)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7_438406#131021)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7_438406#131021)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8_438407#131023)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8_438407#131023)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9_438408#131025)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9_438408#131025)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#131008)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#131008)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#131010)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#131010)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#131012)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#131012)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#131014)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#131014)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#131016)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#131016)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#131018)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#131018)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#131020)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#131020)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#131022)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#131022)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#131024)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#131024)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLSEJ_438418#130985)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FLSEJ_438418#130985)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLICPT_438419#130984)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FLICPT_438419#130984)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEDE_438420#130980)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEDE_438420#130980)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMCPT_438421#130997)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMCPT_438421#130997)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_COMMENT_438422#130979)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_COMMENT_438422#130979)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLTELE_438423#130986)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_FLTELE_438423#130986)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODCHA_438424#130975)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_CODCHA_438424#130975)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADS_438425#130992)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADS_438425#130992)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SITES_438426#131004)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_SITES_438426#131004)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_URG_438427#131030)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_URG_438427#131030)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_STD_438428#130990)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_STD_438428#130990)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_SPE_438429#130989)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_SPE_438429#130989)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#131005)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#131005)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_RCP_438431#131001)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_RCP_438431#131001)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEFI_438432#130981)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEFI_438432#130981)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIMAI_438433#130999)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIMAI_438433#130999)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ICD_438434#130988)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_ICD_438434#130988)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#131028)), )) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#131028)), ) END)

(10) Project
Output: []
Input [59]: [AL_ANNVAL_438378#130973, AL_CLASSE_438397#130974, AL_CODCHA_438424#130975, AL_CODSIT_438387#130976, AL_CODUTI_438386#130977, AL_CODVAL_438377#130978, AL_COMMENT_438422#130979, AL_DATEDE_438420#130980, AL_DATEFI_438432#130981, AL_DATMAJ_438385#130982, AL_ENVADM_438393#130983, AL_FLICPT_438419#130984, AL_FLSEJ_438418#130985, AL_FLTELE_438423#130986, AL_FORFAI_438396#130987, AL_ICD_438434#130988, AL_INT_SPE_438429#130989, AL_INT_STD_438428#130990, AL_LETADM_438392#130991, AL_LETADS_438425#130992, AL_LIB30_438380#130993, AL_LIBMAJ_438381#130994, AL_MONNAIE_438388#130995, AL_NUMBMP_438390#130996, AL_NUMCPT_438421#130997, AL_ORDRE_438391#130998, AL_PRIMAI_438433#130999, AL_PRIOR_438383#131000, AL_RCP_438431#131001, AL_REMBOURS_438399#131002, AL_REVERS_438398#131003, AL_SITES_438426#131004, AL_SPL_TRANS_438430#131005, AL_TAUX_438382#131006, AL_TAUX_R_438395#131007, AL_TAUX_T1R_438409#131008, AL_TAUX_T1_438400#131009, AL_TAUX_T2R_438410#131010, AL_TAUX_T2_438401#131011, AL_TAUX_T3R_438411#131012, AL_TAUX_T3_438402#131013, AL_TAUX_T4R_438412#131014, AL_TAUX_T4_438403#131015, AL_TAUX_T5R_438413#131016, AL_TAUX_T5_438404#131017, AL_TAUX_T6R_438414#131018, AL_TAUX_T6_438405#131019, AL_TAUX_T7R_438415#131020, AL_TAUX_T7_438406#131021, AL_TAUX_T8R_438416#131022, AL_TAUX_T8_438407#131023, AL_TAUX_T9R_438417#131024, AL_TAUX_T9_438408#131025, AL_TYPEXA_438389#131026, AL_TYPE_438384#131027, AL_TYPE_ICD_438435#131028, AL_T_RED_438394#131029, AL_URG_438427#131030, AL_VALCOU_438379#131031]

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

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

(13) HashAggregate
Input [1]: [count#132342L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#132228L]
Results [1]: [count(1)#132228L AS COL_350a0ffb-bc9b-46e7-9ab0-7160bafa6952#132230L]

(14) AdaptiveSparkPlan
Output [1]: [COL_350a0ffb-bc9b-46e7-9ab0-7160bafa6952#132230L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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