hdh-spark-job - Details for Query 701

Submitted Time: 2026/10/21 21:34:33
Duration: 9 s
Succeeded Jobs: 677 680

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: 8.3 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 8.3 s 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: 50,890 number of input batches: 13"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 112 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=14326]

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

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#151284)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#151284)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#151286)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#151286)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#151287)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#151287)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#151291)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#151291)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#151297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#151297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#151228)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#151228)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#151235)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#151235)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#151234)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#151234)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#151301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#151301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#151266)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#151266)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#151247)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#151247)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#151232)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#151232)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#151296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#151296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#151248)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#151248)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#151240)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#151240)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#151242)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#151242)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#151299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#151299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#151231)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#151231)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#151292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#151292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#151282)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#151282)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#151249)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#151249)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#151262)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#151262)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#151263)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#151263)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#151253)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#151253)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#151271)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#151271)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#151302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#151302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#151288)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#151288)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#151310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#151310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#151250)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#151250)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#151243)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#151243)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#151246)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#151246)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#151259)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#151259)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#151283)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#151283)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#151270)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#151270)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#151255)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#151255)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#151269)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#151269)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#151256)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#151256)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#151309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#151309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#151229)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#151229)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#151230)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#151230)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#151303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#151303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#151294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#151294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#151258)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#151258)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#151274)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#151274)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#151304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#151304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#151224)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#151224)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#151277)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#151277)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#151307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#151307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#151227)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#151227)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#151279)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#151279)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#151275)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#151275)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#151305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#151305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#151225)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#151225)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#151276)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#151276)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#151306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#151306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#151226)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#151226)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#151308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#151308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#151295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#151295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#151280)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#151280)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#151281)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#151281)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#151290)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#151290)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#151267)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#151267)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#151257)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#151257)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#151241)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#151241)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#151268)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#151268)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#151254)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#151254)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#151300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#151300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#151298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#151298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#151251)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#151251)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#151223)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#151223)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#151237)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#151237)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#151236)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#151236)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#151293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#151293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#151252)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#151252)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#151260)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#151260)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#151261)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#151261)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#151285)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#151285)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#151245)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#151245)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#151272)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#151272)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#151273)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#151273)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#151278)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#151278)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#151238)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#151238)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#151265)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#151265)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#151264)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#151264)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#151289)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#151289)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#151233)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#151233)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#151239)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#151239)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#151244)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#151244)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [OT_AMCID_437304#151223,OT_AMOID_437280#151224,OT_AMOIKM_437287#151225,OT_AMOIKS_437290#151226,OT_AMOIK_437283#151227,OT_ANNVAL_437240#151228,OT_AVISEXO_437273#151229,OT_BASRMB_437274#151230,OT_CDAM_437252#151231,OT_COCAL_437246#151232,OT_CODAPP_437320#151233,OT_CODBAS_437242#151234,OT_CODCHA_437241#151235,OT_CODITM_437306#151236,OT_CODLIS_437305#151237,OT_CODPER2_437316#151238,OT_CODPER3_437321#151239,OT_CODPER_437249#151240,OT_CODPRE_437298#151241,OT_CODSER_437250#151242,OT_CODSIT_437264#151243,OT_CODTIT_437322#151244,OT_CODUAM_437312#151245,OT_CODUTI_437265#151246,... 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#151223, OT_AMOID_437280#151224, OT_AMOIKM_437287#151225, OT_AMOIKS_437290#151226, OT_AMOIK_437283#151227, OT_ANNVAL_437240#151228, OT_AVISEXO_437273#151229, OT_BASRMB_437274#151230, OT_CDAM_437252#151231, OT_COCAL_437246#151232, OT_CODAPP_437320#151233, OT_CODBAS_437242#151234, OT_CODCHA_437241#151235, OT_CODITM_437306#151236, OT_CODLIS_437305#151237, OT_CODPER2_437316#151238, OT_CODPER3_437321#151239, OT_CODPER_437249#151240, OT_CODPRE_437298#151241, OT_CODSER_437250#151242, OT_CODSIT_437264#151243, OT_CODTIT_437322#151244, OT_CODUAM_437312#151245, OT_CODUTI_437265#151246, OT_COEFF_437245#151247, OT_COMPAR_437248#151248, OT_CR_437255#151249, OT_DATMAJ_437263#151250, OT_DENOMB_437303#151251, OT_DEPMNT_437308#151252, OT_FACTUR_437258#151253, OT_FAITLIT_437300#151254, OT_FERIE_437269#151255, OT_FLALD_437271#151256, OT_FLDIVISE_437297#151257, OT_FLID_437277#151258, OT_FLRMO_437266#151259, OT_FORC_437309#151260, OT_FORMAMC_437310#151261, OT_INDBAS_437256#151262, OT_INFTRA_437257#151263, OT_LATER_437318#151264, OT_LETADS_437317#151265, OT_LETTRE_437244#151266, OT_LIGRGR_437296#151267, OT_MAJOAGE_437299#151268, OT_MAJOFERIE_437270#151269, OT_MAJONUIT_437268#151270, OT_MONNAIE_437259#151271, OT_MTDEP_437313#151272, OT_MTPENHPS_437314#151273, OT_MTTID_437278#151274, OT_MTTIKM_437285#151275, OT_MTTIKS_437288#151276, OT_MTTIK_437281#151277, OT_MTTORI_437315#151278, OT_NBRIKM_437284#151279, OT_NBRIKS_437293#151280, OT_NBRIK_437294#151281, OT_NOMDOS_437254#151282, OT_NUIT_437267#151283, OT_NUMCOT_437235#151284, OT_NUMCOT_CCAM_437311#151285, OT_NUMDEM_437236#151286, OT_NUMDOS_437237#151287, OT_NUMERO_437261#151288, OT_NUMEXA_437319#151289, OT_NUMORD_437295#151290, OT_NUMPCO_437238#151291, OT_NUMSAL_437253#151292, OT_NUMTLI_437307#151293, OT_PARCAI_437276#151294, OT_PARMUT_437292#151295, OT_PLATRE_437247#151296, OT_PRIMAI_437239#151297, OT_PRIUNI_437302#151298, OT_QTEBAS_437251#151299, OT_QUALDP_437301#151300, OT_RATTAC_437243#151301, OT_TARIF_437260#151302, OT_TAUCAI_437275#151303, OT_TAUID_437279#151304, OT_TAUIKM_437286#151305, OT_TAUIKS_437289#151306, OT_TAUIK_437282#151307, OT_TAUMUT_437291#151308, OT_TYPEXO_437272#151309, OT_T_RED_437262#151310]
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#151223, OT_AMOID_437280#151224, OT_AMOIKM_437287#151225, OT_AMOIKS_437290#151226, OT_AMOIK_437283#151227, OT_ANNVAL_437240#151228, OT_AVISEXO_437273#151229, OT_BASRMB_437274#151230, OT_CDAM_437252#151231, OT_COCAL_437246#151232, OT_CODAPP_437320#151233, OT_CODBAS_437242#151234, OT_CODCHA_437241#151235, OT_CODITM_437306#151236, OT_CODLIS_437305#151237, OT_CODPER2_437316#151238, OT_CODPER3_437321#151239, OT_CODPER_437249#151240, OT_CODPRE_437298#151241, OT_CODSER_437250#151242, OT_CODSIT_437264#151243, OT_CODTIT_437322#151244, OT_CODUAM_437312#151245, OT_CODUTI_437265#151246, OT_COEFF_437245#151247, OT_COMPAR_437248#151248, OT_CR_437255#151249, OT_DATMAJ_437263#151250, OT_DENOMB_437303#151251, OT_DEPMNT_437308#151252, OT_FACTUR_437258#151253, OT_FAITLIT_437300#151254, OT_FERIE_437269#151255, OT_FLALD_437271#151256, OT_FLDIVISE_437297#151257, OT_FLID_437277#151258, OT_FLRMO_437266#151259, OT_FORC_437309#151260, OT_FORMAMC_437310#151261, OT_INDBAS_437256#151262, OT_INFTRA_437257#151263, OT_LATER_437318#151264, OT_LETADS_437317#151265, OT_LETTRE_437244#151266, OT_LIGRGR_437296#151267, OT_MAJOAGE_437299#151268, OT_MAJOFERIE_437270#151269, OT_MAJONUIT_437268#151270, OT_MONNAIE_437259#151271, OT_MTDEP_437313#151272, OT_MTPENHPS_437314#151273, OT_MTTID_437278#151274, OT_MTTIKM_437285#151275, OT_MTTIKS_437288#151276, OT_MTTIK_437281#151277, OT_MTTORI_437315#151278, OT_NBRIKM_437284#151279, OT_NBRIKS_437293#151280, OT_NBRIK_437294#151281, OT_NOMDOS_437254#151282, OT_NUIT_437267#151283, OT_NUMCOT_437235#151284, OT_NUMCOT_CCAM_437311#151285, OT_NUMDEM_437236#151286, OT_NUMDOS_437237#151287, OT_NUMERO_437261#151288, OT_NUMEXA_437319#151289, OT_NUMORD_437295#151290, OT_NUMPCO_437238#151291, OT_NUMSAL_437253#151292, OT_NUMTLI_437307#151293, OT_PARCAI_437276#151294, OT_PARMUT_437292#151295, OT_PLATRE_437247#151296, OT_PRIMAI_437239#151297, OT_PRIUNI_437302#151298, OT_QTEBAS_437251#151299, OT_QUALDP_437301#151300, OT_RATTAC_437243#151301, OT_TARIF_437260#151302, OT_TAUCAI_437275#151303, OT_TAUID_437279#151304, OT_TAUIKM_437286#151305, OT_TAUIKS_437289#151306, OT_TAUIK_437282#151307, OT_TAUMUT_437291#151308, OT_TYPEXO_437272#151309, OT_T_RED_437262#151310]

(3) Filter [codegen id : 1]
Input [88]: [OT_AMCID_437304#151223, OT_AMOID_437280#151224, OT_AMOIKM_437287#151225, OT_AMOIKS_437290#151226, OT_AMOIK_437283#151227, OT_ANNVAL_437240#151228, OT_AVISEXO_437273#151229, OT_BASRMB_437274#151230, OT_CDAM_437252#151231, OT_COCAL_437246#151232, OT_CODAPP_437320#151233, OT_CODBAS_437242#151234, OT_CODCHA_437241#151235, OT_CODITM_437306#151236, OT_CODLIS_437305#151237, OT_CODPER2_437316#151238, OT_CODPER3_437321#151239, OT_CODPER_437249#151240, OT_CODPRE_437298#151241, OT_CODSER_437250#151242, OT_CODSIT_437264#151243, OT_CODTIT_437322#151244, OT_CODUAM_437312#151245, OT_CODUTI_437265#151246, OT_COEFF_437245#151247, OT_COMPAR_437248#151248, OT_CR_437255#151249, OT_DATMAJ_437263#151250, OT_DENOMB_437303#151251, OT_DEPMNT_437308#151252, OT_FACTUR_437258#151253, OT_FAITLIT_437300#151254, OT_FERIE_437269#151255, OT_FLALD_437271#151256, OT_FLDIVISE_437297#151257, OT_FLID_437277#151258, OT_FLRMO_437266#151259, OT_FORC_437309#151260, OT_FORMAMC_437310#151261, OT_INDBAS_437256#151262, OT_INFTRA_437257#151263, OT_LATER_437318#151264, OT_LETADS_437317#151265, OT_LETTRE_437244#151266, OT_LIGRGR_437296#151267, OT_MAJOAGE_437299#151268, OT_MAJOFERIE_437270#151269, OT_MAJONUIT_437268#151270, OT_MONNAIE_437259#151271, OT_MTDEP_437313#151272, OT_MTPENHPS_437314#151273, OT_MTTID_437278#151274, OT_MTTIKM_437285#151275, OT_MTTIKS_437288#151276, OT_MTTIK_437281#151277, OT_MTTORI_437315#151278, OT_NBRIKM_437284#151279, OT_NBRIKS_437293#151280, OT_NBRIK_437294#151281, OT_NOMDOS_437254#151282, OT_NUIT_437267#151283, OT_NUMCOT_437235#151284, OT_NUMCOT_CCAM_437311#151285, OT_NUMDEM_437236#151286, OT_NUMDOS_437237#151287, OT_NUMERO_437261#151288, OT_NUMEXA_437319#151289, OT_NUMORD_437295#151290, OT_NUMPCO_437238#151291, OT_NUMSAL_437253#151292, OT_NUMTLI_437307#151293, OT_PARCAI_437276#151294, OT_PARMUT_437292#151295, OT_PLATRE_437247#151296, OT_PRIMAI_437239#151297, OT_PRIUNI_437302#151298, OT_QTEBAS_437251#151299, OT_QUALDP_437301#151300, OT_RATTAC_437243#151301, OT_TARIF_437260#151302, OT_TAUCAI_437275#151303, OT_TAUID_437279#151304, OT_TAUIKM_437286#151305, OT_TAUIKS_437289#151306, OT_TAUIK_437282#151307, OT_TAUMUT_437291#151308, OT_TYPEXO_437272#151309, OT_T_RED_437262#151310]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#151284)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#151284)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#151286)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#151286)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#151287)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#151287)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#151291)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#151291)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#151297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#151297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#151228)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#151228)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#151235)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#151235)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#151234)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#151234)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#151301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#151301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#151266)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#151266)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#151247)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#151247)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#151232)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#151232)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#151296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#151296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#151248)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#151248)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#151240)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#151240)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#151242)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#151242)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#151299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#151299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#151231)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#151231)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#151292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#151292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#151282)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#151282)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#151249)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#151249)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#151262)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#151262)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#151263)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#151263)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#151253)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#151253)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#151271)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#151271)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#151302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#151302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#151288)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#151288)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#151310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#151310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#151250)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#151250)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#151243)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#151243)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#151246)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#151246)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#151259)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#151259)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#151283)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#151283)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#151270)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#151270)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#151255)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#151255)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#151269)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#151269)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#151256)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#151256)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#151309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#151309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#151229)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#151229)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#151230)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#151230)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#151303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#151303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#151294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#151294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#151258)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#151258)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#151274)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#151274)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#151304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#151304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#151224)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#151224)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#151277)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#151277)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#151307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#151307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#151227)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#151227)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#151279)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#151279)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#151275)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#151275)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#151305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#151305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#151225)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#151225)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#151276)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#151276)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#151306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#151306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#151226)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#151226)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#151308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#151308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#151295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#151295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#151280)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#151280)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#151281)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#151281)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#151290)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#151290)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#151267)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#151267)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#151257)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#151257)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#151241)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#151241)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#151268)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#151268)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#151254)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#151254)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#151300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#151300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#151298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#151298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#151251)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#151251)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#151223)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#151223)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#151237)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#151237)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#151236)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#151236)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#151293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#151293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#151252)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#151252)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#151260)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#151260)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#151261)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#151261)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#151285)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#151285)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#151245)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#151245)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#151272)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#151272)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#151273)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#151273)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#151278)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#151278)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#151238)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#151238)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#151265)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#151265)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#151264)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#151264)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#151289)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#151289)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#151233)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#151233)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#151239)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#151239)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#151244)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#151244)), MARX) END)

(4) Project [codegen id : 1]
Output: []
Input [88]: [OT_AMCID_437304#151223, OT_AMOID_437280#151224, OT_AMOIKM_437287#151225, OT_AMOIKS_437290#151226, OT_AMOIK_437283#151227, OT_ANNVAL_437240#151228, OT_AVISEXO_437273#151229, OT_BASRMB_437274#151230, OT_CDAM_437252#151231, OT_COCAL_437246#151232, OT_CODAPP_437320#151233, OT_CODBAS_437242#151234, OT_CODCHA_437241#151235, OT_CODITM_437306#151236, OT_CODLIS_437305#151237, OT_CODPER2_437316#151238, OT_CODPER3_437321#151239, OT_CODPER_437249#151240, OT_CODPRE_437298#151241, OT_CODSER_437250#151242, OT_CODSIT_437264#151243, OT_CODTIT_437322#151244, OT_CODUAM_437312#151245, OT_CODUTI_437265#151246, OT_COEFF_437245#151247, OT_COMPAR_437248#151248, OT_CR_437255#151249, OT_DATMAJ_437263#151250, OT_DENOMB_437303#151251, OT_DEPMNT_437308#151252, OT_FACTUR_437258#151253, OT_FAITLIT_437300#151254, OT_FERIE_437269#151255, OT_FLALD_437271#151256, OT_FLDIVISE_437297#151257, OT_FLID_437277#151258, OT_FLRMO_437266#151259, OT_FORC_437309#151260, OT_FORMAMC_437310#151261, OT_INDBAS_437256#151262, OT_INFTRA_437257#151263, OT_LATER_437318#151264, OT_LETADS_437317#151265, OT_LETTRE_437244#151266, OT_LIGRGR_437296#151267, OT_MAJOAGE_437299#151268, OT_MAJOFERIE_437270#151269, OT_MAJONUIT_437268#151270, OT_MONNAIE_437259#151271, OT_MTDEP_437313#151272, OT_MTPENHPS_437314#151273, OT_MTTID_437278#151274, OT_MTTIKM_437285#151275, OT_MTTIKS_437288#151276, OT_MTTIK_437281#151277, OT_MTTORI_437315#151278, OT_NBRIKM_437284#151279, OT_NBRIKS_437293#151280, OT_NBRIK_437294#151281, OT_NOMDOS_437254#151282, OT_NUIT_437267#151283, OT_NUMCOT_437235#151284, OT_NUMCOT_CCAM_437311#151285, OT_NUMDEM_437236#151286, OT_NUMDOS_437237#151287, OT_NUMERO_437261#151288, OT_NUMEXA_437319#151289, OT_NUMORD_437295#151290, OT_NUMPCO_437238#151291, OT_NUMSAL_437253#151292, OT_NUMTLI_437307#151293, OT_PARCAI_437276#151294, OT_PARMUT_437292#151295, OT_PLATRE_437247#151296, OT_PRIMAI_437239#151297, OT_PRIUNI_437302#151298, OT_QTEBAS_437251#151299, OT_QUALDP_437301#151300, OT_RATTAC_437243#151301, OT_TARIF_437260#151302, OT_TAUCAI_437275#151303, OT_TAUID_437279#151304, OT_TAUIKM_437286#151305, OT_TAUIKS_437289#151306, OT_TAUIK_437282#151307, OT_TAUMUT_437291#151308, OT_TYPEXO_437272#151309, OT_T_RED_437262#151310]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#152372L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#152272L]
Results [1]: [count(1)#152272L AS COL_862e8236-4618-44c5-be4e-b326280b0472#152274L]

(9) Filter
Input [88]: [OT_AMCID_437304#151223, OT_AMOID_437280#151224, OT_AMOIKM_437287#151225, OT_AMOIKS_437290#151226, OT_AMOIK_437283#151227, OT_ANNVAL_437240#151228, OT_AVISEXO_437273#151229, OT_BASRMB_437274#151230, OT_CDAM_437252#151231, OT_COCAL_437246#151232, OT_CODAPP_437320#151233, OT_CODBAS_437242#151234, OT_CODCHA_437241#151235, OT_CODITM_437306#151236, OT_CODLIS_437305#151237, OT_CODPER2_437316#151238, OT_CODPER3_437321#151239, OT_CODPER_437249#151240, OT_CODPRE_437298#151241, OT_CODSER_437250#151242, OT_CODSIT_437264#151243, OT_CODTIT_437322#151244, OT_CODUAM_437312#151245, OT_CODUTI_437265#151246, OT_COEFF_437245#151247, OT_COMPAR_437248#151248, OT_CR_437255#151249, OT_DATMAJ_437263#151250, OT_DENOMB_437303#151251, OT_DEPMNT_437308#151252, OT_FACTUR_437258#151253, OT_FAITLIT_437300#151254, OT_FERIE_437269#151255, OT_FLALD_437271#151256, OT_FLDIVISE_437297#151257, OT_FLID_437277#151258, OT_FLRMO_437266#151259, OT_FORC_437309#151260, OT_FORMAMC_437310#151261, OT_INDBAS_437256#151262, OT_INFTRA_437257#151263, OT_LATER_437318#151264, OT_LETADS_437317#151265, OT_LETTRE_437244#151266, OT_LIGRGR_437296#151267, OT_MAJOAGE_437299#151268, OT_MAJOFERIE_437270#151269, OT_MAJONUIT_437268#151270, OT_MONNAIE_437259#151271, OT_MTDEP_437313#151272, OT_MTPENHPS_437314#151273, OT_MTTID_437278#151274, OT_MTTIKM_437285#151275, OT_MTTIKS_437288#151276, OT_MTTIK_437281#151277, OT_MTTORI_437315#151278, OT_NBRIKM_437284#151279, OT_NBRIKS_437293#151280, OT_NBRIK_437294#151281, OT_NOMDOS_437254#151282, OT_NUIT_437267#151283, OT_NUMCOT_437235#151284, OT_NUMCOT_CCAM_437311#151285, OT_NUMDEM_437236#151286, OT_NUMDOS_437237#151287, OT_NUMERO_437261#151288, OT_NUMEXA_437319#151289, OT_NUMORD_437295#151290, OT_NUMPCO_437238#151291, OT_NUMSAL_437253#151292, OT_NUMTLI_437307#151293, OT_PARCAI_437276#151294, OT_PARMUT_437292#151295, OT_PLATRE_437247#151296, OT_PRIMAI_437239#151297, OT_PRIUNI_437302#151298, OT_QTEBAS_437251#151299, OT_QUALDP_437301#151300, OT_RATTAC_437243#151301, OT_TARIF_437260#151302, OT_TAUCAI_437275#151303, OT_TAUID_437279#151304, OT_TAUIKM_437286#151305, OT_TAUIKS_437289#151306, OT_TAUIK_437282#151307, OT_TAUMUT_437291#151308, OT_TYPEXO_437272#151309, OT_T_RED_437262#151310]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#151284)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#151284)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#151286)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#151286)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#151287)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#151287)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#151291)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#151291)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#151297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#151297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#151228)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#151228)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#151235)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#151235)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#151234)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#151234)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#151301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#151301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#151266)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#151266)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#151247)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#151247)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#151232)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#151232)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#151296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#151296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#151248)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#151248)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#151240)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#151240)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#151242)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#151242)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#151299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#151299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#151231)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#151231)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#151292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#151292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#151282)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#151282)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#151249)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#151249)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#151262)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#151262)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#151263)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#151263)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#151253)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#151253)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#151271)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#151271)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#151302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#151302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#151288)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#151288)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#151310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#151310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#151250)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#151250)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#151243)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#151243)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#151246)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#151246)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#151259)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#151259)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#151283)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#151283)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#151270)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#151270)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#151255)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#151255)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#151269)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#151269)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#151256)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#151256)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#151309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#151309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#151229)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#151229)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#151230)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#151230)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#151303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#151303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#151294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#151294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#151258)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#151258)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#151274)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#151274)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#151304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#151304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#151224)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#151224)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#151277)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#151277)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#151307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#151307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#151227)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#151227)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#151279)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#151279)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#151275)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#151275)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#151305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#151305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#151225)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#151225)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#151276)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#151276)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#151306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#151306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#151226)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#151226)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#151308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#151308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#151295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#151295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#151280)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#151280)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#151281)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#151281)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#151290)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#151290)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#151267)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#151267)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#151257)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#151257)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#151241)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#151241)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#151268)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#151268)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#151254)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#151254)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#151300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#151300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#151298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#151298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#151251)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#151251)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#151223)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#151223)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#151237)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#151237)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#151236)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#151236)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#151293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#151293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#151252)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#151252)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#151260)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#151260)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#151261)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#151261)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#151285)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#151285)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#151245)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#151245)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#151272)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#151272)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#151273)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#151273)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#151278)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#151278)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#151238)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#151238)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#151265)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#151265)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#151264)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#151264)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#151289)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#151289)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#151233)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#151233)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#151239)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#151239)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#151244)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#151244)), MARX) END)

(10) Project
Output: []
Input [88]: [OT_AMCID_437304#151223, OT_AMOID_437280#151224, OT_AMOIKM_437287#151225, OT_AMOIKS_437290#151226, OT_AMOIK_437283#151227, OT_ANNVAL_437240#151228, OT_AVISEXO_437273#151229, OT_BASRMB_437274#151230, OT_CDAM_437252#151231, OT_COCAL_437246#151232, OT_CODAPP_437320#151233, OT_CODBAS_437242#151234, OT_CODCHA_437241#151235, OT_CODITM_437306#151236, OT_CODLIS_437305#151237, OT_CODPER2_437316#151238, OT_CODPER3_437321#151239, OT_CODPER_437249#151240, OT_CODPRE_437298#151241, OT_CODSER_437250#151242, OT_CODSIT_437264#151243, OT_CODTIT_437322#151244, OT_CODUAM_437312#151245, OT_CODUTI_437265#151246, OT_COEFF_437245#151247, OT_COMPAR_437248#151248, OT_CR_437255#151249, OT_DATMAJ_437263#151250, OT_DENOMB_437303#151251, OT_DEPMNT_437308#151252, OT_FACTUR_437258#151253, OT_FAITLIT_437300#151254, OT_FERIE_437269#151255, OT_FLALD_437271#151256, OT_FLDIVISE_437297#151257, OT_FLID_437277#151258, OT_FLRMO_437266#151259, OT_FORC_437309#151260, OT_FORMAMC_437310#151261, OT_INDBAS_437256#151262, OT_INFTRA_437257#151263, OT_LATER_437318#151264, OT_LETADS_437317#151265, OT_LETTRE_437244#151266, OT_LIGRGR_437296#151267, OT_MAJOAGE_437299#151268, OT_MAJOFERIE_437270#151269, OT_MAJONUIT_437268#151270, OT_MONNAIE_437259#151271, OT_MTDEP_437313#151272, OT_MTPENHPS_437314#151273, OT_MTTID_437278#151274, OT_MTTIKM_437285#151275, OT_MTTIKS_437288#151276, OT_MTTIK_437281#151277, OT_MTTORI_437315#151278, OT_NBRIKM_437284#151279, OT_NBRIKS_437293#151280, OT_NBRIK_437294#151281, OT_NOMDOS_437254#151282, OT_NUIT_437267#151283, OT_NUMCOT_437235#151284, OT_NUMCOT_CCAM_437311#151285, OT_NUMDEM_437236#151286, OT_NUMDOS_437237#151287, OT_NUMERO_437261#151288, OT_NUMEXA_437319#151289, OT_NUMORD_437295#151290, OT_NUMPCO_437238#151291, OT_NUMSAL_437253#151292, OT_NUMTLI_437307#151293, OT_PARCAI_437276#151294, OT_PARMUT_437292#151295, OT_PLATRE_437247#151296, OT_PRIMAI_437239#151297, OT_PRIUNI_437302#151298, OT_QTEBAS_437251#151299, OT_QUALDP_437301#151300, OT_RATTAC_437243#151301, OT_TARIF_437260#151302, OT_TAUCAI_437275#151303, OT_TAUID_437279#151304, OT_TAUIKM_437286#151305, OT_TAUIKS_437289#151306, OT_TAUIK_437282#151307, OT_TAUMUT_437291#151308, OT_TYPEXO_437272#151309, OT_T_RED_437262#151310]

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

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

(13) HashAggregate
Input [1]: [count#152372L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#152272L]
Results [1]: [count(1)#152272L AS COL_862e8236-4618-44c5-be4e-b326280b0472#152274L]

(14) AdaptiveSparkPlan
Output [1]: [COL_862e8236-4618-44c5-be4e-b326280b0472#152274L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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