hdh-spark-job - Details for Query 652

Submitted Time: 2026/10/21 21:34:16
Duration: 1 s
Succeeded Jobs: 607 609

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: 600 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 600 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 50,890"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 50,890 number of input batches: 13"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 26 ms metadata time: 0 ms size of files read: 1605.3 KiB number of output rows: 50,890"]; 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=13118]

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

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#136277)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#136277)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#136279)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#136279)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#136280)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#136280)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#136284)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#136284)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#136290)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#136290)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#136221)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#136221)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#136228)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#136228)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#136227)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#136227)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#136294)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#136294)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#136259)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#136259)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#136240)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#136240)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#136225)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#136225)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#136289)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#136289)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#136241)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#136241)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#136233)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#136233)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#136235)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#136235)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#136292)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#136292)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#136224)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#136224)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#136285)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#136285)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#136275)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#136275)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#136242)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#136242)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#136255)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#136255)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#136256)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#136256)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#136246)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#136246)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#136264)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#136264)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#136295)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#136295)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#136281)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#136281)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#136303)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#136303)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#136243)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#136243)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#136236)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#136236)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#136239)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#136239)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#136252)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#136252)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#136276)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#136276)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#136263)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#136263)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#136248)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#136248)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#136262)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#136262)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#136249)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#136249)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#136302)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#136302)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#136222)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#136222)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#136223)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#136223)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#136296)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#136296)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#136287)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#136287)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#136251)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#136251)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#136267)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#136267)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#136297)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#136297)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#136217)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#136217)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#136270)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#136270)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#136300)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#136300)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#136220)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#136220)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#136272)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#136272)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#136268)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#136268)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#136298)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#136298)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#136218)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#136218)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#136269)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#136269)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#136299)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#136299)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#136219)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#136219)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#136301)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#136301)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#136288)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#136288)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#136273)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#136273)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#136274)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#136274)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#136283)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#136283)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#136260)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#136260)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#136250)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#136250)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#136234)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#136234)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#136261)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#136261)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#136247)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#136247)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#136293)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#136293)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#136291)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#136291)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#136244)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#136244)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#136216)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#136216)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#136230)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#136230)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#136229)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#136229)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#136286)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#136286)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#136245)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#136245)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#136253)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#136253)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#136254)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#136254)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#136278)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#136278)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#136238)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#136238)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#136265)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#136265)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#136266)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#136266)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#136271)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#136271)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#136231)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#136231)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#136258)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#136258)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#136257)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#136257)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#136282)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#136282)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#136226)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#136226)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#136232)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#136232)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#136237)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#136237)), ) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [OT_AMCID_437304#136216,OT_AMOID_437280#136217,OT_AMOIKM_437287#136218,OT_AMOIKS_437290#136219,OT_AMOIK_437283#136220,OT_ANNVAL_437240#136221,OT_AVISEXO_437273#136222,OT_BASRMB_437274#136223,OT_CDAM_437252#136224,OT_COCAL_437246#136225,OT_CODAPP_437320#136226,OT_CODBAS_437242#136227,OT_CODCHA_437241#136228,OT_CODITM_437306#136229,OT_CODLIS_437305#136230,OT_CODPER2_437316#136231,OT_CODPER3_437321#136232,OT_CODPER_437249#136233,OT_CODPRE_437298#136234,OT_CODSER_437250#136235,OT_CODSIT_437264#136236,OT_CODTIT_437322#136237,OT_CODUAM_437312#136238,OT_CODUTI_437265#136239,... 64 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_COTDET_437234], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<OT_AMCID_437304:string,OT_AMOID_437280:string,OT_AMOIKM_437287:string,OT_AMOIKS_437290:str...

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 [88]: [OT_AMCID_437304#136216, OT_AMOID_437280#136217, OT_AMOIKM_437287#136218, OT_AMOIKS_437290#136219, OT_AMOIK_437283#136220, OT_ANNVAL_437240#136221, OT_AVISEXO_437273#136222, OT_BASRMB_437274#136223, OT_CDAM_437252#136224, OT_COCAL_437246#136225, OT_CODAPP_437320#136226, OT_CODBAS_437242#136227, OT_CODCHA_437241#136228, OT_CODITM_437306#136229, OT_CODLIS_437305#136230, OT_CODPER2_437316#136231, OT_CODPER3_437321#136232, OT_CODPER_437249#136233, OT_CODPRE_437298#136234, OT_CODSER_437250#136235, OT_CODSIT_437264#136236, OT_CODTIT_437322#136237, OT_CODUAM_437312#136238, OT_CODUTI_437265#136239, OT_COEFF_437245#136240, OT_COMPAR_437248#136241, OT_CR_437255#136242, OT_DATMAJ_437263#136243, OT_DENOMB_437303#136244, OT_DEPMNT_437308#136245, OT_FACTUR_437258#136246, OT_FAITLIT_437300#136247, OT_FERIE_437269#136248, OT_FLALD_437271#136249, OT_FLDIVISE_437297#136250, OT_FLID_437277#136251, OT_FLRMO_437266#136252, OT_FORC_437309#136253, OT_FORMAMC_437310#136254, OT_INDBAS_437256#136255, OT_INFTRA_437257#136256, OT_LATER_437318#136257, OT_LETADS_437317#136258, OT_LETTRE_437244#136259, OT_LIGRGR_437296#136260, OT_MAJOAGE_437299#136261, OT_MAJOFERIE_437270#136262, OT_MAJONUIT_437268#136263, OT_MONNAIE_437259#136264, OT_MTDEP_437313#136265, OT_MTPENHPS_437314#136266, OT_MTTID_437278#136267, OT_MTTIKM_437285#136268, OT_MTTIKS_437288#136269, OT_MTTIK_437281#136270, OT_MTTORI_437315#136271, OT_NBRIKM_437284#136272, OT_NBRIKS_437293#136273, OT_NBRIK_437294#136274, OT_NOMDOS_437254#136275, OT_NUIT_437267#136276, OT_NUMCOT_437235#136277, OT_NUMCOT_CCAM_437311#136278, OT_NUMDEM_437236#136279, OT_NUMDOS_437237#136280, OT_NUMERO_437261#136281, OT_NUMEXA_437319#136282, OT_NUMORD_437295#136283, OT_NUMPCO_437238#136284, OT_NUMSAL_437253#136285, OT_NUMTLI_437307#136286, OT_PARCAI_437276#136287, OT_PARMUT_437292#136288, OT_PLATRE_437247#136289, OT_PRIMAI_437239#136290, OT_PRIUNI_437302#136291, OT_QTEBAS_437251#136292, OT_QUALDP_437301#136293, OT_RATTAC_437243#136294, OT_TARIF_437260#136295, OT_TAUCAI_437275#136296, OT_TAUID_437279#136297, OT_TAUIKM_437286#136298, OT_TAUIKS_437289#136299, OT_TAUIK_437282#136300, OT_TAUMUT_437291#136301, OT_TYPEXO_437272#136302, OT_T_RED_437262#136303]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_COTDET_437234]
ReadSchema: struct<OT_AMCID_437304:string,OT_AMOID_437280:string,OT_AMOIKM_437287:string,OT_AMOIKS_437290:string,OT_AMOIK_437283:string,OT_ANNVAL_437240:string,OT_AVISEXO_437273:string,OT_BASRMB_437274:string,OT_CDAM_437252:string,OT_COCAL_437246:string,OT_CODAPP_437320:string,OT_CODBAS_437242:string,OT_CODCHA_437241:string,OT_CODITM_437306:string,OT_CODLIS_437305:string,OT_CODPER2_437316:string,OT_CODPER3_437321:string,OT_CODPER_437249:string,OT_CODPRE_437298:string,OT_CODSER_437250:string,OT_CODSIT_437264:string,OT_CODTIT_437322:string,OT_CODUAM_437312:string,OT_CODUTI_437265:string,OT_COEFF_437245:string,OT_COMPAR_437248:string,OT_CR_437255:string,OT_DATMAJ_437263:string,OT_DENOMB_437303:string,OT_DEPMNT_437308:string,OT_FACTUR_437258:string,OT_FAITLIT_437300:string,OT_FERIE_437269:string,OT_FLALD_437271:string,OT_FLDIVISE_437297:string,OT_FLID_437277:string,OT_FLRMO_437266:string,OT_FORC_437309:string,OT_FORMAMC_437310:string,OT_INDBAS_437256:string,OT_INFTRA_437257:string,OT_LATER_437318:string,OT_LETADS_437317:string,OT_LETTRE_437244:string,OT_LIGRGR_437296:string,OT_MAJOAGE_437299:string,OT_MAJOFERIE_437270:string,OT_MAJONUIT_437268:string,OT_MONNAIE_437259:string,OT_MTDEP_437313:string,OT_MTPENHPS_437314:string,OT_MTTID_437278:string,OT_MTTIKM_437285:string,OT_MTTIKS_437288:string,OT_MTTIK_437281:string,OT_MTTORI_437315:string,OT_NBRIKM_437284:string,OT_NBRIKS_437293:string,OT_NBRIK_437294:string,OT_NOMDOS_437254:string,OT_NUIT_437267:string,OT_NUMCOT_437235:string,OT_NUMCOT_CCAM_437311:string,OT_NUMDEM_437236:string,OT_NUMDOS_437237:string,OT_NUMERO_437261:string,OT_NUMEXA_437319:string,OT_NUMORD_437295:string,OT_NUMPCO_437238:string,OT_NUMSAL_437253:string,OT_NUMTLI_437307:string,OT_PARCAI_437276:string,OT_PARMUT_437292:string,OT_PLATRE_437247:string,OT_PRIMAI_437239:string,OT_PRIUNI_437302:string,OT_QTEBAS_437251:string,OT_QUALDP_437301:string,OT_RATTAC_437243:string,OT_TARIF_437260:string,OT_TAUCAI_437275:string,OT_TAUID_437279:string,OT_TAUIKM_437286:string,OT_TAUIKS_437289:string,OT_TAUIK_437282:string,OT_TAUMUT_437291:string,OT_TYPEXO_437272:string,OT_T_RED_437262:string>

(2) ColumnarToRow [codegen id : 1]
Input [88]: [OT_AMCID_437304#136216, OT_AMOID_437280#136217, OT_AMOIKM_437287#136218, OT_AMOIKS_437290#136219, OT_AMOIK_437283#136220, OT_ANNVAL_437240#136221, OT_AVISEXO_437273#136222, OT_BASRMB_437274#136223, OT_CDAM_437252#136224, OT_COCAL_437246#136225, OT_CODAPP_437320#136226, OT_CODBAS_437242#136227, OT_CODCHA_437241#136228, OT_CODITM_437306#136229, OT_CODLIS_437305#136230, OT_CODPER2_437316#136231, OT_CODPER3_437321#136232, OT_CODPER_437249#136233, OT_CODPRE_437298#136234, OT_CODSER_437250#136235, OT_CODSIT_437264#136236, OT_CODTIT_437322#136237, OT_CODUAM_437312#136238, OT_CODUTI_437265#136239, OT_COEFF_437245#136240, OT_COMPAR_437248#136241, OT_CR_437255#136242, OT_DATMAJ_437263#136243, OT_DENOMB_437303#136244, OT_DEPMNT_437308#136245, OT_FACTUR_437258#136246, OT_FAITLIT_437300#136247, OT_FERIE_437269#136248, OT_FLALD_437271#136249, OT_FLDIVISE_437297#136250, OT_FLID_437277#136251, OT_FLRMO_437266#136252, OT_FORC_437309#136253, OT_FORMAMC_437310#136254, OT_INDBAS_437256#136255, OT_INFTRA_437257#136256, OT_LATER_437318#136257, OT_LETADS_437317#136258, OT_LETTRE_437244#136259, OT_LIGRGR_437296#136260, OT_MAJOAGE_437299#136261, OT_MAJOFERIE_437270#136262, OT_MAJONUIT_437268#136263, OT_MONNAIE_437259#136264, OT_MTDEP_437313#136265, OT_MTPENHPS_437314#136266, OT_MTTID_437278#136267, OT_MTTIKM_437285#136268, OT_MTTIKS_437288#136269, OT_MTTIK_437281#136270, OT_MTTORI_437315#136271, OT_NBRIKM_437284#136272, OT_NBRIKS_437293#136273, OT_NBRIK_437294#136274, OT_NOMDOS_437254#136275, OT_NUIT_437267#136276, OT_NUMCOT_437235#136277, OT_NUMCOT_CCAM_437311#136278, OT_NUMDEM_437236#136279, OT_NUMDOS_437237#136280, OT_NUMERO_437261#136281, OT_NUMEXA_437319#136282, OT_NUMORD_437295#136283, OT_NUMPCO_437238#136284, OT_NUMSAL_437253#136285, OT_NUMTLI_437307#136286, OT_PARCAI_437276#136287, OT_PARMUT_437292#136288, OT_PLATRE_437247#136289, OT_PRIMAI_437239#136290, OT_PRIUNI_437302#136291, OT_QTEBAS_437251#136292, OT_QUALDP_437301#136293, OT_RATTAC_437243#136294, OT_TARIF_437260#136295, OT_TAUCAI_437275#136296, OT_TAUID_437279#136297, OT_TAUIKM_437286#136298, OT_TAUIKS_437289#136299, OT_TAUIK_437282#136300, OT_TAUMUT_437291#136301, OT_TYPEXO_437272#136302, OT_T_RED_437262#136303]

(3) Filter [codegen id : 1]
Input [88]: [OT_AMCID_437304#136216, OT_AMOID_437280#136217, OT_AMOIKM_437287#136218, OT_AMOIKS_437290#136219, OT_AMOIK_437283#136220, OT_ANNVAL_437240#136221, OT_AVISEXO_437273#136222, OT_BASRMB_437274#136223, OT_CDAM_437252#136224, OT_COCAL_437246#136225, OT_CODAPP_437320#136226, OT_CODBAS_437242#136227, OT_CODCHA_437241#136228, OT_CODITM_437306#136229, OT_CODLIS_437305#136230, OT_CODPER2_437316#136231, OT_CODPER3_437321#136232, OT_CODPER_437249#136233, OT_CODPRE_437298#136234, OT_CODSER_437250#136235, OT_CODSIT_437264#136236, OT_CODTIT_437322#136237, OT_CODUAM_437312#136238, OT_CODUTI_437265#136239, OT_COEFF_437245#136240, OT_COMPAR_437248#136241, OT_CR_437255#136242, OT_DATMAJ_437263#136243, OT_DENOMB_437303#136244, OT_DEPMNT_437308#136245, OT_FACTUR_437258#136246, OT_FAITLIT_437300#136247, OT_FERIE_437269#136248, OT_FLALD_437271#136249, OT_FLDIVISE_437297#136250, OT_FLID_437277#136251, OT_FLRMO_437266#136252, OT_FORC_437309#136253, OT_FORMAMC_437310#136254, OT_INDBAS_437256#136255, OT_INFTRA_437257#136256, OT_LATER_437318#136257, OT_LETADS_437317#136258, OT_LETTRE_437244#136259, OT_LIGRGR_437296#136260, OT_MAJOAGE_437299#136261, OT_MAJOFERIE_437270#136262, OT_MAJONUIT_437268#136263, OT_MONNAIE_437259#136264, OT_MTDEP_437313#136265, OT_MTPENHPS_437314#136266, OT_MTTID_437278#136267, OT_MTTIKM_437285#136268, OT_MTTIKS_437288#136269, OT_MTTIK_437281#136270, OT_MTTORI_437315#136271, OT_NBRIKM_437284#136272, OT_NBRIKS_437293#136273, OT_NBRIK_437294#136274, OT_NOMDOS_437254#136275, OT_NUIT_437267#136276, OT_NUMCOT_437235#136277, OT_NUMCOT_CCAM_437311#136278, OT_NUMDEM_437236#136279, OT_NUMDOS_437237#136280, OT_NUMERO_437261#136281, OT_NUMEXA_437319#136282, OT_NUMORD_437295#136283, OT_NUMPCO_437238#136284, OT_NUMSAL_437253#136285, OT_NUMTLI_437307#136286, OT_PARCAI_437276#136287, OT_PARMUT_437292#136288, OT_PLATRE_437247#136289, OT_PRIMAI_437239#136290, OT_PRIUNI_437302#136291, OT_QTEBAS_437251#136292, OT_QUALDP_437301#136293, OT_RATTAC_437243#136294, OT_TARIF_437260#136295, OT_TAUCAI_437275#136296, OT_TAUID_437279#136297, OT_TAUIKM_437286#136298, OT_TAUIKS_437289#136299, OT_TAUIK_437282#136300, OT_TAUMUT_437291#136301, OT_TYPEXO_437272#136302, OT_T_RED_437262#136303]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#136277)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#136277)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#136279)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#136279)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#136280)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#136280)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#136284)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#136284)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#136290)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#136290)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#136221)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#136221)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#136228)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#136228)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#136227)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#136227)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#136294)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#136294)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#136259)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#136259)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#136240)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#136240)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#136225)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#136225)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#136289)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#136289)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#136241)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#136241)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#136233)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#136233)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#136235)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#136235)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#136292)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#136292)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#136224)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#136224)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#136285)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#136285)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#136275)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#136275)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#136242)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#136242)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#136255)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#136255)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#136256)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#136256)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#136246)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#136246)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#136264)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#136264)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#136295)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#136295)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#136281)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#136281)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#136303)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#136303)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#136243)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#136243)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#136236)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#136236)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#136239)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#136239)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#136252)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#136252)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#136276)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#136276)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#136263)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#136263)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#136248)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#136248)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#136262)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#136262)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#136249)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#136249)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#136302)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#136302)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#136222)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#136222)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#136223)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#136223)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#136296)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#136296)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#136287)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#136287)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#136251)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#136251)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#136267)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#136267)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#136297)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#136297)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#136217)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#136217)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#136270)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#136270)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#136300)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#136300)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#136220)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#136220)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#136272)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#136272)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#136268)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#136268)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#136298)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#136298)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#136218)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#136218)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#136269)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#136269)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#136299)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#136299)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#136219)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#136219)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#136301)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#136301)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#136288)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#136288)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#136273)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#136273)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#136274)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#136274)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#136283)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#136283)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#136260)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#136260)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#136250)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#136250)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#136234)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#136234)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#136261)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#136261)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#136247)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#136247)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#136293)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#136293)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#136291)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#136291)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#136244)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#136244)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#136216)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#136216)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#136230)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#136230)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#136229)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#136229)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#136286)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#136286)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#136245)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#136245)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#136253)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#136253)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#136254)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#136254)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#136278)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#136278)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#136238)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#136238)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#136265)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#136265)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#136266)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#136266)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#136271)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#136271)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#136231)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#136231)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#136258)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#136258)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#136257)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#136257)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#136282)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#136282)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#136226)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#136226)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#136232)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#136232)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#136237)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#136237)), ) END)

(4) Project [codegen id : 1]
Output: []
Input [88]: [OT_AMCID_437304#136216, OT_AMOID_437280#136217, OT_AMOIKM_437287#136218, OT_AMOIKS_437290#136219, OT_AMOIK_437283#136220, OT_ANNVAL_437240#136221, OT_AVISEXO_437273#136222, OT_BASRMB_437274#136223, OT_CDAM_437252#136224, OT_COCAL_437246#136225, OT_CODAPP_437320#136226, OT_CODBAS_437242#136227, OT_CODCHA_437241#136228, OT_CODITM_437306#136229, OT_CODLIS_437305#136230, OT_CODPER2_437316#136231, OT_CODPER3_437321#136232, OT_CODPER_437249#136233, OT_CODPRE_437298#136234, OT_CODSER_437250#136235, OT_CODSIT_437264#136236, OT_CODTIT_437322#136237, OT_CODUAM_437312#136238, OT_CODUTI_437265#136239, OT_COEFF_437245#136240, OT_COMPAR_437248#136241, OT_CR_437255#136242, OT_DATMAJ_437263#136243, OT_DENOMB_437303#136244, OT_DEPMNT_437308#136245, OT_FACTUR_437258#136246, OT_FAITLIT_437300#136247, OT_FERIE_437269#136248, OT_FLALD_437271#136249, OT_FLDIVISE_437297#136250, OT_FLID_437277#136251, OT_FLRMO_437266#136252, OT_FORC_437309#136253, OT_FORMAMC_437310#136254, OT_INDBAS_437256#136255, OT_INFTRA_437257#136256, OT_LATER_437318#136257, OT_LETADS_437317#136258, OT_LETTRE_437244#136259, OT_LIGRGR_437296#136260, OT_MAJOAGE_437299#136261, OT_MAJOFERIE_437270#136262, OT_MAJONUIT_437268#136263, OT_MONNAIE_437259#136264, OT_MTDEP_437313#136265, OT_MTPENHPS_437314#136266, OT_MTTID_437278#136267, OT_MTTIKM_437285#136268, OT_MTTIKS_437288#136269, OT_MTTIK_437281#136270, OT_MTTORI_437315#136271, OT_NBRIKM_437284#136272, OT_NBRIKS_437293#136273, OT_NBRIK_437294#136274, OT_NOMDOS_437254#136275, OT_NUIT_437267#136276, OT_NUMCOT_437235#136277, OT_NUMCOT_CCAM_437311#136278, OT_NUMDEM_437236#136279, OT_NUMDOS_437237#136280, OT_NUMERO_437261#136281, OT_NUMEXA_437319#136282, OT_NUMORD_437295#136283, OT_NUMPCO_437238#136284, OT_NUMSAL_437253#136285, OT_NUMTLI_437307#136286, OT_PARCAI_437276#136287, OT_PARMUT_437292#136288, OT_PLATRE_437247#136289, OT_PRIMAI_437239#136290, OT_PRIUNI_437302#136291, OT_QTEBAS_437251#136292, OT_QUALDP_437301#136293, OT_RATTAC_437243#136294, OT_TARIF_437260#136295, OT_TAUCAI_437275#136296, OT_TAUID_437279#136297, OT_TAUIKM_437286#136298, OT_TAUIKS_437289#136299, OT_TAUIK_437282#136300, OT_TAUMUT_437291#136301, OT_TYPEXO_437272#136302, OT_T_RED_437262#136303]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#137368L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#137185L]
Results [1]: [count(1)#137185L AS COL_5b736808-392e-421a-a96b-35ae6d370c4e#137187L]

(9) Filter
Input [88]: [OT_AMCID_437304#136216, OT_AMOID_437280#136217, OT_AMOIKM_437287#136218, OT_AMOIKS_437290#136219, OT_AMOIK_437283#136220, OT_ANNVAL_437240#136221, OT_AVISEXO_437273#136222, OT_BASRMB_437274#136223, OT_CDAM_437252#136224, OT_COCAL_437246#136225, OT_CODAPP_437320#136226, OT_CODBAS_437242#136227, OT_CODCHA_437241#136228, OT_CODITM_437306#136229, OT_CODLIS_437305#136230, OT_CODPER2_437316#136231, OT_CODPER3_437321#136232, OT_CODPER_437249#136233, OT_CODPRE_437298#136234, OT_CODSER_437250#136235, OT_CODSIT_437264#136236, OT_CODTIT_437322#136237, OT_CODUAM_437312#136238, OT_CODUTI_437265#136239, OT_COEFF_437245#136240, OT_COMPAR_437248#136241, OT_CR_437255#136242, OT_DATMAJ_437263#136243, OT_DENOMB_437303#136244, OT_DEPMNT_437308#136245, OT_FACTUR_437258#136246, OT_FAITLIT_437300#136247, OT_FERIE_437269#136248, OT_FLALD_437271#136249, OT_FLDIVISE_437297#136250, OT_FLID_437277#136251, OT_FLRMO_437266#136252, OT_FORC_437309#136253, OT_FORMAMC_437310#136254, OT_INDBAS_437256#136255, OT_INFTRA_437257#136256, OT_LATER_437318#136257, OT_LETADS_437317#136258, OT_LETTRE_437244#136259, OT_LIGRGR_437296#136260, OT_MAJOAGE_437299#136261, OT_MAJOFERIE_437270#136262, OT_MAJONUIT_437268#136263, OT_MONNAIE_437259#136264, OT_MTDEP_437313#136265, OT_MTPENHPS_437314#136266, OT_MTTID_437278#136267, OT_MTTIKM_437285#136268, OT_MTTIKS_437288#136269, OT_MTTIK_437281#136270, OT_MTTORI_437315#136271, OT_NBRIKM_437284#136272, OT_NBRIKS_437293#136273, OT_NBRIK_437294#136274, OT_NOMDOS_437254#136275, OT_NUIT_437267#136276, OT_NUMCOT_437235#136277, OT_NUMCOT_CCAM_437311#136278, OT_NUMDEM_437236#136279, OT_NUMDOS_437237#136280, OT_NUMERO_437261#136281, OT_NUMEXA_437319#136282, OT_NUMORD_437295#136283, OT_NUMPCO_437238#136284, OT_NUMSAL_437253#136285, OT_NUMTLI_437307#136286, OT_PARCAI_437276#136287, OT_PARMUT_437292#136288, OT_PLATRE_437247#136289, OT_PRIMAI_437239#136290, OT_PRIUNI_437302#136291, OT_QTEBAS_437251#136292, OT_QUALDP_437301#136293, OT_RATTAC_437243#136294, OT_TARIF_437260#136295, OT_TAUCAI_437275#136296, OT_TAUID_437279#136297, OT_TAUIKM_437286#136298, OT_TAUIKS_437289#136299, OT_TAUIK_437282#136300, OT_TAUMUT_437291#136301, OT_TYPEXO_437272#136302, OT_T_RED_437262#136303]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#136277)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#136277)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#136279)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#136279)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#136280)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#136280)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#136284)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#136284)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#136290)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#136290)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#136221)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#136221)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#136228)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#136228)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#136227)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#136227)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#136294)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#136294)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#136259)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#136259)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#136240)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#136240)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#136225)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#136225)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#136289)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#136289)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#136241)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#136241)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#136233)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#136233)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#136235)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#136235)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#136292)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#136292)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#136224)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#136224)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#136285)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#136285)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#136275)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#136275)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#136242)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#136242)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#136255)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#136255)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#136256)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#136256)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#136246)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#136246)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#136264)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#136264)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#136295)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#136295)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#136281)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#136281)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#136303)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#136303)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#136243)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#136243)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#136236)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#136236)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#136239)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#136239)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#136252)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#136252)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#136276)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#136276)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#136263)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#136263)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#136248)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#136248)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#136262)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#136262)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#136249)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#136249)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#136302)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#136302)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#136222)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#136222)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#136223)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#136223)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#136296)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#136296)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#136287)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#136287)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#136251)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#136251)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#136267)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#136267)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#136297)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#136297)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#136217)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#136217)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#136270)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#136270)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#136300)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#136300)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#136220)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#136220)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#136272)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#136272)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#136268)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#136268)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#136298)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#136298)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#136218)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#136218)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#136269)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#136269)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#136299)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#136299)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#136219)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#136219)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#136301)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#136301)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#136288)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#136288)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#136273)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#136273)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#136274)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#136274)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#136283)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#136283)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#136260)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#136260)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#136250)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#136250)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#136234)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#136234)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#136261)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#136261)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#136247)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#136247)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#136293)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#136293)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#136291)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#136291)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#136244)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#136244)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#136216)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#136216)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#136230)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#136230)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#136229)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#136229)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#136286)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#136286)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#136245)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#136245)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#136253)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#136253)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#136254)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#136254)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#136278)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#136278)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#136238)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#136238)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#136265)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#136265)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#136266)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#136266)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#136271)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#136271)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#136231)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#136231)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#136258)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#136258)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#136257)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#136257)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#136282)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#136282)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#136226)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#136226)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#136232)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#136232)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#136237)), )) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#136237)), ) END)

(10) Project
Output: []
Input [88]: [OT_AMCID_437304#136216, OT_AMOID_437280#136217, OT_AMOIKM_437287#136218, OT_AMOIKS_437290#136219, OT_AMOIK_437283#136220, OT_ANNVAL_437240#136221, OT_AVISEXO_437273#136222, OT_BASRMB_437274#136223, OT_CDAM_437252#136224, OT_COCAL_437246#136225, OT_CODAPP_437320#136226, OT_CODBAS_437242#136227, OT_CODCHA_437241#136228, OT_CODITM_437306#136229, OT_CODLIS_437305#136230, OT_CODPER2_437316#136231, OT_CODPER3_437321#136232, OT_CODPER_437249#136233, OT_CODPRE_437298#136234, OT_CODSER_437250#136235, OT_CODSIT_437264#136236, OT_CODTIT_437322#136237, OT_CODUAM_437312#136238, OT_CODUTI_437265#136239, OT_COEFF_437245#136240, OT_COMPAR_437248#136241, OT_CR_437255#136242, OT_DATMAJ_437263#136243, OT_DENOMB_437303#136244, OT_DEPMNT_437308#136245, OT_FACTUR_437258#136246, OT_FAITLIT_437300#136247, OT_FERIE_437269#136248, OT_FLALD_437271#136249, OT_FLDIVISE_437297#136250, OT_FLID_437277#136251, OT_FLRMO_437266#136252, OT_FORC_437309#136253, OT_FORMAMC_437310#136254, OT_INDBAS_437256#136255, OT_INFTRA_437257#136256, OT_LATER_437318#136257, OT_LETADS_437317#136258, OT_LETTRE_437244#136259, OT_LIGRGR_437296#136260, OT_MAJOAGE_437299#136261, OT_MAJOFERIE_437270#136262, OT_MAJONUIT_437268#136263, OT_MONNAIE_437259#136264, OT_MTDEP_437313#136265, OT_MTPENHPS_437314#136266, OT_MTTID_437278#136267, OT_MTTIKM_437285#136268, OT_MTTIKS_437288#136269, OT_MTTIK_437281#136270, OT_MTTORI_437315#136271, OT_NBRIKM_437284#136272, OT_NBRIKS_437293#136273, OT_NBRIK_437294#136274, OT_NOMDOS_437254#136275, OT_NUIT_437267#136276, OT_NUMCOT_437235#136277, OT_NUMCOT_CCAM_437311#136278, OT_NUMDEM_437236#136279, OT_NUMDOS_437237#136280, OT_NUMERO_437261#136281, OT_NUMEXA_437319#136282, OT_NUMORD_437295#136283, OT_NUMPCO_437238#136284, OT_NUMSAL_437253#136285, OT_NUMTLI_437307#136286, OT_PARCAI_437276#136287, OT_PARMUT_437292#136288, OT_PLATRE_437247#136289, OT_PRIMAI_437239#136290, OT_PRIUNI_437302#136291, OT_QTEBAS_437251#136292, OT_QUALDP_437301#136293, OT_RATTAC_437243#136294, OT_TARIF_437260#136295, OT_TAUCAI_437275#136296, OT_TAUID_437279#136297, OT_TAUIKM_437286#136298, OT_TAUIKS_437289#136299, OT_TAUIK_437282#136300, OT_TAUMUT_437291#136301, OT_TYPEXO_437272#136302, OT_T_RED_437262#136303]

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

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

(13) HashAggregate
Input [1]: [count#137368L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#137185L]
Results [1]: [count(1)#137185L AS COL_5b736808-392e-421a-a96b-35ae6d370c4e#137187L]

(14) AdaptiveSparkPlan
Output [1]: [COL_5b736808-392e-421a-a96b-35ae6d370c4e#137187L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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