hdh-spark-job - Details for Query 755

Submitted Time: 2026/10/21 21:36:52
Duration: 7 s
Succeeded Jobs: 751 763

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: 6.1 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 6.1 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: 26 ms metadata time: 0 ms size of files read: 1605.3 KiB number of output rows: 50,890"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 9->8; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=15649]

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

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#169050)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#169050)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#169052)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#169052)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#169053)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#169053)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#169057)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#169057)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#169063)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#169063)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#168994)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#168994)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#169001)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#169001)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#169000)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#169000)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#169067)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#169067)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#169032)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#169032)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#169013)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#169013)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#168998)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#168998)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#169062)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#169062)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#169014)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#169014)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#169006)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#169006)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#169008)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#169008)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#169065)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#169065)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#168997)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#168997)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#169058)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#169058)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#169048)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#169048)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#169015)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#169015)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#169028)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#169028)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#169029)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#169029)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#169019)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#169019)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#169037)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#169037)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#169068)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#169068)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#169054)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#169054)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#169076)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#169076)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#169016)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#169016)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#169009)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#169009)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#169012)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#169012)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#169025)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#169025)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#169049)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#169049)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#169036)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#169036)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#169021)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#169021)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#169035)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#169035)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#169022)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#169022)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#169075)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#169075)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#168995)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#168995)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#168996)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#168996)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#169069)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#169069)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#169060)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#169060)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#169024)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#169024)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#169040)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#169040)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#169070)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#169070)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#168990)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#168990)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#169043)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#169043)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#169073)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#169073)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#168993)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#168993)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#169045)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#169045)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#169041)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#169041)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#169071)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#169071)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#168991)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#168991)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#169042)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#169042)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#169072)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#169072)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#168992)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#168992)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#169074)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#169074)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#169061)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#169061)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#169046)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#169046)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#169047)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#169047)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#169056)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#169056)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#169033)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#169033)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#169023)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#169023)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#169007)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#169007)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#169034)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#169034)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#169020)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#169020)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#169066)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#169066)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#169064)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#169064)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#169017)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#169017)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#168989)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#168989)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#169003)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#169003)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#169002)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#169002)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#169059)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#169059)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#169018)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#169018)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#169026)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#169026)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#169027)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#169027)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#169051)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#169051)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#169011)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#169011)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#169038)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#169038)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#169039)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#169039)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#169044)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#169044)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#169004)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#169004)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#169031)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#169031)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#169030)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#169030)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#169055)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#169055)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#168999)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#168999)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#169005)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#169005)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#169010)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#169010)), A63000893163) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [OT_AMCID_437304#168989,OT_AMOID_437280#168990,OT_AMOIKM_437287#168991,OT_AMOIKS_437290#168992,OT_AMOIK_437283#168993,OT_ANNVAL_437240#168994,OT_AVISEXO_437273#168995,OT_BASRMB_437274#168996,OT_CDAM_437252#168997,OT_COCAL_437246#168998,OT_CODAPP_437320#168999,OT_CODBAS_437242#169000,OT_CODCHA_437241#169001,OT_CODITM_437306#169002,OT_CODLIS_437305#169003,OT_CODPER2_437316#169004,OT_CODPER3_437321#169005,OT_CODPER_437249#169006,OT_CODPRE_437298#169007,OT_CODSER_437250#169008,OT_CODSIT_437264#169009,OT_CODTIT_437322#169010,OT_CODUAM_437312#169011,OT_CODUTI_437265#169012,... 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#168989, OT_AMOID_437280#168990, OT_AMOIKM_437287#168991, OT_AMOIKS_437290#168992, OT_AMOIK_437283#168993, OT_ANNVAL_437240#168994, OT_AVISEXO_437273#168995, OT_BASRMB_437274#168996, OT_CDAM_437252#168997, OT_COCAL_437246#168998, OT_CODAPP_437320#168999, OT_CODBAS_437242#169000, OT_CODCHA_437241#169001, OT_CODITM_437306#169002, OT_CODLIS_437305#169003, OT_CODPER2_437316#169004, OT_CODPER3_437321#169005, OT_CODPER_437249#169006, OT_CODPRE_437298#169007, OT_CODSER_437250#169008, OT_CODSIT_437264#169009, OT_CODTIT_437322#169010, OT_CODUAM_437312#169011, OT_CODUTI_437265#169012, OT_COEFF_437245#169013, OT_COMPAR_437248#169014, OT_CR_437255#169015, OT_DATMAJ_437263#169016, OT_DENOMB_437303#169017, OT_DEPMNT_437308#169018, OT_FACTUR_437258#169019, OT_FAITLIT_437300#169020, OT_FERIE_437269#169021, OT_FLALD_437271#169022, OT_FLDIVISE_437297#169023, OT_FLID_437277#169024, OT_FLRMO_437266#169025, OT_FORC_437309#169026, OT_FORMAMC_437310#169027, OT_INDBAS_437256#169028, OT_INFTRA_437257#169029, OT_LATER_437318#169030, OT_LETADS_437317#169031, OT_LETTRE_437244#169032, OT_LIGRGR_437296#169033, OT_MAJOAGE_437299#169034, OT_MAJOFERIE_437270#169035, OT_MAJONUIT_437268#169036, OT_MONNAIE_437259#169037, OT_MTDEP_437313#169038, OT_MTPENHPS_437314#169039, OT_MTTID_437278#169040, OT_MTTIKM_437285#169041, OT_MTTIKS_437288#169042, OT_MTTIK_437281#169043, OT_MTTORI_437315#169044, OT_NBRIKM_437284#169045, OT_NBRIKS_437293#169046, OT_NBRIK_437294#169047, OT_NOMDOS_437254#169048, OT_NUIT_437267#169049, OT_NUMCOT_437235#169050, OT_NUMCOT_CCAM_437311#169051, OT_NUMDEM_437236#169052, OT_NUMDOS_437237#169053, OT_NUMERO_437261#169054, OT_NUMEXA_437319#169055, OT_NUMORD_437295#169056, OT_NUMPCO_437238#169057, OT_NUMSAL_437253#169058, OT_NUMTLI_437307#169059, OT_PARCAI_437276#169060, OT_PARMUT_437292#169061, OT_PLATRE_437247#169062, OT_PRIMAI_437239#169063, OT_PRIUNI_437302#169064, OT_QTEBAS_437251#169065, OT_QUALDP_437301#169066, OT_RATTAC_437243#169067, OT_TARIF_437260#169068, OT_TAUCAI_437275#169069, OT_TAUID_437279#169070, OT_TAUIKM_437286#169071, OT_TAUIKS_437289#169072, OT_TAUIK_437282#169073, OT_TAUMUT_437291#169074, OT_TYPEXO_437272#169075, OT_T_RED_437262#169076]
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#168989, OT_AMOID_437280#168990, OT_AMOIKM_437287#168991, OT_AMOIKS_437290#168992, OT_AMOIK_437283#168993, OT_ANNVAL_437240#168994, OT_AVISEXO_437273#168995, OT_BASRMB_437274#168996, OT_CDAM_437252#168997, OT_COCAL_437246#168998, OT_CODAPP_437320#168999, OT_CODBAS_437242#169000, OT_CODCHA_437241#169001, OT_CODITM_437306#169002, OT_CODLIS_437305#169003, OT_CODPER2_437316#169004, OT_CODPER3_437321#169005, OT_CODPER_437249#169006, OT_CODPRE_437298#169007, OT_CODSER_437250#169008, OT_CODSIT_437264#169009, OT_CODTIT_437322#169010, OT_CODUAM_437312#169011, OT_CODUTI_437265#169012, OT_COEFF_437245#169013, OT_COMPAR_437248#169014, OT_CR_437255#169015, OT_DATMAJ_437263#169016, OT_DENOMB_437303#169017, OT_DEPMNT_437308#169018, OT_FACTUR_437258#169019, OT_FAITLIT_437300#169020, OT_FERIE_437269#169021, OT_FLALD_437271#169022, OT_FLDIVISE_437297#169023, OT_FLID_437277#169024, OT_FLRMO_437266#169025, OT_FORC_437309#169026, OT_FORMAMC_437310#169027, OT_INDBAS_437256#169028, OT_INFTRA_437257#169029, OT_LATER_437318#169030, OT_LETADS_437317#169031, OT_LETTRE_437244#169032, OT_LIGRGR_437296#169033, OT_MAJOAGE_437299#169034, OT_MAJOFERIE_437270#169035, OT_MAJONUIT_437268#169036, OT_MONNAIE_437259#169037, OT_MTDEP_437313#169038, OT_MTPENHPS_437314#169039, OT_MTTID_437278#169040, OT_MTTIKM_437285#169041, OT_MTTIKS_437288#169042, OT_MTTIK_437281#169043, OT_MTTORI_437315#169044, OT_NBRIKM_437284#169045, OT_NBRIKS_437293#169046, OT_NBRIK_437294#169047, OT_NOMDOS_437254#169048, OT_NUIT_437267#169049, OT_NUMCOT_437235#169050, OT_NUMCOT_CCAM_437311#169051, OT_NUMDEM_437236#169052, OT_NUMDOS_437237#169053, OT_NUMERO_437261#169054, OT_NUMEXA_437319#169055, OT_NUMORD_437295#169056, OT_NUMPCO_437238#169057, OT_NUMSAL_437253#169058, OT_NUMTLI_437307#169059, OT_PARCAI_437276#169060, OT_PARMUT_437292#169061, OT_PLATRE_437247#169062, OT_PRIMAI_437239#169063, OT_PRIUNI_437302#169064, OT_QTEBAS_437251#169065, OT_QUALDP_437301#169066, OT_RATTAC_437243#169067, OT_TARIF_437260#169068, OT_TAUCAI_437275#169069, OT_TAUID_437279#169070, OT_TAUIKM_437286#169071, OT_TAUIKS_437289#169072, OT_TAUIK_437282#169073, OT_TAUMUT_437291#169074, OT_TYPEXO_437272#169075, OT_T_RED_437262#169076]

(3) Filter [codegen id : 1]
Input [88]: [OT_AMCID_437304#168989, OT_AMOID_437280#168990, OT_AMOIKM_437287#168991, OT_AMOIKS_437290#168992, OT_AMOIK_437283#168993, OT_ANNVAL_437240#168994, OT_AVISEXO_437273#168995, OT_BASRMB_437274#168996, OT_CDAM_437252#168997, OT_COCAL_437246#168998, OT_CODAPP_437320#168999, OT_CODBAS_437242#169000, OT_CODCHA_437241#169001, OT_CODITM_437306#169002, OT_CODLIS_437305#169003, OT_CODPER2_437316#169004, OT_CODPER3_437321#169005, OT_CODPER_437249#169006, OT_CODPRE_437298#169007, OT_CODSER_437250#169008, OT_CODSIT_437264#169009, OT_CODTIT_437322#169010, OT_CODUAM_437312#169011, OT_CODUTI_437265#169012, OT_COEFF_437245#169013, OT_COMPAR_437248#169014, OT_CR_437255#169015, OT_DATMAJ_437263#169016, OT_DENOMB_437303#169017, OT_DEPMNT_437308#169018, OT_FACTUR_437258#169019, OT_FAITLIT_437300#169020, OT_FERIE_437269#169021, OT_FLALD_437271#169022, OT_FLDIVISE_437297#169023, OT_FLID_437277#169024, OT_FLRMO_437266#169025, OT_FORC_437309#169026, OT_FORMAMC_437310#169027, OT_INDBAS_437256#169028, OT_INFTRA_437257#169029, OT_LATER_437318#169030, OT_LETADS_437317#169031, OT_LETTRE_437244#169032, OT_LIGRGR_437296#169033, OT_MAJOAGE_437299#169034, OT_MAJOFERIE_437270#169035, OT_MAJONUIT_437268#169036, OT_MONNAIE_437259#169037, OT_MTDEP_437313#169038, OT_MTPENHPS_437314#169039, OT_MTTID_437278#169040, OT_MTTIKM_437285#169041, OT_MTTIKS_437288#169042, OT_MTTIK_437281#169043, OT_MTTORI_437315#169044, OT_NBRIKM_437284#169045, OT_NBRIKS_437293#169046, OT_NBRIK_437294#169047, OT_NOMDOS_437254#169048, OT_NUIT_437267#169049, OT_NUMCOT_437235#169050, OT_NUMCOT_CCAM_437311#169051, OT_NUMDEM_437236#169052, OT_NUMDOS_437237#169053, OT_NUMERO_437261#169054, OT_NUMEXA_437319#169055, OT_NUMORD_437295#169056, OT_NUMPCO_437238#169057, OT_NUMSAL_437253#169058, OT_NUMTLI_437307#169059, OT_PARCAI_437276#169060, OT_PARMUT_437292#169061, OT_PLATRE_437247#169062, OT_PRIMAI_437239#169063, OT_PRIUNI_437302#169064, OT_QTEBAS_437251#169065, OT_QUALDP_437301#169066, OT_RATTAC_437243#169067, OT_TARIF_437260#169068, OT_TAUCAI_437275#169069, OT_TAUID_437279#169070, OT_TAUIKM_437286#169071, OT_TAUIKS_437289#169072, OT_TAUIK_437282#169073, OT_TAUMUT_437291#169074, OT_TYPEXO_437272#169075, OT_T_RED_437262#169076]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#169050)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#169050)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#169052)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#169052)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#169053)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#169053)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#169057)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#169057)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#169063)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#169063)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#168994)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#168994)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#169001)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#169001)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#169000)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#169000)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#169067)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#169067)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#169032)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#169032)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#169013)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#169013)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#168998)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#168998)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#169062)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#169062)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#169014)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#169014)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#169006)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#169006)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#169008)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#169008)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#169065)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#169065)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#168997)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#168997)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#169058)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#169058)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#169048)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#169048)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#169015)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#169015)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#169028)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#169028)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#169029)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#169029)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#169019)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#169019)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#169037)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#169037)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#169068)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#169068)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#169054)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#169054)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#169076)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#169076)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#169016)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#169016)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#169009)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#169009)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#169012)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#169012)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#169025)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#169025)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#169049)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#169049)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#169036)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#169036)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#169021)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#169021)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#169035)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#169035)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#169022)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#169022)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#169075)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#169075)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#168995)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#168995)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#168996)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#168996)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#169069)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#169069)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#169060)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#169060)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#169024)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#169024)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#169040)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#169040)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#169070)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#169070)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#168990)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#168990)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#169043)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#169043)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#169073)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#169073)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#168993)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#168993)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#169045)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#169045)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#169041)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#169041)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#169071)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#169071)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#168991)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#168991)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#169042)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#169042)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#169072)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#169072)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#168992)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#168992)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#169074)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#169074)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#169061)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#169061)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#169046)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#169046)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#169047)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#169047)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#169056)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#169056)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#169033)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#169033)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#169023)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#169023)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#169007)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#169007)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#169034)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#169034)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#169020)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#169020)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#169066)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#169066)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#169064)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#169064)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#169017)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#169017)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#168989)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#168989)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#169003)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#169003)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#169002)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#169002)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#169059)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#169059)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#169018)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#169018)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#169026)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#169026)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#169027)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#169027)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#169051)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#169051)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#169011)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#169011)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#169038)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#169038)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#169039)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#169039)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#169044)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#169044)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#169004)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#169004)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#169031)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#169031)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#169030)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#169030)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#169055)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#169055)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#168999)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#168999)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#169005)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#169005)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#169010)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#169010)), A63000893163) END)

(4) Project [codegen id : 1]
Output: []
Input [88]: [OT_AMCID_437304#168989, OT_AMOID_437280#168990, OT_AMOIKM_437287#168991, OT_AMOIKS_437290#168992, OT_AMOIK_437283#168993, OT_ANNVAL_437240#168994, OT_AVISEXO_437273#168995, OT_BASRMB_437274#168996, OT_CDAM_437252#168997, OT_COCAL_437246#168998, OT_CODAPP_437320#168999, OT_CODBAS_437242#169000, OT_CODCHA_437241#169001, OT_CODITM_437306#169002, OT_CODLIS_437305#169003, OT_CODPER2_437316#169004, OT_CODPER3_437321#169005, OT_CODPER_437249#169006, OT_CODPRE_437298#169007, OT_CODSER_437250#169008, OT_CODSIT_437264#169009, OT_CODTIT_437322#169010, OT_CODUAM_437312#169011, OT_CODUTI_437265#169012, OT_COEFF_437245#169013, OT_COMPAR_437248#169014, OT_CR_437255#169015, OT_DATMAJ_437263#169016, OT_DENOMB_437303#169017, OT_DEPMNT_437308#169018, OT_FACTUR_437258#169019, OT_FAITLIT_437300#169020, OT_FERIE_437269#169021, OT_FLALD_437271#169022, OT_FLDIVISE_437297#169023, OT_FLID_437277#169024, OT_FLRMO_437266#169025, OT_FORC_437309#169026, OT_FORMAMC_437310#169027, OT_INDBAS_437256#169028, OT_INFTRA_437257#169029, OT_LATER_437318#169030, OT_LETADS_437317#169031, OT_LETTRE_437244#169032, OT_LIGRGR_437296#169033, OT_MAJOAGE_437299#169034, OT_MAJOFERIE_437270#169035, OT_MAJONUIT_437268#169036, OT_MONNAIE_437259#169037, OT_MTDEP_437313#169038, OT_MTPENHPS_437314#169039, OT_MTTID_437278#169040, OT_MTTIKM_437285#169041, OT_MTTIKS_437288#169042, OT_MTTIK_437281#169043, OT_MTTORI_437315#169044, OT_NBRIKM_437284#169045, OT_NBRIKS_437293#169046, OT_NBRIK_437294#169047, OT_NOMDOS_437254#169048, OT_NUIT_437267#169049, OT_NUMCOT_437235#169050, OT_NUMCOT_CCAM_437311#169051, OT_NUMDEM_437236#169052, OT_NUMDOS_437237#169053, OT_NUMERO_437261#169054, OT_NUMEXA_437319#169055, OT_NUMORD_437295#169056, OT_NUMPCO_437238#169057, OT_NUMSAL_437253#169058, OT_NUMTLI_437307#169059, OT_PARCAI_437276#169060, OT_PARMUT_437292#169061, OT_PLATRE_437247#169062, OT_PRIMAI_437239#169063, OT_PRIUNI_437302#169064, OT_QTEBAS_437251#169065, OT_QUALDP_437301#169066, OT_RATTAC_437243#169067, OT_TARIF_437260#169068, OT_TAUCAI_437275#169069, OT_TAUID_437279#169070, OT_TAUIKM_437286#169071, OT_TAUIKS_437289#169072, OT_TAUIK_437282#169073, OT_TAUMUT_437291#169074, OT_TYPEXO_437272#169075, OT_T_RED_437262#169076]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#170080L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#169722L]
Results [1]: [count(1)#169722L AS COL_d7150938-f80a-4f6a-9193-8b116dc287c9#169724L]

(9) Filter
Input [88]: [OT_AMCID_437304#168989, OT_AMOID_437280#168990, OT_AMOIKM_437287#168991, OT_AMOIKS_437290#168992, OT_AMOIK_437283#168993, OT_ANNVAL_437240#168994, OT_AVISEXO_437273#168995, OT_BASRMB_437274#168996, OT_CDAM_437252#168997, OT_COCAL_437246#168998, OT_CODAPP_437320#168999, OT_CODBAS_437242#169000, OT_CODCHA_437241#169001, OT_CODITM_437306#169002, OT_CODLIS_437305#169003, OT_CODPER2_437316#169004, OT_CODPER3_437321#169005, OT_CODPER_437249#169006, OT_CODPRE_437298#169007, OT_CODSER_437250#169008, OT_CODSIT_437264#169009, OT_CODTIT_437322#169010, OT_CODUAM_437312#169011, OT_CODUTI_437265#169012, OT_COEFF_437245#169013, OT_COMPAR_437248#169014, OT_CR_437255#169015, OT_DATMAJ_437263#169016, OT_DENOMB_437303#169017, OT_DEPMNT_437308#169018, OT_FACTUR_437258#169019, OT_FAITLIT_437300#169020, OT_FERIE_437269#169021, OT_FLALD_437271#169022, OT_FLDIVISE_437297#169023, OT_FLID_437277#169024, OT_FLRMO_437266#169025, OT_FORC_437309#169026, OT_FORMAMC_437310#169027, OT_INDBAS_437256#169028, OT_INFTRA_437257#169029, OT_LATER_437318#169030, OT_LETADS_437317#169031, OT_LETTRE_437244#169032, OT_LIGRGR_437296#169033, OT_MAJOAGE_437299#169034, OT_MAJOFERIE_437270#169035, OT_MAJONUIT_437268#169036, OT_MONNAIE_437259#169037, OT_MTDEP_437313#169038, OT_MTPENHPS_437314#169039, OT_MTTID_437278#169040, OT_MTTIKM_437285#169041, OT_MTTIKS_437288#169042, OT_MTTIK_437281#169043, OT_MTTORI_437315#169044, OT_NBRIKM_437284#169045, OT_NBRIKS_437293#169046, OT_NBRIK_437294#169047, OT_NOMDOS_437254#169048, OT_NUIT_437267#169049, OT_NUMCOT_437235#169050, OT_NUMCOT_CCAM_437311#169051, OT_NUMDEM_437236#169052, OT_NUMDOS_437237#169053, OT_NUMERO_437261#169054, OT_NUMEXA_437319#169055, OT_NUMORD_437295#169056, OT_NUMPCO_437238#169057, OT_NUMSAL_437253#169058, OT_NUMTLI_437307#169059, OT_PARCAI_437276#169060, OT_PARMUT_437292#169061, OT_PLATRE_437247#169062, OT_PRIMAI_437239#169063, OT_PRIUNI_437302#169064, OT_QTEBAS_437251#169065, OT_QUALDP_437301#169066, OT_RATTAC_437243#169067, OT_TARIF_437260#169068, OT_TAUCAI_437275#169069, OT_TAUID_437279#169070, OT_TAUIKM_437286#169071, OT_TAUIKS_437289#169072, OT_TAUIK_437282#169073, OT_TAUMUT_437291#169074, OT_TYPEXO_437272#169075, OT_T_RED_437262#169076]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_437235#169050)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_437235#169050)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDEM_437236#169052)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDEM_437236#169052)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMDOS_437237#169053)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMDOS_437237#169053)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMPCO_437238#169057)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMPCO_437238#169057)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIMAI_437239#169063)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIMAI_437239#169063)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_ANNVAL_437240#168994)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_ANNVAL_437240#168994)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODCHA_437241#169001)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODCHA_437241#169001)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODBAS_437242#169000)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODBAS_437242#169000)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_RATTAC_437243#169067)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_RATTAC_437243#169067)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETTRE_437244#169032)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETTRE_437244#169032)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COEFF_437245#169013)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_COEFF_437245#169013)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COCAL_437246#168998)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_COCAL_437246#168998)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PLATRE_437247#169062)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PLATRE_437247#169062)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_COMPAR_437248#169014)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_COMPAR_437248#169014)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER_437249#169006)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER_437249#169006)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSER_437250#169008)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSER_437250#169008)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QTEBAS_437251#169065)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_QTEBAS_437251#169065)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CDAM_437252#168997)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CDAM_437252#168997)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMSAL_437253#169058)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMSAL_437253#169058)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NOMDOS_437254#169048)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NOMDOS_437254#169048)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CR_437255#169015)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CR_437255#169015)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INDBAS_437256#169028)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_INDBAS_437256#169028)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_INFTRA_437257#169029)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_INFTRA_437257#169029)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FACTUR_437258#169019)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FACTUR_437258#169019)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MONNAIE_437259#169037)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MONNAIE_437259#169037)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TARIF_437260#169068)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TARIF_437260#169068)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMERO_437261#169054)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMERO_437261#169054)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_T_RED_437262#169076)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_T_RED_437262#169076)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DATMAJ_437263#169016)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_DATMAJ_437263#169016)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODSIT_437264#169009)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODSIT_437264#169009)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUTI_437265#169012)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUTI_437265#169012)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLRMO_437266#169025)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLRMO_437266#169025)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUIT_437267#169049)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUIT_437267#169049)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJONUIT_437268#169036)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJONUIT_437268#169036)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FERIE_437269#169021)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FERIE_437269#169021)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#169035)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOFERIE_437270#169035)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLALD_437271#169022)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLALD_437271#169022)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TYPEXO_437272#169075)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TYPEXO_437272#169075)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AVISEXO_437273#168995)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AVISEXO_437273#168995)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_BASRMB_437274#168996)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_BASRMB_437274#168996)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUCAI_437275#169069)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUCAI_437275#169069)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARCAI_437276#169060)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARCAI_437276#169060)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLID_437277#169024)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLID_437277#169024)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTID_437278#169040)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTID_437278#169040)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUID_437279#169070)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUID_437279#169070)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOID_437280#168990)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOID_437280#168990)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIK_437281#169043)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIK_437281#169043)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIK_437282#169073)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIK_437282#169073)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIK_437283#168993)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIK_437283#168993)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKM_437284#169045)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKM_437284#169045)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKM_437285#169041)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKM_437285#169041)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKM_437286#169071)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKM_437286#169071)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKM_437287#168991)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKM_437287#168991)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTIKS_437288#169042)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTIKS_437288#169042)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUIKS_437289#169072)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUIKS_437289#169072)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMOIKS_437290#168992)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMOIKS_437290#168992)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_TAUMUT_437291#169074)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_TAUMUT_437291#169074)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PARMUT_437292#169061)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PARMUT_437292#169061)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIKS_437293#169046)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIKS_437293#169046)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NBRIK_437294#169047)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NBRIK_437294#169047)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMORD_437295#169056)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMORD_437295#169056)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LIGRGR_437296#169033)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LIGRGR_437296#169033)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FLDIVISE_437297#169023)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FLDIVISE_437297#169023)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPRE_437298#169007)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPRE_437298#169007)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MAJOAGE_437299#169034)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MAJOAGE_437299#169034)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FAITLIT_437300#169020)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FAITLIT_437300#169020)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_QUALDP_437301#169066)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_QUALDP_437301#169066)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_PRIUNI_437302#169064)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_PRIUNI_437302#169064)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DENOMB_437303#169017)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_DENOMB_437303#169017)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_AMCID_437304#168989)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_AMCID_437304#168989)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODLIS_437305#169003)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODLIS_437305#169003)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODITM_437306#169002)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODITM_437306#169002)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMTLI_437307#169059)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMTLI_437307#169059)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_DEPMNT_437308#169018)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_DEPMNT_437308#169018)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORC_437309#169026)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORC_437309#169026)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_FORMAMC_437310#169027)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_FORMAMC_437310#169027)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#169051)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMCOT_CCAM_437311#169051)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODUAM_437312#169011)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODUAM_437312#169011)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTDEP_437313#169038)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTDEP_437313#169038)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTPENHPS_437314#169039)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTPENHPS_437314#169039)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_MTTORI_437315#169044)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_MTTORI_437315#169044)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER2_437316#169004)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER2_437316#169004)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LETADS_437317#169031)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LETADS_437317#169031)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_LATER_437318#169030)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_LATER_437318#169030)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_NUMEXA_437319#169055)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_NUMEXA_437319#169055)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODAPP_437320#168999)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODAPP_437320#168999)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODPER3_437321#169005)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODPER3_437321#169005)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(OT_CODTIT_437322#169010)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(OT_CODTIT_437322#169010)), A63000893163) END)

(10) Project
Output: []
Input [88]: [OT_AMCID_437304#168989, OT_AMOID_437280#168990, OT_AMOIKM_437287#168991, OT_AMOIKS_437290#168992, OT_AMOIK_437283#168993, OT_ANNVAL_437240#168994, OT_AVISEXO_437273#168995, OT_BASRMB_437274#168996, OT_CDAM_437252#168997, OT_COCAL_437246#168998, OT_CODAPP_437320#168999, OT_CODBAS_437242#169000, OT_CODCHA_437241#169001, OT_CODITM_437306#169002, OT_CODLIS_437305#169003, OT_CODPER2_437316#169004, OT_CODPER3_437321#169005, OT_CODPER_437249#169006, OT_CODPRE_437298#169007, OT_CODSER_437250#169008, OT_CODSIT_437264#169009, OT_CODTIT_437322#169010, OT_CODUAM_437312#169011, OT_CODUTI_437265#169012, OT_COEFF_437245#169013, OT_COMPAR_437248#169014, OT_CR_437255#169015, OT_DATMAJ_437263#169016, OT_DENOMB_437303#169017, OT_DEPMNT_437308#169018, OT_FACTUR_437258#169019, OT_FAITLIT_437300#169020, OT_FERIE_437269#169021, OT_FLALD_437271#169022, OT_FLDIVISE_437297#169023, OT_FLID_437277#169024, OT_FLRMO_437266#169025, OT_FORC_437309#169026, OT_FORMAMC_437310#169027, OT_INDBAS_437256#169028, OT_INFTRA_437257#169029, OT_LATER_437318#169030, OT_LETADS_437317#169031, OT_LETTRE_437244#169032, OT_LIGRGR_437296#169033, OT_MAJOAGE_437299#169034, OT_MAJOFERIE_437270#169035, OT_MAJONUIT_437268#169036, OT_MONNAIE_437259#169037, OT_MTDEP_437313#169038, OT_MTPENHPS_437314#169039, OT_MTTID_437278#169040, OT_MTTIKM_437285#169041, OT_MTTIKS_437288#169042, OT_MTTIK_437281#169043, OT_MTTORI_437315#169044, OT_NBRIKM_437284#169045, OT_NBRIKS_437293#169046, OT_NBRIK_437294#169047, OT_NOMDOS_437254#169048, OT_NUIT_437267#169049, OT_NUMCOT_437235#169050, OT_NUMCOT_CCAM_437311#169051, OT_NUMDEM_437236#169052, OT_NUMDOS_437237#169053, OT_NUMERO_437261#169054, OT_NUMEXA_437319#169055, OT_NUMORD_437295#169056, OT_NUMPCO_437238#169057, OT_NUMSAL_437253#169058, OT_NUMTLI_437307#169059, OT_PARCAI_437276#169060, OT_PARMUT_437292#169061, OT_PLATRE_437247#169062, OT_PRIMAI_437239#169063, OT_PRIUNI_437302#169064, OT_QTEBAS_437251#169065, OT_QUALDP_437301#169066, OT_RATTAC_437243#169067, OT_TARIF_437260#169068, OT_TAUCAI_437275#169069, OT_TAUID_437279#169070, OT_TAUIKM_437286#169071, OT_TAUIKS_437289#169072, OT_TAUIK_437282#169073, OT_TAUMUT_437291#169074, OT_TYPEXO_437272#169075, OT_T_RED_437262#169076]

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

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

(13) HashAggregate
Input [1]: [count#170080L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#169722L]
Results [1]: [count(1)#169722L AS COL_d7150938-f80a-4f6a-9193-8b116dc287c9#169724L]

(14) AdaptiveSparkPlan
Output [1]: [COL_d7150938-f80a-4f6a-9193-8b116dc287c9#169724L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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