hdh-spark-job - Details for Query 672

Submitted Time: 2026/10/21 21:34:27
Duration: 1 s
Succeeded Jobs: 637 641

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: 715 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 715 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: 9 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=13583]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODVAL_438377#142802)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODVAL_438377#142802)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ANNVAL_438378#142797)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ANNVAL_438378#142797)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_VALCOU_438379#142855)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_VALCOU_438379#142855)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIB30_438380#142817)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIB30_438380#142817)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIBMAJ_438381#142818)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIBMAJ_438381#142818)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_438382#142830)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_438382#142830)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIOR_438383#142824)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIOR_438383#142824)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_438384#142851)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_438384#142851)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATMAJ_438385#142806)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATMAJ_438385#142806)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODUTI_438386#142801)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODUTI_438386#142801)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODSIT_438387#142800)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODSIT_438387#142800)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_MONNAIE_438388#142819)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_MONNAIE_438388#142819)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPEXA_438389#142850)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPEXA_438389#142850)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMBMP_438390#142820)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMBMP_438390#142820)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ORDRE_438391#142822)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ORDRE_438391#142822)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADM_438392#142815)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADM_438392#142815)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ENVADM_438393#142807)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ENVADM_438393#142807)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_T_RED_438394#142853)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_T_RED_438394#142853)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_R_438395#142831)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_R_438395#142831)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FORFAI_438396#142811)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FORFAI_438396#142811)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CLASSE_438397#142798)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CLASSE_438397#142798)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REVERS_438398#142827)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_REVERS_438398#142827)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REMBOURS_438399#142826)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_REMBOURS_438399#142826)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1_438400#142833)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1_438400#142833)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2_438401#142835)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2_438401#142835)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3_438402#142837)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3_438402#142837)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4_438403#142839)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4_438403#142839)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5_438404#142841)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5_438404#142841)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6_438405#142843)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6_438405#142843)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7_438406#142845)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7_438406#142845)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8_438407#142847)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8_438407#142847)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9_438408#142849)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9_438408#142849)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#142832)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#142832)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#142834)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#142834)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#142836)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#142836)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#142838)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#142838)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#142840)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#142840)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#142842)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#142842)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#142844)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#142844)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#142846)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#142846)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#142848)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#142848)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLSEJ_438418#142809)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLSEJ_438418#142809)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLICPT_438419#142808)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLICPT_438419#142808)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEDE_438420#142804)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEDE_438420#142804)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMCPT_438421#142821)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMCPT_438421#142821)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_COMMENT_438422#142803)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_COMMENT_438422#142803)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLTELE_438423#142810)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLTELE_438423#142810)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODCHA_438424#142799)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODCHA_438424#142799)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADS_438425#142816)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADS_438425#142816)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SITES_438426#142828)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_SITES_438426#142828)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_URG_438427#142854)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_URG_438427#142854)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_STD_438428#142814)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_STD_438428#142814)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_SPE_438429#142813)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_SPE_438429#142813)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#142829)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#142829)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_RCP_438431#142825)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_RCP_438431#142825)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEFI_438432#142805)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEFI_438432#142805)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIMAI_438433#142823)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIMAI_438433#142823)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ICD_438434#142812)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ICD_438434#142812)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#142852)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#142852)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [AL_ANNVAL_438378#142797,AL_CLASSE_438397#142798,AL_CODCHA_438424#142799,AL_CODSIT_438387#142800,AL_CODUTI_438386#142801,AL_CODVAL_438377#142802,AL_COMMENT_438422#142803,AL_DATEDE_438420#142804,AL_DATEFI_438432#142805,AL_DATMAJ_438385#142806,AL_ENVADM_438393#142807,AL_FLICPT_438419#142808,AL_FLSEJ_438418#142809,AL_FLTELE_438423#142810,AL_FORFAI_438396#142811,AL_ICD_438434#142812,AL_INT_SPE_438429#142813,AL_INT_STD_438428#142814,AL_LETADM_438392#142815,AL_LETADS_438425#142816,AL_LIB30_438380#142817,AL_LIBMAJ_438381#142818,AL_MONNAIE_438388#142819,AL_NUMBMP_438390#142820,... 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#142797, AL_CLASSE_438397#142798, AL_CODCHA_438424#142799, AL_CODSIT_438387#142800, AL_CODUTI_438386#142801, AL_CODVAL_438377#142802, AL_COMMENT_438422#142803, AL_DATEDE_438420#142804, AL_DATEFI_438432#142805, AL_DATMAJ_438385#142806, AL_ENVADM_438393#142807, AL_FLICPT_438419#142808, AL_FLSEJ_438418#142809, AL_FLTELE_438423#142810, AL_FORFAI_438396#142811, AL_ICD_438434#142812, AL_INT_SPE_438429#142813, AL_INT_STD_438428#142814, AL_LETADM_438392#142815, AL_LETADS_438425#142816, AL_LIB30_438380#142817, AL_LIBMAJ_438381#142818, AL_MONNAIE_438388#142819, AL_NUMBMP_438390#142820, AL_NUMCPT_438421#142821, AL_ORDRE_438391#142822, AL_PRIMAI_438433#142823, AL_PRIOR_438383#142824, AL_RCP_438431#142825, AL_REMBOURS_438399#142826, AL_REVERS_438398#142827, AL_SITES_438426#142828, AL_SPL_TRANS_438430#142829, AL_TAUX_438382#142830, AL_TAUX_R_438395#142831, AL_TAUX_T1R_438409#142832, AL_TAUX_T1_438400#142833, AL_TAUX_T2R_438410#142834, AL_TAUX_T2_438401#142835, AL_TAUX_T3R_438411#142836, AL_TAUX_T3_438402#142837, AL_TAUX_T4R_438412#142838, AL_TAUX_T4_438403#142839, AL_TAUX_T5R_438413#142840, AL_TAUX_T5_438404#142841, AL_TAUX_T6R_438414#142842, AL_TAUX_T6_438405#142843, AL_TAUX_T7R_438415#142844, AL_TAUX_T7_438406#142845, AL_TAUX_T8R_438416#142846, AL_TAUX_T8_438407#142847, AL_TAUX_T9R_438417#142848, AL_TAUX_T9_438408#142849, AL_TYPEXA_438389#142850, AL_TYPE_438384#142851, AL_TYPE_ICD_438435#142852, AL_T_RED_438394#142853, AL_URG_438427#142854, AL_VALCOU_438379#142855]
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#142797, AL_CLASSE_438397#142798, AL_CODCHA_438424#142799, AL_CODSIT_438387#142800, AL_CODUTI_438386#142801, AL_CODVAL_438377#142802, AL_COMMENT_438422#142803, AL_DATEDE_438420#142804, AL_DATEFI_438432#142805, AL_DATMAJ_438385#142806, AL_ENVADM_438393#142807, AL_FLICPT_438419#142808, AL_FLSEJ_438418#142809, AL_FLTELE_438423#142810, AL_FORFAI_438396#142811, AL_ICD_438434#142812, AL_INT_SPE_438429#142813, AL_INT_STD_438428#142814, AL_LETADM_438392#142815, AL_LETADS_438425#142816, AL_LIB30_438380#142817, AL_LIBMAJ_438381#142818, AL_MONNAIE_438388#142819, AL_NUMBMP_438390#142820, AL_NUMCPT_438421#142821, AL_ORDRE_438391#142822, AL_PRIMAI_438433#142823, AL_PRIOR_438383#142824, AL_RCP_438431#142825, AL_REMBOURS_438399#142826, AL_REVERS_438398#142827, AL_SITES_438426#142828, AL_SPL_TRANS_438430#142829, AL_TAUX_438382#142830, AL_TAUX_R_438395#142831, AL_TAUX_T1R_438409#142832, AL_TAUX_T1_438400#142833, AL_TAUX_T2R_438410#142834, AL_TAUX_T2_438401#142835, AL_TAUX_T3R_438411#142836, AL_TAUX_T3_438402#142837, AL_TAUX_T4R_438412#142838, AL_TAUX_T4_438403#142839, AL_TAUX_T5R_438413#142840, AL_TAUX_T5_438404#142841, AL_TAUX_T6R_438414#142842, AL_TAUX_T6_438405#142843, AL_TAUX_T7R_438415#142844, AL_TAUX_T7_438406#142845, AL_TAUX_T8R_438416#142846, AL_TAUX_T8_438407#142847, AL_TAUX_T9R_438417#142848, AL_TAUX_T9_438408#142849, AL_TYPEXA_438389#142850, AL_TYPE_438384#142851, AL_TYPE_ICD_438435#142852, AL_T_RED_438394#142853, AL_URG_438427#142854, AL_VALCOU_438379#142855]

(3) Filter [codegen id : 1]
Input [59]: [AL_ANNVAL_438378#142797, AL_CLASSE_438397#142798, AL_CODCHA_438424#142799, AL_CODSIT_438387#142800, AL_CODUTI_438386#142801, AL_CODVAL_438377#142802, AL_COMMENT_438422#142803, AL_DATEDE_438420#142804, AL_DATEFI_438432#142805, AL_DATMAJ_438385#142806, AL_ENVADM_438393#142807, AL_FLICPT_438419#142808, AL_FLSEJ_438418#142809, AL_FLTELE_438423#142810, AL_FORFAI_438396#142811, AL_ICD_438434#142812, AL_INT_SPE_438429#142813, AL_INT_STD_438428#142814, AL_LETADM_438392#142815, AL_LETADS_438425#142816, AL_LIB30_438380#142817, AL_LIBMAJ_438381#142818, AL_MONNAIE_438388#142819, AL_NUMBMP_438390#142820, AL_NUMCPT_438421#142821, AL_ORDRE_438391#142822, AL_PRIMAI_438433#142823, AL_PRIOR_438383#142824, AL_RCP_438431#142825, AL_REMBOURS_438399#142826, AL_REVERS_438398#142827, AL_SITES_438426#142828, AL_SPL_TRANS_438430#142829, AL_TAUX_438382#142830, AL_TAUX_R_438395#142831, AL_TAUX_T1R_438409#142832, AL_TAUX_T1_438400#142833, AL_TAUX_T2R_438410#142834, AL_TAUX_T2_438401#142835, AL_TAUX_T3R_438411#142836, AL_TAUX_T3_438402#142837, AL_TAUX_T4R_438412#142838, AL_TAUX_T4_438403#142839, AL_TAUX_T5R_438413#142840, AL_TAUX_T5_438404#142841, AL_TAUX_T6R_438414#142842, AL_TAUX_T6_438405#142843, AL_TAUX_T7R_438415#142844, AL_TAUX_T7_438406#142845, AL_TAUX_T8R_438416#142846, AL_TAUX_T8_438407#142847, AL_TAUX_T9R_438417#142848, AL_TAUX_T9_438408#142849, AL_TYPEXA_438389#142850, AL_TYPE_438384#142851, AL_TYPE_ICD_438435#142852, AL_T_RED_438394#142853, AL_URG_438427#142854, AL_VALCOU_438379#142855]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODVAL_438377#142802)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODVAL_438377#142802)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ANNVAL_438378#142797)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ANNVAL_438378#142797)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_VALCOU_438379#142855)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_VALCOU_438379#142855)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIB30_438380#142817)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIB30_438380#142817)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIBMAJ_438381#142818)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIBMAJ_438381#142818)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_438382#142830)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_438382#142830)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIOR_438383#142824)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIOR_438383#142824)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_438384#142851)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_438384#142851)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATMAJ_438385#142806)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATMAJ_438385#142806)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODUTI_438386#142801)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODUTI_438386#142801)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODSIT_438387#142800)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODSIT_438387#142800)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_MONNAIE_438388#142819)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_MONNAIE_438388#142819)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPEXA_438389#142850)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPEXA_438389#142850)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMBMP_438390#142820)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMBMP_438390#142820)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ORDRE_438391#142822)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ORDRE_438391#142822)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADM_438392#142815)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADM_438392#142815)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ENVADM_438393#142807)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ENVADM_438393#142807)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_T_RED_438394#142853)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_T_RED_438394#142853)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_R_438395#142831)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_R_438395#142831)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FORFAI_438396#142811)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FORFAI_438396#142811)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CLASSE_438397#142798)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CLASSE_438397#142798)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REVERS_438398#142827)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_REVERS_438398#142827)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REMBOURS_438399#142826)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_REMBOURS_438399#142826)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1_438400#142833)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1_438400#142833)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2_438401#142835)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2_438401#142835)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3_438402#142837)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3_438402#142837)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4_438403#142839)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4_438403#142839)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5_438404#142841)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5_438404#142841)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6_438405#142843)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6_438405#142843)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7_438406#142845)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7_438406#142845)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8_438407#142847)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8_438407#142847)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9_438408#142849)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9_438408#142849)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#142832)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#142832)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#142834)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#142834)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#142836)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#142836)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#142838)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#142838)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#142840)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#142840)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#142842)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#142842)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#142844)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#142844)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#142846)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#142846)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#142848)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#142848)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLSEJ_438418#142809)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLSEJ_438418#142809)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLICPT_438419#142808)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLICPT_438419#142808)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEDE_438420#142804)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEDE_438420#142804)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMCPT_438421#142821)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMCPT_438421#142821)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_COMMENT_438422#142803)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_COMMENT_438422#142803)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLTELE_438423#142810)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLTELE_438423#142810)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODCHA_438424#142799)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODCHA_438424#142799)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADS_438425#142816)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADS_438425#142816)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SITES_438426#142828)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_SITES_438426#142828)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_URG_438427#142854)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_URG_438427#142854)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_STD_438428#142814)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_STD_438428#142814)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_SPE_438429#142813)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_SPE_438429#142813)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#142829)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#142829)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_RCP_438431#142825)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_RCP_438431#142825)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEFI_438432#142805)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEFI_438432#142805)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIMAI_438433#142823)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIMAI_438433#142823)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ICD_438434#142812)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ICD_438434#142812)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#142852)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#142852)), MARX) END)

(4) Project [codegen id : 1]
Output: []
Input [59]: [AL_ANNVAL_438378#142797, AL_CLASSE_438397#142798, AL_CODCHA_438424#142799, AL_CODSIT_438387#142800, AL_CODUTI_438386#142801, AL_CODVAL_438377#142802, AL_COMMENT_438422#142803, AL_DATEDE_438420#142804, AL_DATEFI_438432#142805, AL_DATMAJ_438385#142806, AL_ENVADM_438393#142807, AL_FLICPT_438419#142808, AL_FLSEJ_438418#142809, AL_FLTELE_438423#142810, AL_FORFAI_438396#142811, AL_ICD_438434#142812, AL_INT_SPE_438429#142813, AL_INT_STD_438428#142814, AL_LETADM_438392#142815, AL_LETADS_438425#142816, AL_LIB30_438380#142817, AL_LIBMAJ_438381#142818, AL_MONNAIE_438388#142819, AL_NUMBMP_438390#142820, AL_NUMCPT_438421#142821, AL_ORDRE_438391#142822, AL_PRIMAI_438433#142823, AL_PRIOR_438383#142824, AL_RCP_438431#142825, AL_REMBOURS_438399#142826, AL_REVERS_438398#142827, AL_SITES_438426#142828, AL_SPL_TRANS_438430#142829, AL_TAUX_438382#142830, AL_TAUX_R_438395#142831, AL_TAUX_T1R_438409#142832, AL_TAUX_T1_438400#142833, AL_TAUX_T2R_438410#142834, AL_TAUX_T2_438401#142835, AL_TAUX_T3R_438411#142836, AL_TAUX_T3_438402#142837, AL_TAUX_T4R_438412#142838, AL_TAUX_T4_438403#142839, AL_TAUX_T5R_438413#142840, AL_TAUX_T5_438404#142841, AL_TAUX_T6R_438414#142842, AL_TAUX_T6_438405#142843, AL_TAUX_T7R_438415#142844, AL_TAUX_T7_438406#142845, AL_TAUX_T8R_438416#142846, AL_TAUX_T8_438407#142847, AL_TAUX_T9R_438417#142848, AL_TAUX_T9_438408#142849, AL_TYPEXA_438389#142850, AL_TYPE_438384#142851, AL_TYPE_ICD_438435#142852, AL_T_RED_438394#142853, AL_URG_438427#142854, AL_VALCOU_438379#142855]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#144127L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#144052L]
Results [1]: [count(1)#144052L AS COL_9ae9c4c5-116e-45ae-9baf-afef15b277ce#144054L]

(9) Filter
Input [59]: [AL_ANNVAL_438378#142797, AL_CLASSE_438397#142798, AL_CODCHA_438424#142799, AL_CODSIT_438387#142800, AL_CODUTI_438386#142801, AL_CODVAL_438377#142802, AL_COMMENT_438422#142803, AL_DATEDE_438420#142804, AL_DATEFI_438432#142805, AL_DATMAJ_438385#142806, AL_ENVADM_438393#142807, AL_FLICPT_438419#142808, AL_FLSEJ_438418#142809, AL_FLTELE_438423#142810, AL_FORFAI_438396#142811, AL_ICD_438434#142812, AL_INT_SPE_438429#142813, AL_INT_STD_438428#142814, AL_LETADM_438392#142815, AL_LETADS_438425#142816, AL_LIB30_438380#142817, AL_LIBMAJ_438381#142818, AL_MONNAIE_438388#142819, AL_NUMBMP_438390#142820, AL_NUMCPT_438421#142821, AL_ORDRE_438391#142822, AL_PRIMAI_438433#142823, AL_PRIOR_438383#142824, AL_RCP_438431#142825, AL_REMBOURS_438399#142826, AL_REVERS_438398#142827, AL_SITES_438426#142828, AL_SPL_TRANS_438430#142829, AL_TAUX_438382#142830, AL_TAUX_R_438395#142831, AL_TAUX_T1R_438409#142832, AL_TAUX_T1_438400#142833, AL_TAUX_T2R_438410#142834, AL_TAUX_T2_438401#142835, AL_TAUX_T3R_438411#142836, AL_TAUX_T3_438402#142837, AL_TAUX_T4R_438412#142838, AL_TAUX_T4_438403#142839, AL_TAUX_T5R_438413#142840, AL_TAUX_T5_438404#142841, AL_TAUX_T6R_438414#142842, AL_TAUX_T6_438405#142843, AL_TAUX_T7R_438415#142844, AL_TAUX_T7_438406#142845, AL_TAUX_T8R_438416#142846, AL_TAUX_T8_438407#142847, AL_TAUX_T9R_438417#142848, AL_TAUX_T9_438408#142849, AL_TYPEXA_438389#142850, AL_TYPE_438384#142851, AL_TYPE_ICD_438435#142852, AL_T_RED_438394#142853, AL_URG_438427#142854, AL_VALCOU_438379#142855]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODVAL_438377#142802)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODVAL_438377#142802)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ANNVAL_438378#142797)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ANNVAL_438378#142797)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_VALCOU_438379#142855)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_VALCOU_438379#142855)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIB30_438380#142817)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIB30_438380#142817)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LIBMAJ_438381#142818)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LIBMAJ_438381#142818)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_438382#142830)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_438382#142830)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIOR_438383#142824)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIOR_438383#142824)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_438384#142851)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_438384#142851)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATMAJ_438385#142806)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATMAJ_438385#142806)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODUTI_438386#142801)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODUTI_438386#142801)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODSIT_438387#142800)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODSIT_438387#142800)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_MONNAIE_438388#142819)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_MONNAIE_438388#142819)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPEXA_438389#142850)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPEXA_438389#142850)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMBMP_438390#142820)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMBMP_438390#142820)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ORDRE_438391#142822)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ORDRE_438391#142822)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADM_438392#142815)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADM_438392#142815)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ENVADM_438393#142807)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ENVADM_438393#142807)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_T_RED_438394#142853)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_T_RED_438394#142853)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_R_438395#142831)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_R_438395#142831)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FORFAI_438396#142811)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FORFAI_438396#142811)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CLASSE_438397#142798)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CLASSE_438397#142798)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REVERS_438398#142827)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_REVERS_438398#142827)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_REMBOURS_438399#142826)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_REMBOURS_438399#142826)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1_438400#142833)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1_438400#142833)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2_438401#142835)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2_438401#142835)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3_438402#142837)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3_438402#142837)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4_438403#142839)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4_438403#142839)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5_438404#142841)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5_438404#142841)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6_438405#142843)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6_438405#142843)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7_438406#142845)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7_438406#142845)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8_438407#142847)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8_438407#142847)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9_438408#142849)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9_438408#142849)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#142832)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T1R_438409#142832)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#142834)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T2R_438410#142834)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#142836)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T3R_438411#142836)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#142838)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T4R_438412#142838)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#142840)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T5R_438413#142840)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#142842)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T6R_438414#142842)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#142844)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T7R_438415#142844)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#142846)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T8R_438416#142846)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#142848)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TAUX_T9R_438417#142848)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLSEJ_438418#142809)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLSEJ_438418#142809)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLICPT_438419#142808)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLICPT_438419#142808)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEDE_438420#142804)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEDE_438420#142804)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_NUMCPT_438421#142821)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_NUMCPT_438421#142821)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_COMMENT_438422#142803)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_COMMENT_438422#142803)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_FLTELE_438423#142810)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_FLTELE_438423#142810)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_CODCHA_438424#142799)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_CODCHA_438424#142799)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_LETADS_438425#142816)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_LETADS_438425#142816)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SITES_438426#142828)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_SITES_438426#142828)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_URG_438427#142854)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_URG_438427#142854)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_STD_438428#142814)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_STD_438428#142814)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_INT_SPE_438429#142813)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_INT_SPE_438429#142813)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#142829)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_SPL_TRANS_438430#142829)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_RCP_438431#142825)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_RCP_438431#142825)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_DATEFI_438432#142805)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_DATEFI_438432#142805)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_PRIMAI_438433#142823)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_PRIMAI_438433#142823)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_ICD_438434#142812)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_ICD_438434#142812)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#142852)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AL_TYPE_ICD_438435#142852)), MARX) END)

(10) Project
Output: []
Input [59]: [AL_ANNVAL_438378#142797, AL_CLASSE_438397#142798, AL_CODCHA_438424#142799, AL_CODSIT_438387#142800, AL_CODUTI_438386#142801, AL_CODVAL_438377#142802, AL_COMMENT_438422#142803, AL_DATEDE_438420#142804, AL_DATEFI_438432#142805, AL_DATMAJ_438385#142806, AL_ENVADM_438393#142807, AL_FLICPT_438419#142808, AL_FLSEJ_438418#142809, AL_FLTELE_438423#142810, AL_FORFAI_438396#142811, AL_ICD_438434#142812, AL_INT_SPE_438429#142813, AL_INT_STD_438428#142814, AL_LETADM_438392#142815, AL_LETADS_438425#142816, AL_LIB30_438380#142817, AL_LIBMAJ_438381#142818, AL_MONNAIE_438388#142819, AL_NUMBMP_438390#142820, AL_NUMCPT_438421#142821, AL_ORDRE_438391#142822, AL_PRIMAI_438433#142823, AL_PRIOR_438383#142824, AL_RCP_438431#142825, AL_REMBOURS_438399#142826, AL_REVERS_438398#142827, AL_SITES_438426#142828, AL_SPL_TRANS_438430#142829, AL_TAUX_438382#142830, AL_TAUX_R_438395#142831, AL_TAUX_T1R_438409#142832, AL_TAUX_T1_438400#142833, AL_TAUX_T2R_438410#142834, AL_TAUX_T2_438401#142835, AL_TAUX_T3R_438411#142836, AL_TAUX_T3_438402#142837, AL_TAUX_T4R_438412#142838, AL_TAUX_T4_438403#142839, AL_TAUX_T5R_438413#142840, AL_TAUX_T5_438404#142841, AL_TAUX_T6R_438414#142842, AL_TAUX_T6_438405#142843, AL_TAUX_T7R_438415#142844, AL_TAUX_T7_438406#142845, AL_TAUX_T8R_438416#142846, AL_TAUX_T8_438407#142847, AL_TAUX_T9R_438417#142848, AL_TAUX_T9_438408#142849, AL_TYPEXA_438389#142850, AL_TYPE_438384#142851, AL_TYPE_ICD_438435#142852, AL_T_RED_438394#142853, AL_URG_438427#142854, AL_VALCOU_438379#142855]

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

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

(13) HashAggregate
Input [1]: [count#144127L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#144052L]
Results [1]: [count(1)#144052L AS COL_9ae9c4c5-116e-45ae-9baf-afef15b277ce#144054L]

(14) AdaptiveSparkPlan
Output [1]: [COL_9ae9c4c5-116e-45ae-9baf-afef15b277ce#144054L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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