hdh-spark-job - Details for Query 591

Submitted Time: 2026/10/21 21:31:44
Duration: 7 s
Succeeded Jobs: 515 539

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: 5.9 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 5.9 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: 28 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=11567]

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

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#120371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#120371)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#120373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#120373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#120374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#120374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#120378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#120378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#120384)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#120384)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#120315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#120315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#120322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#120322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#120321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#120321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#120388)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#120388)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#120353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#120353)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#120334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#120334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#120319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#120319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#120383)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#120383)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#120335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#120335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#120327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#120327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#120329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#120329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#120386)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#120386)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#120318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#120318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#120379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#120379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#120369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#120369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#120336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#120336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#120349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#120349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#120350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#120350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#120340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#120340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#120358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#120358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#120389)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#120389)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#120375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#120375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#120397)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#120397)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#120337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#120337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#120330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#120330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#120333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#120333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#120346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#120346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#120370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#120370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#120357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#120357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#120342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#120342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#120356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#120356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#120343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#120343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#120396)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#120396)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#120316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#120316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#120317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#120317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#120390)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#120390)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#120381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#120381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#120345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#120345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#120361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#120361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#120391)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#120391)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#120311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#120311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#120364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#120364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#120394)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#120394)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#120314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#120314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#120366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#120366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#120362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#120362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#120392)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#120392)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#120312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#120312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#120363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#120363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#120393)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#120393)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#120313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#120313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#120395)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#120395)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#120382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#120382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#120367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#120367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#120368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#120368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#120377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#120377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#120354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#120354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#120344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#120344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#120328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#120328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#120355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#120355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#120341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#120341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#120387)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#120387)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#120385)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#120385)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#120338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#120338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#120310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#120310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#120324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#120324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#120323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#120323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#120380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#120380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#120339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#120339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#120347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#120347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#120348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#120348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#120372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#120372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#120332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#120332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#120359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#120359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#120360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#120360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#120365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#120365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#120325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#120325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#120352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#120352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#120351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#120351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#120376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#120376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#120320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#120320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#120326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#120326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#120331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#120331)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [OT_AMCID_437304#120310,OT_AMOID_437280#120311,OT_AMOIKM_437287#120312,OT_AMOIKS_437290#120313,OT_AMOIK_437283#120314,OT_ANNVAL_437240#120315,OT_AVISEXO_437273#120316,OT_BASRMB_437274#120317,OT_CDAM_437252#120318,OT_COCAL_437246#120319,OT_CODAPP_437320#120320,OT_CODBAS_437242#120321,OT_CODCHA_437241#120322,OT_CODITM_437306#120323,OT_CODLIS_437305#120324,OT_CODPER2_437316#120325,OT_CODPER3_437321#120326,OT_CODPER_437249#120327,OT_CODPRE_437298#120328,OT_CODSER_437250#120329,OT_CODSIT_437264#120330,OT_CODTIT_437322#120331,OT_CODUAM_437312#120332,OT_CODUTI_437265#120333,... 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#120310, OT_AMOID_437280#120311, OT_AMOIKM_437287#120312, OT_AMOIKS_437290#120313, OT_AMOIK_437283#120314, OT_ANNVAL_437240#120315, OT_AVISEXO_437273#120316, OT_BASRMB_437274#120317, OT_CDAM_437252#120318, OT_COCAL_437246#120319, OT_CODAPP_437320#120320, OT_CODBAS_437242#120321, OT_CODCHA_437241#120322, OT_CODITM_437306#120323, OT_CODLIS_437305#120324, OT_CODPER2_437316#120325, OT_CODPER3_437321#120326, OT_CODPER_437249#120327, OT_CODPRE_437298#120328, OT_CODSER_437250#120329, OT_CODSIT_437264#120330, OT_CODTIT_437322#120331, OT_CODUAM_437312#120332, OT_CODUTI_437265#120333, OT_COEFF_437245#120334, OT_COMPAR_437248#120335, OT_CR_437255#120336, OT_DATMAJ_437263#120337, OT_DENOMB_437303#120338, OT_DEPMNT_437308#120339, OT_FACTUR_437258#120340, OT_FAITLIT_437300#120341, OT_FERIE_437269#120342, OT_FLALD_437271#120343, OT_FLDIVISE_437297#120344, OT_FLID_437277#120345, OT_FLRMO_437266#120346, OT_FORC_437309#120347, OT_FORMAMC_437310#120348, OT_INDBAS_437256#120349, OT_INFTRA_437257#120350, OT_LATER_437318#120351, OT_LETADS_437317#120352, OT_LETTRE_437244#120353, OT_LIGRGR_437296#120354, OT_MAJOAGE_437299#120355, OT_MAJOFERIE_437270#120356, OT_MAJONUIT_437268#120357, OT_MONNAIE_437259#120358, OT_MTDEP_437313#120359, OT_MTPENHPS_437314#120360, OT_MTTID_437278#120361, OT_MTTIKM_437285#120362, OT_MTTIKS_437288#120363, OT_MTTIK_437281#120364, OT_MTTORI_437315#120365, OT_NBRIKM_437284#120366, OT_NBRIKS_437293#120367, OT_NBRIK_437294#120368, OT_NOMDOS_437254#120369, OT_NUIT_437267#120370, OT_NUMCOT_437235#120371, OT_NUMCOT_CCAM_437311#120372, OT_NUMDEM_437236#120373, OT_NUMDOS_437237#120374, OT_NUMERO_437261#120375, OT_NUMEXA_437319#120376, OT_NUMORD_437295#120377, OT_NUMPCO_437238#120378, OT_NUMSAL_437253#120379, OT_NUMTLI_437307#120380, OT_PARCAI_437276#120381, OT_PARMUT_437292#120382, OT_PLATRE_437247#120383, OT_PRIMAI_437239#120384, OT_PRIUNI_437302#120385, OT_QTEBAS_437251#120386, OT_QUALDP_437301#120387, OT_RATTAC_437243#120388, OT_TARIF_437260#120389, OT_TAUCAI_437275#120390, OT_TAUID_437279#120391, OT_TAUIKM_437286#120392, OT_TAUIKS_437289#120393, OT_TAUIK_437282#120394, OT_TAUMUT_437291#120395, OT_TYPEXO_437272#120396, OT_T_RED_437262#120397]
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#120310, OT_AMOID_437280#120311, OT_AMOIKM_437287#120312, OT_AMOIKS_437290#120313, OT_AMOIK_437283#120314, OT_ANNVAL_437240#120315, OT_AVISEXO_437273#120316, OT_BASRMB_437274#120317, OT_CDAM_437252#120318, OT_COCAL_437246#120319, OT_CODAPP_437320#120320, OT_CODBAS_437242#120321, OT_CODCHA_437241#120322, OT_CODITM_437306#120323, OT_CODLIS_437305#120324, OT_CODPER2_437316#120325, OT_CODPER3_437321#120326, OT_CODPER_437249#120327, OT_CODPRE_437298#120328, OT_CODSER_437250#120329, OT_CODSIT_437264#120330, OT_CODTIT_437322#120331, OT_CODUAM_437312#120332, OT_CODUTI_437265#120333, OT_COEFF_437245#120334, OT_COMPAR_437248#120335, OT_CR_437255#120336, OT_DATMAJ_437263#120337, OT_DENOMB_437303#120338, OT_DEPMNT_437308#120339, OT_FACTUR_437258#120340, OT_FAITLIT_437300#120341, OT_FERIE_437269#120342, OT_FLALD_437271#120343, OT_FLDIVISE_437297#120344, OT_FLID_437277#120345, OT_FLRMO_437266#120346, OT_FORC_437309#120347, OT_FORMAMC_437310#120348, OT_INDBAS_437256#120349, OT_INFTRA_437257#120350, OT_LATER_437318#120351, OT_LETADS_437317#120352, OT_LETTRE_437244#120353, OT_LIGRGR_437296#120354, OT_MAJOAGE_437299#120355, OT_MAJOFERIE_437270#120356, OT_MAJONUIT_437268#120357, OT_MONNAIE_437259#120358, OT_MTDEP_437313#120359, OT_MTPENHPS_437314#120360, OT_MTTID_437278#120361, OT_MTTIKM_437285#120362, OT_MTTIKS_437288#120363, OT_MTTIK_437281#120364, OT_MTTORI_437315#120365, OT_NBRIKM_437284#120366, OT_NBRIKS_437293#120367, OT_NBRIK_437294#120368, OT_NOMDOS_437254#120369, OT_NUIT_437267#120370, OT_NUMCOT_437235#120371, OT_NUMCOT_CCAM_437311#120372, OT_NUMDEM_437236#120373, OT_NUMDOS_437237#120374, OT_NUMERO_437261#120375, OT_NUMEXA_437319#120376, OT_NUMORD_437295#120377, OT_NUMPCO_437238#120378, OT_NUMSAL_437253#120379, OT_NUMTLI_437307#120380, OT_PARCAI_437276#120381, OT_PARMUT_437292#120382, OT_PLATRE_437247#120383, OT_PRIMAI_437239#120384, OT_PRIUNI_437302#120385, OT_QTEBAS_437251#120386, OT_QUALDP_437301#120387, OT_RATTAC_437243#120388, OT_TARIF_437260#120389, OT_TAUCAI_437275#120390, OT_TAUID_437279#120391, OT_TAUIKM_437286#120392, OT_TAUIKS_437289#120393, OT_TAUIK_437282#120394, OT_TAUMUT_437291#120395, OT_TYPEXO_437272#120396, OT_T_RED_437262#120397]

(3) Filter [codegen id : 1]
Input [88]: [OT_AMCID_437304#120310, OT_AMOID_437280#120311, OT_AMOIKM_437287#120312, OT_AMOIKS_437290#120313, OT_AMOIK_437283#120314, OT_ANNVAL_437240#120315, OT_AVISEXO_437273#120316, OT_BASRMB_437274#120317, OT_CDAM_437252#120318, OT_COCAL_437246#120319, OT_CODAPP_437320#120320, OT_CODBAS_437242#120321, OT_CODCHA_437241#120322, OT_CODITM_437306#120323, OT_CODLIS_437305#120324, OT_CODPER2_437316#120325, OT_CODPER3_437321#120326, OT_CODPER_437249#120327, OT_CODPRE_437298#120328, OT_CODSER_437250#120329, OT_CODSIT_437264#120330, OT_CODTIT_437322#120331, OT_CODUAM_437312#120332, OT_CODUTI_437265#120333, OT_COEFF_437245#120334, OT_COMPAR_437248#120335, OT_CR_437255#120336, OT_DATMAJ_437263#120337, OT_DENOMB_437303#120338, OT_DEPMNT_437308#120339, OT_FACTUR_437258#120340, OT_FAITLIT_437300#120341, OT_FERIE_437269#120342, OT_FLALD_437271#120343, OT_FLDIVISE_437297#120344, OT_FLID_437277#120345, OT_FLRMO_437266#120346, OT_FORC_437309#120347, OT_FORMAMC_437310#120348, OT_INDBAS_437256#120349, OT_INFTRA_437257#120350, OT_LATER_437318#120351, OT_LETADS_437317#120352, OT_LETTRE_437244#120353, OT_LIGRGR_437296#120354, OT_MAJOAGE_437299#120355, OT_MAJOFERIE_437270#120356, OT_MAJONUIT_437268#120357, OT_MONNAIE_437259#120358, OT_MTDEP_437313#120359, OT_MTPENHPS_437314#120360, OT_MTTID_437278#120361, OT_MTTIKM_437285#120362, OT_MTTIKS_437288#120363, OT_MTTIK_437281#120364, OT_MTTORI_437315#120365, OT_NBRIKM_437284#120366, OT_NBRIKS_437293#120367, OT_NBRIK_437294#120368, OT_NOMDOS_437254#120369, OT_NUIT_437267#120370, OT_NUMCOT_437235#120371, OT_NUMCOT_CCAM_437311#120372, OT_NUMDEM_437236#120373, OT_NUMDOS_437237#120374, OT_NUMERO_437261#120375, OT_NUMEXA_437319#120376, OT_NUMORD_437295#120377, OT_NUMPCO_437238#120378, OT_NUMSAL_437253#120379, OT_NUMTLI_437307#120380, OT_PARCAI_437276#120381, OT_PARMUT_437292#120382, OT_PLATRE_437247#120383, OT_PRIMAI_437239#120384, OT_PRIUNI_437302#120385, OT_QTEBAS_437251#120386, OT_QUALDP_437301#120387, OT_RATTAC_437243#120388, OT_TARIF_437260#120389, OT_TAUCAI_437275#120390, OT_TAUID_437279#120391, OT_TAUIKM_437286#120392, OT_TAUIKS_437289#120393, OT_TAUIK_437282#120394, OT_TAUMUT_437291#120395, OT_TYPEXO_437272#120396, OT_T_RED_437262#120397]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#120371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#120371)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#120373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#120373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#120374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#120374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#120378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#120378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#120384)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#120384)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#120315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#120315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#120322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#120322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#120321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#120321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#120388)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#120388)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#120353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#120353)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#120334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#120334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#120319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#120319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#120383)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#120383)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#120335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#120335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#120327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#120327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#120329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#120329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#120386)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#120386)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#120318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#120318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#120379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#120379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#120369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#120369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#120336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#120336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#120349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#120349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#120350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#120350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#120340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#120340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#120358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#120358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#120389)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#120389)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#120375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#120375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#120397)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#120397)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#120337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#120337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#120330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#120330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#120333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#120333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#120346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#120346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#120370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#120370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#120357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#120357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#120342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#120342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#120356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#120356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#120343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#120343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#120396)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#120396)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#120316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#120316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#120317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#120317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#120390)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#120390)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#120381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#120381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#120345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#120345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#120361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#120361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#120391)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#120391)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#120311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#120311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#120364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#120364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#120394)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#120394)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#120314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#120314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#120366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#120366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#120362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#120362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#120392)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#120392)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#120312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#120312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#120363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#120363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#120393)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#120393)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#120313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#120313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#120395)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#120395)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#120382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#120382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#120367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#120367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#120368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#120368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#120377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#120377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#120354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#120354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#120344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#120344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#120328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#120328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#120355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#120355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#120341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#120341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#120387)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#120387)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#120385)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#120385)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#120338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#120338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#120310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#120310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#120324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#120324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#120323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#120323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#120380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#120380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#120339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#120339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#120347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#120347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#120348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#120348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#120372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#120372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#120332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#120332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#120359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#120359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#120360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#120360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#120365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#120365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#120325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#120325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#120352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#120352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#120351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#120351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#120376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#120376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#120320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#120320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#120326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#120326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#120331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#120331)), MARX) END)

(4) Project [codegen id : 1]
Output: []
Input [88]: [OT_AMCID_437304#120310, OT_AMOID_437280#120311, OT_AMOIKM_437287#120312, OT_AMOIKS_437290#120313, OT_AMOIK_437283#120314, OT_ANNVAL_437240#120315, OT_AVISEXO_437273#120316, OT_BASRMB_437274#120317, OT_CDAM_437252#120318, OT_COCAL_437246#120319, OT_CODAPP_437320#120320, OT_CODBAS_437242#120321, OT_CODCHA_437241#120322, OT_CODITM_437306#120323, OT_CODLIS_437305#120324, OT_CODPER2_437316#120325, OT_CODPER3_437321#120326, OT_CODPER_437249#120327, OT_CODPRE_437298#120328, OT_CODSER_437250#120329, OT_CODSIT_437264#120330, OT_CODTIT_437322#120331, OT_CODUAM_437312#120332, OT_CODUTI_437265#120333, OT_COEFF_437245#120334, OT_COMPAR_437248#120335, OT_CR_437255#120336, OT_DATMAJ_437263#120337, OT_DENOMB_437303#120338, OT_DEPMNT_437308#120339, OT_FACTUR_437258#120340, OT_FAITLIT_437300#120341, OT_FERIE_437269#120342, OT_FLALD_437271#120343, OT_FLDIVISE_437297#120344, OT_FLID_437277#120345, OT_FLRMO_437266#120346, OT_FORC_437309#120347, OT_FORMAMC_437310#120348, OT_INDBAS_437256#120349, OT_INFTRA_437257#120350, OT_LATER_437318#120351, OT_LETADS_437317#120352, OT_LETTRE_437244#120353, OT_LIGRGR_437296#120354, OT_MAJOAGE_437299#120355, OT_MAJOFERIE_437270#120356, OT_MAJONUIT_437268#120357, OT_MONNAIE_437259#120358, OT_MTDEP_437313#120359, OT_MTPENHPS_437314#120360, OT_MTTID_437278#120361, OT_MTTIKM_437285#120362, OT_MTTIKS_437288#120363, OT_MTTIK_437281#120364, OT_MTTORI_437315#120365, OT_NBRIKM_437284#120366, OT_NBRIKS_437293#120367, OT_NBRIK_437294#120368, OT_NOMDOS_437254#120369, OT_NUIT_437267#120370, OT_NUMCOT_437235#120371, OT_NUMCOT_CCAM_437311#120372, OT_NUMDEM_437236#120373, OT_NUMDOS_437237#120374, OT_NUMERO_437261#120375, OT_NUMEXA_437319#120376, OT_NUMORD_437295#120377, OT_NUMPCO_437238#120378, OT_NUMSAL_437253#120379, OT_NUMTLI_437307#120380, OT_PARCAI_437276#120381, OT_PARMUT_437292#120382, OT_PLATRE_437247#120383, OT_PRIMAI_437239#120384, OT_PRIUNI_437302#120385, OT_QTEBAS_437251#120386, OT_QUALDP_437301#120387, OT_RATTAC_437243#120388, OT_TARIF_437260#120389, OT_TAUCAI_437275#120390, OT_TAUID_437279#120391, OT_TAUIKM_437286#120392, OT_TAUIKS_437289#120393, OT_TAUIK_437282#120394, OT_TAUMUT_437291#120395, OT_TYPEXO_437272#120396, OT_T_RED_437262#120397]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#121666L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#121563L]
Results [1]: [count(1)#121563L AS COL_46f3a712-e978-432b-b540-45a04bfc808e#121565L]

(9) Filter
Input [88]: [OT_AMCID_437304#120310, OT_AMOID_437280#120311, OT_AMOIKM_437287#120312, OT_AMOIKS_437290#120313, OT_AMOIK_437283#120314, OT_ANNVAL_437240#120315, OT_AVISEXO_437273#120316, OT_BASRMB_437274#120317, OT_CDAM_437252#120318, OT_COCAL_437246#120319, OT_CODAPP_437320#120320, OT_CODBAS_437242#120321, OT_CODCHA_437241#120322, OT_CODITM_437306#120323, OT_CODLIS_437305#120324, OT_CODPER2_437316#120325, OT_CODPER3_437321#120326, OT_CODPER_437249#120327, OT_CODPRE_437298#120328, OT_CODSER_437250#120329, OT_CODSIT_437264#120330, OT_CODTIT_437322#120331, OT_CODUAM_437312#120332, OT_CODUTI_437265#120333, OT_COEFF_437245#120334, OT_COMPAR_437248#120335, OT_CR_437255#120336, OT_DATMAJ_437263#120337, OT_DENOMB_437303#120338, OT_DEPMNT_437308#120339, OT_FACTUR_437258#120340, OT_FAITLIT_437300#120341, OT_FERIE_437269#120342, OT_FLALD_437271#120343, OT_FLDIVISE_437297#120344, OT_FLID_437277#120345, OT_FLRMO_437266#120346, OT_FORC_437309#120347, OT_FORMAMC_437310#120348, OT_INDBAS_437256#120349, OT_INFTRA_437257#120350, OT_LATER_437318#120351, OT_LETADS_437317#120352, OT_LETTRE_437244#120353, OT_LIGRGR_437296#120354, OT_MAJOAGE_437299#120355, OT_MAJOFERIE_437270#120356, OT_MAJONUIT_437268#120357, OT_MONNAIE_437259#120358, OT_MTDEP_437313#120359, OT_MTPENHPS_437314#120360, OT_MTTID_437278#120361, OT_MTTIKM_437285#120362, OT_MTTIKS_437288#120363, OT_MTTIK_437281#120364, OT_MTTORI_437315#120365, OT_NBRIKM_437284#120366, OT_NBRIKS_437293#120367, OT_NBRIK_437294#120368, OT_NOMDOS_437254#120369, OT_NUIT_437267#120370, OT_NUMCOT_437235#120371, OT_NUMCOT_CCAM_437311#120372, OT_NUMDEM_437236#120373, OT_NUMDOS_437237#120374, OT_NUMERO_437261#120375, OT_NUMEXA_437319#120376, OT_NUMORD_437295#120377, OT_NUMPCO_437238#120378, OT_NUMSAL_437253#120379, OT_NUMTLI_437307#120380, OT_PARCAI_437276#120381, OT_PARMUT_437292#120382, OT_PLATRE_437247#120383, OT_PRIMAI_437239#120384, OT_PRIUNI_437302#120385, OT_QTEBAS_437251#120386, OT_QUALDP_437301#120387, OT_RATTAC_437243#120388, OT_TARIF_437260#120389, OT_TAUCAI_437275#120390, OT_TAUID_437279#120391, OT_TAUIKM_437286#120392, OT_TAUIKS_437289#120393, OT_TAUIK_437282#120394, OT_TAUMUT_437291#120395, OT_TYPEXO_437272#120396, OT_T_RED_437262#120397]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#120371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#120371)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#120373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#120373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#120374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#120374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#120378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#120378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#120384)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#120384)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#120315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#120315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#120322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#120322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#120321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#120321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#120388)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#120388)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#120353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#120353)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#120334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#120334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#120319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#120319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#120383)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#120383)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#120335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#120335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#120327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#120327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#120329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#120329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#120386)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#120386)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#120318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#120318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#120379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#120379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#120369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#120369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#120336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#120336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#120349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#120349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#120350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#120350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#120340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#120340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#120358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#120358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#120389)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#120389)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#120375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#120375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#120397)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#120397)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#120337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#120337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#120330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#120330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#120333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#120333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#120346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#120346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#120370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#120370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#120357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#120357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#120342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#120342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#120356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#120356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#120343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#120343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#120396)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#120396)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#120316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#120316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#120317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#120317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#120390)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#120390)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#120381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#120381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#120345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#120345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#120361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#120361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#120391)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#120391)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#120311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#120311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#120364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#120364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#120394)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#120394)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#120314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#120314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#120366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#120366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#120362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#120362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#120392)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#120392)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#120312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#120312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#120363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#120363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#120393)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#120393)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#120313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#120313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#120395)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#120395)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#120382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#120382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#120367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#120367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#120368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#120368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#120377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#120377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#120354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#120354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#120344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#120344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#120328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#120328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#120355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#120355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#120341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#120341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#120387)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#120387)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#120385)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#120385)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#120338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#120338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#120310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#120310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#120324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#120324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#120323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#120323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#120380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#120380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#120339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#120339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#120347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#120347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#120348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#120348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#120372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#120372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#120332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#120332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#120359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#120359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#120360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#120360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#120365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#120365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#120325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#120325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#120352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#120352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#120351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#120351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#120376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#120376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#120320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#120320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#120326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#120326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#120331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#120331)), MARX) END)

(10) Project
Output: []
Input [88]: [OT_AMCID_437304#120310, OT_AMOID_437280#120311, OT_AMOIKM_437287#120312, OT_AMOIKS_437290#120313, OT_AMOIK_437283#120314, OT_ANNVAL_437240#120315, OT_AVISEXO_437273#120316, OT_BASRMB_437274#120317, OT_CDAM_437252#120318, OT_COCAL_437246#120319, OT_CODAPP_437320#120320, OT_CODBAS_437242#120321, OT_CODCHA_437241#120322, OT_CODITM_437306#120323, OT_CODLIS_437305#120324, OT_CODPER2_437316#120325, OT_CODPER3_437321#120326, OT_CODPER_437249#120327, OT_CODPRE_437298#120328, OT_CODSER_437250#120329, OT_CODSIT_437264#120330, OT_CODTIT_437322#120331, OT_CODUAM_437312#120332, OT_CODUTI_437265#120333, OT_COEFF_437245#120334, OT_COMPAR_437248#120335, OT_CR_437255#120336, OT_DATMAJ_437263#120337, OT_DENOMB_437303#120338, OT_DEPMNT_437308#120339, OT_FACTUR_437258#120340, OT_FAITLIT_437300#120341, OT_FERIE_437269#120342, OT_FLALD_437271#120343, OT_FLDIVISE_437297#120344, OT_FLID_437277#120345, OT_FLRMO_437266#120346, OT_FORC_437309#120347, OT_FORMAMC_437310#120348, OT_INDBAS_437256#120349, OT_INFTRA_437257#120350, OT_LATER_437318#120351, OT_LETADS_437317#120352, OT_LETTRE_437244#120353, OT_LIGRGR_437296#120354, OT_MAJOAGE_437299#120355, OT_MAJOFERIE_437270#120356, OT_MAJONUIT_437268#120357, OT_MONNAIE_437259#120358, OT_MTDEP_437313#120359, OT_MTPENHPS_437314#120360, OT_MTTID_437278#120361, OT_MTTIKM_437285#120362, OT_MTTIKS_437288#120363, OT_MTTIK_437281#120364, OT_MTTORI_437315#120365, OT_NBRIKM_437284#120366, OT_NBRIKS_437293#120367, OT_NBRIK_437294#120368, OT_NOMDOS_437254#120369, OT_NUIT_437267#120370, OT_NUMCOT_437235#120371, OT_NUMCOT_CCAM_437311#120372, OT_NUMDEM_437236#120373, OT_NUMDOS_437237#120374, OT_NUMERO_437261#120375, OT_NUMEXA_437319#120376, OT_NUMORD_437295#120377, OT_NUMPCO_437238#120378, OT_NUMSAL_437253#120379, OT_NUMTLI_437307#120380, OT_PARCAI_437276#120381, OT_PARMUT_437292#120382, OT_PLATRE_437247#120383, OT_PRIMAI_437239#120384, OT_PRIUNI_437302#120385, OT_QTEBAS_437251#120386, OT_QUALDP_437301#120387, OT_RATTAC_437243#120388, OT_TARIF_437260#120389, OT_TAUCAI_437275#120390, OT_TAUID_437279#120391, OT_TAUIKM_437286#120392, OT_TAUIKS_437289#120393, OT_TAUIK_437282#120394, OT_TAUMUT_437291#120395, OT_TYPEXO_437272#120396, OT_T_RED_437262#120397]

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

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

(13) HashAggregate
Input [1]: [count#121666L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#121563L]
Results [1]: [count(1)#121563L AS COL_46f3a712-e978-432b-b540-45a04bfc808e#121565L]

(14) AdaptiveSparkPlan
Output [1]: [COL_46f3a712-e978-432b-b540-45a04bfc808e#121565L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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