hdh-spark-job - Details for Query 1169

Submitted Time: 2026/10/23 11:55:14
Duration: 2 s
Succeeded Jobs: 1170 1173

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 (4)\n \nduration: 6 ms"; 2 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 64.2 MiB number of output rows: 3 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 3 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 2.2 KiB number of coalesced partitions: 1"]; 4 [labelType="html" label="Exchange shuffle records written: 6 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 1 ms (0 ms, 0 ms, 0 ms (stage 1612.0: task 1437)) 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: 6 local bytes read: 2.1 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 4.7 KiB (2.3 KiB, 2.3 KiB, 2.3 KiB (stage 1612.0: task 1436)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 2.1 KiB (1057.0 B, 1057.0 B, 1057.0 B (stage 1612.0: task 1436))"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.6 s (783 ms, 790 ms, 790 ms (stage 1612.0: task 1437))"; 6 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1.5 s (768 ms, 771 ms, 771 ms (stage 1612.0: task 1437)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1612.0: task 1436)) number of output rows: 6 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 1612.0: task 1436))"]; } 7 [labelType="html" label=" Union "]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 782 ms"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 3"]; 11 [labelType="html" label="Scan JDBCRelation((SELECT \"al_codval\", \"al_annval\", \"al_valcou\", \"al_lib30\", \"al_libmaj\", \"al_taux\", \"al_prior\", \"al_type\", \"al_datmaj\", \"al_coduti\", \"al_codsit\", \"al_monnaie\", \"al_typexa\", \"al_numbmp\", \"al_ordre\", \"al_letadm\", \"al_envadm\", \"al_t_red\", \"al_taux_r\", \"al_forfai\", \"al_classe\", \"al_revers\", \"al_rembours\", \"al_taux_t1\", \"al_taux_t2\", \"al_taux_t3\", \"al_taux_t4\", \"al_taux_t5\", \"al_taux_t6\", \"al_taux_t7\", \"al_taux_t8\", \"al_taux_t9\", \"al_taux_t1r\", \"al_taux_t2r\", \"al_taux_t3r\", \"al_taux_t4r\", \"al_taux_t5r\", \"al_taux_t6r\", \"al_taux_t7r\", \"al_taux_t8r\", \"al_taux_t9r\", \"al_flsej\", \"al_flicpt\", \"al_datede\", \"al_numcpt\", \"al_comment\", \"al_fltele\", \"al_codcha\", \"al_letads\", \"al_sites\", \"al_urg\", \"al_int_std\", \"al_int_spe\", \"al_spl_trans\", \"al_rcp\", \"al_datefi\", \"al_primai\", \"al_icd\", \"al_type_icd\" FROM \"xplore\".\"h_valeu\") as x) [numPartitions=1] number of output rows: 9,180"]; } subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 790 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Filter number of output rows: 3"]; 15 [labelType="html" label="Scan JDBCRelation((SELECT \"al_codval\", \"al_annval\", \"al_valcou\", \"al_lib30\", \"al_libmaj\", \"al_taux\", \"al_prior\", \"al_type\", \"al_datmaj\", \"al_coduti\", \"al_codsit\", \"al_monnaie\", \"al_typexa\", \"al_numbmp\", \"al_ordre\", \"al_letadm\", \"al_envadm\", \"al_t_red\", \"al_taux_r\", \"al_forfai\", \"al_classe\", \"al_revers\", \"al_rembours\", \"al_taux_t1\", \"al_taux_t2\", \"al_taux_t3\", \"al_taux_t4\", \"al_taux_t5\", \"al_taux_t6\", \"al_taux_t7\", \"al_taux_t8\", \"al_taux_t9\", \"al_taux_t1r\", \"al_taux_t2r\", \"al_taux_t3r\", \"al_taux_t4r\", \"al_taux_t5r\", \"al_taux_t6r\", \"al_taux_t7r\", \"al_taux_t8r\", \"al_taux_t9r\", \"al_flsej\", \"al_flicpt\", \"al_datede\", \"al_numcpt\", \"al_comment\", \"al_fltele\", \"al_codcha\", \"al_letads\", \"al_sites\", \"al_urg\", \"al_int_std\", \"al_int_spe\", \"al_spl_trans\", \"al_rcp\", \"al_datefi\", \"al_primai\", \"al_icd\", \"al_type_icd\" FROM \"xplore2\".\"h_valeu\") as x) [numPartitions=1] number of output rows: 9,180"]; } 2->0; 3->2; 4->3; 6->4; 7->6; 9->7; 10->9; 11->10; 13->7; 14->13; 15->14; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26780]

WholeStageCodegen (3)

Union

Project [al_annval#440235 AS AL_ANNVAL_438378#440647, al_classe#440254 AS AL_CLASSE_438397#440648, al_codcha#440281 AS AL_CODCHA_438424#440649, al_codsit#440244 AS AL_CODSIT_438387#440650, al_coduti#440243 AS AL_CODUTI_438386#440651, al_codval#440234 AS AL_CODVAL_438377#440652, al_comment#440279 AS AL_COMMENT_438422#440653, al_datede#440277 AS AL_DATEDE_438420#440654, al_datefi#440289 AS AL_DATEFI_438432#440655, al_datmaj#440242 AS AL_DATMAJ_438385#440656, al_envadm#440250 AS AL_ENVADM_438393#440657, al_flicpt#440276 AS AL_FLICPT_438419#440658, al_flsej#440275 AS AL_FLSEJ_438418#440659, al_fltele#440280 AS AL_FLTELE_438423#440660, al_forfai#440253 AS AL_FORFAI_438396#440661, al_icd#440291 AS AL_ICD_438434#440662, al_int_spe#440286 AS AL_INT_SPE_438429#440663, al_int_std#440285 AS AL_INT_STD_438428#440664, al_letadm#440249 AS AL_LETADM_438392#440665, al_letads#440282 AS AL_LETADS_438425#440666, al_lib30#440237 AS AL_LIB30_438380#440667, al_libmaj#440238 AS AL_LIBMAJ_438381#440668, al_monnaie#440245 AS AL_MONNAIE_438388#440669, al_numbmp#440247 AS AL_NUMBMP_438390#440670, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#440234)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#440234)), MOB) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#440235)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#440235)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#440236)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#440236)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#440237)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#440237)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#440238)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#440238)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#440239)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#440239)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#440240)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#440240)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#440241)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type#440241)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#440242)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#440242)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#440243)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#440243)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#440244)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#440244)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#440245)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#440245)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#440246)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#440246)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#440247)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#440247)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#440248)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#440248)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#440249)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#440249)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#440250)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#440250)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#440251)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#440251)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#440252)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#440252)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#440253)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#440253)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#440254)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#440254)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#440255)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#440255)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#440256)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#440256)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#440257)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#440257)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#440258)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#440258)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#440259)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#440259)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#440260)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#440260)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#440261)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#440261)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#440262)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#440262)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#440263)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#440263)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#440264)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#440264)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#440265)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#440265)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#440266)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#440266)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#440267)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#440267)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#440268)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#440268)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#440269)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#440269)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#440270)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#440270)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#440271)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#440271)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#440272)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#440272)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#440273)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#440273)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#440274)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#440274)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#440275)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#440275)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#440276)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#440276)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#440277)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#440277)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#440278)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#440278)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#440279)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#440279)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#440280)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#440280)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#440281)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#440281)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#440282)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#440282)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#440283)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#440283)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#440284)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#440284)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#440285)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#440285)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#440286)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#440286)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#440287)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#440287)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#440288)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#440288)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#440289)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#440289)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#440290)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#440290)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#440291)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#440291)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#440292)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#440292)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MOB)) THEN false ELSE Contains(str_remove_accent(null), MOB) END)

Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1] [al_annval#440235,al_classe#440254,al_codcha#440281,al_codsit#440244,al_coduti#440243,al_codval#440234,al_comment#440279,al_datede#440277,al_datefi#440289,al_datmaj#440242,al_envadm#440250,al_flicpt#440276,al_flsej#440275,al_fltele#440280,al_forfai#440253,al_icd#440291,al_int_spe#440286,al_int_std#440285,al_letadm#440249,al_letads#440282,al_lib30#440237,al_libmaj#440238,al_monnaie#440245,al_numbmp#440247,... 35 more fields] PushedFilters: [], ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_co...

WholeStageCodegen (1)

Project [al_annval#440768 AS AL_ANNVAL_438378#441180, al_classe#440787 AS AL_CLASSE_438397#441181, al_codcha#440814 AS AL_CODCHA_438424#441182, al_codsit#440777 AS AL_CODSIT_438387#441183, al_coduti#440776 AS AL_CODUTI_438386#441184, al_codval#440767 AS AL_CODVAL_438377#441185, al_comment#440812 AS AL_COMMENT_438422#441186, al_datede#440810 AS AL_DATEDE_438420#441187, al_datefi#440822 AS AL_DATEFI_438432#441188, al_datmaj#440775 AS AL_DATMAJ_438385#441189, al_envadm#440783 AS AL_ENVADM_438393#441190, al_flicpt#440809 AS AL_FLICPT_438419#441191, al_flsej#440808 AS AL_FLSEJ_438418#441192, al_fltele#440813 AS AL_FLTELE_438423#441193, al_forfai#440786 AS AL_FORFAI_438396#441194, al_icd#440824 AS AL_ICD_438434#441195, al_int_spe#440819 AS AL_INT_SPE_438429#441196, al_int_std#440818 AS AL_INT_STD_438428#441197, al_letadm#440782 AS AL_LETADM_438392#441198, al_letads#440815 AS AL_LETADS_438425#441199, al_lib30#440770 AS AL_LIB30_438380#441200, al_libmaj#440771 AS AL_LIBMAJ_438381#441201, al_monnaie#440778 AS AL_MONNAIE_438388#441202, al_numbmp#440780 AS AL_NUMBMP_438390#441203, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#440767)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#440767)), MOB) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#440768)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#440768)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#440769)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#440769)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#440770)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#440770)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#440771)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#440771)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#440772)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#440772)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#440773)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#440773)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#440774)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type#440774)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#440775)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#440775)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#440776)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#440776)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#440777)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#440777)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#440778)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#440778)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#440779)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#440779)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#440780)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#440780)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#440781)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#440781)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#440782)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#440782)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#440783)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#440783)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#440784)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#440784)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#440785)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#440785)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#440786)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#440786)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#440787)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#440787)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#440788)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#440788)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#440789)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#440789)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#440790)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#440790)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#440791)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#440791)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#440792)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#440792)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#440793)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#440793)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#440794)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#440794)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#440795)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#440795)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#440796)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#440796)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#440797)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#440797)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#440798)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#440798)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#440799)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#440799)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#440800)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#440800)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#440801)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#440801)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#440802)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#440802)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#440803)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#440803)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#440804)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#440804)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#440805)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#440805)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#440806)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#440806)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#440807)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#440807)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#440808)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#440808)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#440809)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#440809)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#440810)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#440810)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#440811)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#440811)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#440812)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#440812)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#440813)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#440813)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#440814)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#440814)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#440815)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#440815)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#440816)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#440816)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#440817)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#440817)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#440818)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#440818)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#440819)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#440819)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#440820)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#440820)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#440821)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#440821)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#440822)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#440822)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#440823)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#440823)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#440824)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#440824)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#440825)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#440825)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MOB)) THEN false ELSE Contains(str_remove_accent(null), MOB) END)

Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1] [al_annval#440768,al_classe#440787,al_codcha#440814,al_codsit#440777,al_coduti#440776,al_codval#440767,al_comment#440812,al_datede#440810,al_datefi#440822,al_datmaj#440775,al_envadm#440783,al_flicpt#440809,al_flsej#440808,al_fltele#440813,al_forfai#440786,al_icd#440824,al_int_spe#440819,al_int_std#440818,al_letadm#440782,al_letads#440815,al_lib30#440770,al_libmaj#440771,al_monnaie#440778,al_numbmp#440780,... 35 more fields] PushedFilters: [], ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_co...

WholeStageCodegen (2)

Details

== Physical Plan ==
AdaptiveSparkPlan (18)
+- == Final Plan ==
   * HashAggregate (12)
   +- AQEShuffleRead (11)
      +- ShuffleQueryStage (10), Statistics(sizeInBytes=4.7 KiB, rowCount=6)
         +- Exchange (9)
            +- * HashAggregate (8)
               +- Union (7)
                  :- * Project (3)
                  :  +- * Filter (2)
                  :     +- * Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  (1)
                  +- * Project (6)
                     +- * Filter (5)
                        +- * Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   CollectLimit (17)
   +- HashAggregate (16)
      +- Exchange (15)
         +- HashAggregate (14)
            +- Union (13)
               :- Project (3)
               :  +- Filter (2)
               :     +- Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  (1)
               +- Project (6)
                  +- Filter (5)
                     +- Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  [codegen id : 1]
Output [59]: [al_annval#440235, al_classe#440254, al_codcha#440281, al_codsit#440244, al_coduti#440243, al_codval#440234, al_comment#440279, al_datede#440277, al_datefi#440289, al_datmaj#440242, al_envadm#440250, al_flicpt#440276, al_flsej#440275, al_fltele#440280, al_forfai#440253, al_icd#440291, al_int_spe#440286, al_int_std#440285, al_letadm#440249, al_letads#440282, al_lib30#440237, al_libmaj#440238, al_monnaie#440245, al_numbmp#440247, al_numcpt#440278, al_ordre#440248, al_primai#440290, al_prior#440240, al_rcp#440288, al_rembours#440256, al_revers#440255, al_sites#440283, al_spl_trans#440287, al_taux#440239, al_taux_r#440252, al_taux_t1r#440266, al_taux_t1#440257, al_taux_t2r#440267, al_taux_t2#440258, al_taux_t3r#440268, al_taux_t3#440259, al_taux_t4r#440269, al_taux_t4#440260, al_taux_t5r#440270, al_taux_t5#440261, al_taux_t6r#440271, al_taux_t6#440262, al_taux_t7r#440272, al_taux_t7#440263, al_taux_t8r#440273, al_taux_t8#440264, al_taux_t9r#440274, al_taux_t9#440265, al_typexa#440246, al_type#440241, al_type_icd#440292, al_t_red#440251, al_urg#440284, al_valcou#440236]
ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_codval:string,al_comment:string,al_datede:string,al_datefi:string,al_datmaj:string,al_envadm:string,al_flicpt:string,al_flsej:string,al_fltele:string,al_forfai:string,al_icd:string,al_int_spe:string,al_int_std:string,al_letadm:string,al_letads:string,al_lib30:string,al_libmaj:string,al_monnaie:string,al_numbmp:string,al_numcpt:string,al_ordre:string,al_primai:string,al_prior:string,al_rcp:string,al_rembours:string,al_revers:string,al_sites:string,al_spl_trans:string,al_taux:string,al_taux_r:string,al_taux_t1r:string,al_taux_t1:string,al_taux_t2r:string,al_taux_t2:string,al_taux_t3r:string,al_taux_t3:string,al_taux_t4r:string,al_taux_t4:string,al_taux_t5r:string,al_taux_t5:string,al_taux_t6r:string,al_taux_t6:string,al_taux_t7r:string,al_taux_t7:string,al_taux_t8r:string,al_taux_t8:string,al_taux_t9r:string,al_taux_t9:string,al_typexa:string,al_type:string,al_type_icd:string,al_t_red:string,al_urg:string,al_valcou:string>

(2) Filter [codegen id : 1]
Input [59]: [al_annval#440235, al_classe#440254, al_codcha#440281, al_codsit#440244, al_coduti#440243, al_codval#440234, al_comment#440279, al_datede#440277, al_datefi#440289, al_datmaj#440242, al_envadm#440250, al_flicpt#440276, al_flsej#440275, al_fltele#440280, al_forfai#440253, al_icd#440291, al_int_spe#440286, al_int_std#440285, al_letadm#440249, al_letads#440282, al_lib30#440237, al_libmaj#440238, al_monnaie#440245, al_numbmp#440247, al_numcpt#440278, al_ordre#440248, al_primai#440290, al_prior#440240, al_rcp#440288, al_rembours#440256, al_revers#440255, al_sites#440283, al_spl_trans#440287, al_taux#440239, al_taux_r#440252, al_taux_t1r#440266, al_taux_t1#440257, al_taux_t2r#440267, al_taux_t2#440258, al_taux_t3r#440268, al_taux_t3#440259, al_taux_t4r#440269, al_taux_t4#440260, al_taux_t5r#440270, al_taux_t5#440261, al_taux_t6r#440271, al_taux_t6#440262, al_taux_t7r#440272, al_taux_t7#440263, al_taux_t8r#440273, al_taux_t8#440264, al_taux_t9r#440274, al_taux_t9#440265, al_typexa#440246, al_type#440241, al_type_icd#440292, al_t_red#440251, al_urg#440284, al_valcou#440236]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#440234)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#440234)), MOB) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#440235)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#440235)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#440236)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#440236)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#440237)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#440237)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#440238)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#440238)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#440239)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#440239)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#440240)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#440240)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#440241)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type#440241)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#440242)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#440242)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#440243)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#440243)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#440244)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#440244)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#440245)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#440245)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#440246)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#440246)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#440247)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#440247)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#440248)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#440248)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#440249)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#440249)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#440250)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#440250)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#440251)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#440251)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#440252)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#440252)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#440253)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#440253)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#440254)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#440254)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#440255)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#440255)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#440256)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#440256)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#440257)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#440257)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#440258)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#440258)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#440259)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#440259)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#440260)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#440260)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#440261)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#440261)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#440262)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#440262)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#440263)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#440263)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#440264)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#440264)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#440265)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#440265)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#440266)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#440266)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#440267)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#440267)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#440268)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#440268)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#440269)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#440269)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#440270)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#440270)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#440271)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#440271)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#440272)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#440272)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#440273)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#440273)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#440274)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#440274)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#440275)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#440275)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#440276)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#440276)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#440277)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#440277)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#440278)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#440278)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#440279)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#440279)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#440280)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#440280)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#440281)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#440281)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#440282)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#440282)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#440283)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#440283)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#440284)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#440284)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#440285)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#440285)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#440286)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#440286)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#440287)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#440287)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#440288)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#440288)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#440289)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#440289)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#440290)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#440290)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#440291)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#440291)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#440292)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#440292)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MOB)) THEN false ELSE Contains(str_remove_accent(null), MOB) END)

(3) Project [codegen id : 1]
Output [60]: [al_annval#440235 AS AL_ANNVAL_438378#440647, al_classe#440254 AS AL_CLASSE_438397#440648, al_codcha#440281 AS AL_CODCHA_438424#440649, al_codsit#440244 AS AL_CODSIT_438387#440650, al_coduti#440243 AS AL_CODUTI_438386#440651, al_codval#440234 AS AL_CODVAL_438377#440652, al_comment#440279 AS AL_COMMENT_438422#440653, al_datede#440277 AS AL_DATEDE_438420#440654, al_datefi#440289 AS AL_DATEFI_438432#440655, al_datmaj#440242 AS AL_DATMAJ_438385#440656, al_envadm#440250 AS AL_ENVADM_438393#440657, al_flicpt#440276 AS AL_FLICPT_438419#440658, al_flsej#440275 AS AL_FLSEJ_438418#440659, al_fltele#440280 AS AL_FLTELE_438423#440660, al_forfai#440253 AS AL_FORFAI_438396#440661, al_icd#440291 AS AL_ICD_438434#440662, al_int_spe#440286 AS AL_INT_SPE_438429#440663, al_int_std#440285 AS AL_INT_STD_438428#440664, al_letadm#440249 AS AL_LETADM_438392#440665, al_letads#440282 AS AL_LETADS_438425#440666, al_lib30#440237 AS AL_LIB30_438380#440667, al_libmaj#440238 AS AL_LIBMAJ_438381#440668, al_monnaie#440245 AS AL_MONNAIE_438388#440669, al_numbmp#440247 AS AL_NUMBMP_438390#440670, al_numcpt#440278 AS AL_NUMCPT_438421#440671, al_ordre#440248 AS AL_ORDRE_438391#440672, al_primai#440290 AS AL_PRIMAI_438433#440673, al_prior#440240 AS AL_PRIOR_438383#440674, al_rcp#440288 AS AL_RCP_438431#440675, al_rembours#440256 AS AL_REMBOURS_438399#440676, al_revers#440255 AS AL_REVERS_438398#440677, al_sites#440283 AS AL_SITES_438426#440678, al_spl_trans#440287 AS AL_SPL_TRANS_438430#440679, al_taux#440239 AS AL_TAUX_438382#440680, al_taux_r#440252 AS AL_TAUX_R_438395#440681, al_taux_t1r#440266 AS AL_TAUX_T1R_438409#440682, al_taux_t1#440257 AS AL_TAUX_T1_438400#440683, al_taux_t2r#440267 AS AL_TAUX_T2R_438410#440684, al_taux_t2#440258 AS AL_TAUX_T2_438401#440685, al_taux_t3r#440268 AS AL_TAUX_T3R_438411#440686, al_taux_t3#440259 AS AL_TAUX_T3_438402#440687, al_taux_t4r#440269 AS AL_TAUX_T4R_438412#440688, al_taux_t4#440260 AS AL_TAUX_T4_438403#440689, al_taux_t5r#440270 AS AL_TAUX_T5R_438413#440690, al_taux_t5#440261 AS AL_TAUX_T5_438404#440691, al_taux_t6r#440271 AS AL_TAUX_T6R_438414#440692, al_taux_t6#440262 AS AL_TAUX_T6_438405#440693, al_taux_t7r#440272 AS AL_TAUX_T7R_438415#440694, al_taux_t7#440263 AS AL_TAUX_T7_438406#440695, al_taux_t8r#440273 AS AL_TAUX_T8R_438416#440696, al_taux_t8#440264 AS AL_TAUX_T8_438407#440697, al_taux_t9r#440274 AS AL_TAUX_T9R_438417#440698, al_taux_t9#440265 AS AL_TAUX_T9_438408#440699, al_typexa#440246 AS AL_TYPEXA_438389#440700, al_type#440241 AS AL_TYPE_438384#440701, al_type_icd#440292 AS AL_TYPE_ICD_438435#440702, al_t_red#440251 AS AL_T_RED_438394#440703, al_urg#440284 AS AL_URG_438427#440704, al_valcou#440236 AS AL_VALCOU_438379#440705, null AS ORIGINE_440156#440706]
Input [59]: [al_annval#440235, al_classe#440254, al_codcha#440281, al_codsit#440244, al_coduti#440243, al_codval#440234, al_comment#440279, al_datede#440277, al_datefi#440289, al_datmaj#440242, al_envadm#440250, al_flicpt#440276, al_flsej#440275, al_fltele#440280, al_forfai#440253, al_icd#440291, al_int_spe#440286, al_int_std#440285, al_letadm#440249, al_letads#440282, al_lib30#440237, al_libmaj#440238, al_monnaie#440245, al_numbmp#440247, al_numcpt#440278, al_ordre#440248, al_primai#440290, al_prior#440240, al_rcp#440288, al_rembours#440256, al_revers#440255, al_sites#440283, al_spl_trans#440287, al_taux#440239, al_taux_r#440252, al_taux_t1r#440266, al_taux_t1#440257, al_taux_t2r#440267, al_taux_t2#440258, al_taux_t3r#440268, al_taux_t3#440259, al_taux_t4r#440269, al_taux_t4#440260, al_taux_t5r#440270, al_taux_t5#440261, al_taux_t6r#440271, al_taux_t6#440262, al_taux_t7r#440272, al_taux_t7#440263, al_taux_t8r#440273, al_taux_t8#440264, al_taux_t9r#440274, al_taux_t9#440265, al_typexa#440246, al_type#440241, al_type_icd#440292, al_t_red#440251, al_urg#440284, al_valcou#440236]

(4) Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  [codegen id : 2]
Output [59]: [al_annval#440768, al_classe#440787, al_codcha#440814, al_codsit#440777, al_coduti#440776, al_codval#440767, al_comment#440812, al_datede#440810, al_datefi#440822, al_datmaj#440775, al_envadm#440783, al_flicpt#440809, al_flsej#440808, al_fltele#440813, al_forfai#440786, al_icd#440824, al_int_spe#440819, al_int_std#440818, al_letadm#440782, al_letads#440815, al_lib30#440770, al_libmaj#440771, al_monnaie#440778, al_numbmp#440780, al_numcpt#440811, al_ordre#440781, al_primai#440823, al_prior#440773, al_rcp#440821, al_rembours#440789, al_revers#440788, al_sites#440816, al_spl_trans#440820, al_taux#440772, al_taux_r#440785, al_taux_t1r#440799, al_taux_t1#440790, al_taux_t2r#440800, al_taux_t2#440791, al_taux_t3r#440801, al_taux_t3#440792, al_taux_t4r#440802, al_taux_t4#440793, al_taux_t5r#440803, al_taux_t5#440794, al_taux_t6r#440804, al_taux_t6#440795, al_taux_t7r#440805, al_taux_t7#440796, al_taux_t8r#440806, al_taux_t8#440797, al_taux_t9r#440807, al_taux_t9#440798, al_typexa#440779, al_type#440774, al_type_icd#440825, al_t_red#440784, al_urg#440817, al_valcou#440769]
ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_codval:string,al_comment:string,al_datede:string,al_datefi:string,al_datmaj:string,al_envadm:string,al_flicpt:string,al_flsej:string,al_fltele:string,al_forfai:string,al_icd:string,al_int_spe:string,al_int_std:string,al_letadm:string,al_letads:string,al_lib30:string,al_libmaj:string,al_monnaie:string,al_numbmp:string,al_numcpt:string,al_ordre:string,al_primai:string,al_prior:string,al_rcp:string,al_rembours:string,al_revers:string,al_sites:string,al_spl_trans:string,al_taux:string,al_taux_r:string,al_taux_t1r:string,al_taux_t1:string,al_taux_t2r:string,al_taux_t2:string,al_taux_t3r:string,al_taux_t3:string,al_taux_t4r:string,al_taux_t4:string,al_taux_t5r:string,al_taux_t5:string,al_taux_t6r:string,al_taux_t6:string,al_taux_t7r:string,al_taux_t7:string,al_taux_t8r:string,al_taux_t8:string,al_taux_t9r:string,al_taux_t9:string,al_typexa:string,al_type:string,al_type_icd:string,al_t_red:string,al_urg:string,al_valcou:string>

(5) Filter [codegen id : 2]
Input [59]: [al_annval#440768, al_classe#440787, al_codcha#440814, al_codsit#440777, al_coduti#440776, al_codval#440767, al_comment#440812, al_datede#440810, al_datefi#440822, al_datmaj#440775, al_envadm#440783, al_flicpt#440809, al_flsej#440808, al_fltele#440813, al_forfai#440786, al_icd#440824, al_int_spe#440819, al_int_std#440818, al_letadm#440782, al_letads#440815, al_lib30#440770, al_libmaj#440771, al_monnaie#440778, al_numbmp#440780, al_numcpt#440811, al_ordre#440781, al_primai#440823, al_prior#440773, al_rcp#440821, al_rembours#440789, al_revers#440788, al_sites#440816, al_spl_trans#440820, al_taux#440772, al_taux_r#440785, al_taux_t1r#440799, al_taux_t1#440790, al_taux_t2r#440800, al_taux_t2#440791, al_taux_t3r#440801, al_taux_t3#440792, al_taux_t4r#440802, al_taux_t4#440793, al_taux_t5r#440803, al_taux_t5#440794, al_taux_t6r#440804, al_taux_t6#440795, al_taux_t7r#440805, al_taux_t7#440796, al_taux_t8r#440806, al_taux_t8#440797, al_taux_t9r#440807, al_taux_t9#440798, al_typexa#440779, al_type#440774, al_type_icd#440825, al_t_red#440784, al_urg#440817, al_valcou#440769]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#440767)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#440767)), MOB) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#440768)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#440768)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#440769)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#440769)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#440770)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#440770)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#440771)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#440771)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#440772)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#440772)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#440773)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#440773)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#440774)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type#440774)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#440775)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#440775)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#440776)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#440776)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#440777)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#440777)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#440778)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#440778)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#440779)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#440779)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#440780)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#440780)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#440781)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#440781)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#440782)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#440782)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#440783)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#440783)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#440784)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#440784)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#440785)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#440785)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#440786)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#440786)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#440787)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#440787)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#440788)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#440788)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#440789)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#440789)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#440790)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#440790)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#440791)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#440791)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#440792)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#440792)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#440793)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#440793)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#440794)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#440794)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#440795)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#440795)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#440796)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#440796)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#440797)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#440797)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#440798)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#440798)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#440799)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#440799)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#440800)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#440800)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#440801)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#440801)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#440802)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#440802)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#440803)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#440803)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#440804)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#440804)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#440805)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#440805)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#440806)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#440806)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#440807)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#440807)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#440808)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#440808)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#440809)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#440809)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#440810)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#440810)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#440811)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#440811)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#440812)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#440812)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#440813)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#440813)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#440814)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#440814)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#440815)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#440815)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#440816)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#440816)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#440817)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#440817)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#440818)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#440818)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#440819)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#440819)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#440820)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#440820)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#440821)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#440821)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#440822)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#440822)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#440823)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#440823)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#440824)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#440824)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#440825)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#440825)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MOB)) THEN false ELSE Contains(str_remove_accent(null), MOB) END)

(6) Project [codegen id : 2]
Output [60]: [al_annval#440768 AS AL_ANNVAL_438378#441180, al_classe#440787 AS AL_CLASSE_438397#441181, al_codcha#440814 AS AL_CODCHA_438424#441182, al_codsit#440777 AS AL_CODSIT_438387#441183, al_coduti#440776 AS AL_CODUTI_438386#441184, al_codval#440767 AS AL_CODVAL_438377#441185, al_comment#440812 AS AL_COMMENT_438422#441186, al_datede#440810 AS AL_DATEDE_438420#441187, al_datefi#440822 AS AL_DATEFI_438432#441188, al_datmaj#440775 AS AL_DATMAJ_438385#441189, al_envadm#440783 AS AL_ENVADM_438393#441190, al_flicpt#440809 AS AL_FLICPT_438419#441191, al_flsej#440808 AS AL_FLSEJ_438418#441192, al_fltele#440813 AS AL_FLTELE_438423#441193, al_forfai#440786 AS AL_FORFAI_438396#441194, al_icd#440824 AS AL_ICD_438434#441195, al_int_spe#440819 AS AL_INT_SPE_438429#441196, al_int_std#440818 AS AL_INT_STD_438428#441197, al_letadm#440782 AS AL_LETADM_438392#441198, al_letads#440815 AS AL_LETADS_438425#441199, al_lib30#440770 AS AL_LIB30_438380#441200, al_libmaj#440771 AS AL_LIBMAJ_438381#441201, al_monnaie#440778 AS AL_MONNAIE_438388#441202, al_numbmp#440780 AS AL_NUMBMP_438390#441203, al_numcpt#440811 AS AL_NUMCPT_438421#441204, al_ordre#440781 AS AL_ORDRE_438391#441205, al_primai#440823 AS AL_PRIMAI_438433#441206, al_prior#440773 AS AL_PRIOR_438383#441207, al_rcp#440821 AS AL_RCP_438431#441208, al_rembours#440789 AS AL_REMBOURS_438399#441209, al_revers#440788 AS AL_REVERS_438398#441210, al_sites#440816 AS AL_SITES_438426#441211, al_spl_trans#440820 AS AL_SPL_TRANS_438430#441212, al_taux#440772 AS AL_TAUX_438382#441213, al_taux_r#440785 AS AL_TAUX_R_438395#441214, al_taux_t1r#440799 AS AL_TAUX_T1R_438409#441215, al_taux_t1#440790 AS AL_TAUX_T1_438400#441216, al_taux_t2r#440800 AS AL_TAUX_T2R_438410#441217, al_taux_t2#440791 AS AL_TAUX_T2_438401#441218, al_taux_t3r#440801 AS AL_TAUX_T3R_438411#441219, al_taux_t3#440792 AS AL_TAUX_T3_438402#441220, al_taux_t4r#440802 AS AL_TAUX_T4R_438412#441221, al_taux_t4#440793 AS AL_TAUX_T4_438403#441222, al_taux_t5r#440803 AS AL_TAUX_T5R_438413#441223, al_taux_t5#440794 AS AL_TAUX_T5_438404#441224, al_taux_t6r#440804 AS AL_TAUX_T6R_438414#441225, al_taux_t6#440795 AS AL_TAUX_T6_438405#441226, al_taux_t7r#440805 AS AL_TAUX_T7R_438415#441227, al_taux_t7#440796 AS AL_TAUX_T7_438406#441228, al_taux_t8r#440806 AS AL_TAUX_T8R_438416#441229, al_taux_t8#440797 AS AL_TAUX_T8_438407#441230, al_taux_t9r#440807 AS AL_TAUX_T9R_438417#441231, al_taux_t9#440798 AS AL_TAUX_T9_438408#441232, al_typexa#440779 AS AL_TYPEXA_438389#441233, al_type#440774 AS AL_TYPE_438384#441234, al_type_icd#440825 AS AL_TYPE_ICD_438435#441235, al_t_red#440784 AS AL_T_RED_438394#441236, al_urg#440817 AS AL_URG_438427#441237, al_valcou#440769 AS AL_VALCOU_438379#441238, null AS ORIGINE_440156#441239]
Input [59]: [al_annval#440768, al_classe#440787, al_codcha#440814, al_codsit#440777, al_coduti#440776, al_codval#440767, al_comment#440812, al_datede#440810, al_datefi#440822, al_datmaj#440775, al_envadm#440783, al_flicpt#440809, al_flsej#440808, al_fltele#440813, al_forfai#440786, al_icd#440824, al_int_spe#440819, al_int_std#440818, al_letadm#440782, al_letads#440815, al_lib30#440770, al_libmaj#440771, al_monnaie#440778, al_numbmp#440780, al_numcpt#440811, al_ordre#440781, al_primai#440823, al_prior#440773, al_rcp#440821, al_rembours#440789, al_revers#440788, al_sites#440816, al_spl_trans#440820, al_taux#440772, al_taux_r#440785, al_taux_t1r#440799, al_taux_t1#440790, al_taux_t2r#440800, al_taux_t2#440791, al_taux_t3r#440801, al_taux_t3#440792, al_taux_t4r#440802, al_taux_t4#440793, al_taux_t5r#440803, al_taux_t5#440794, al_taux_t6r#440804, al_taux_t6#440795, al_taux_t7r#440805, al_taux_t7#440796, al_taux_t8r#440806, al_taux_t8#440797, al_taux_t9r#440807, al_taux_t9#440798, al_typexa#440779, al_type#440774, al_type_icd#440825, al_t_red#440784, al_urg#440817, al_valcou#440769]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Keys [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]

(9) Exchange
Input [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Arguments: hashpartitioning(AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26780]

(10) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Arguments: 0

(11) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Keys [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_CODVAL_438377#440652 AS COL_AL_CODVAL_438377#441900, AL_ANNVAL_438378#440647 AS COL_AL_ANNVAL_438378#441901, AL_VALCOU_438379#440705 AS COL_AL_VALCOU_438379#441902, AL_LIB30_438380#440667 AS COL_AL_LIB30_438380#441903, AL_LIBMAJ_438381#440668 AS COL_AL_LIBMAJ_438381#441904, AL_TAUX_438382#440680 AS COL_AL_TAUX_438382#441905, AL_PRIOR_438383#440674 AS COL_AL_PRIOR_438383#441906, AL_TYPE_438384#440701 AS COL_AL_TYPE_438384#441907, AL_DATMAJ_438385#440656 AS COL_AL_DATMAJ_438385#441908, AL_CODUTI_438386#440651 AS COL_AL_CODUTI_438386#441909, AL_CODSIT_438387#440650 AS COL_AL_CODSIT_438387#441910, AL_MONNAIE_438388#440669 AS COL_AL_MONNAIE_438388#441911, AL_TYPEXA_438389#440700 AS COL_AL_TYPEXA_438389#441912, AL_NUMBMP_438390#440670 AS COL_AL_NUMBMP_438390#441913, AL_ORDRE_438391#440672 AS COL_AL_ORDRE_438391#441914, AL_LETADM_438392#440665 AS COL_AL_LETADM_438392#441915, AL_ENVADM_438393#440657 AS COL_AL_ENVADM_438393#441916, AL_T_RED_438394#440703 AS COL_AL_T_RED_438394#441917, AL_TAUX_R_438395#440681 AS COL_AL_TAUX_R_438395#441918, AL_FORFAI_438396#440661 AS COL_AL_FORFAI_438396#441919, AL_CLASSE_438397#440648 AS COL_AL_CLASSE_438397#441920, AL_REVERS_438398#440677 AS COL_AL_REVERS_438398#441921, AL_REMBOURS_438399#440676 AS COL_AL_REMBOURS_438399#441922, AL_TAUX_T1_438400#440683 AS COL_AL_TAUX_T1_438400#441923, AL_TAUX_T2_438401#440685 AS COL_AL_TAUX_T2_438401#441924, AL_TAUX_T3_438402#440687 AS COL_AL_TAUX_T3_438402#441925, AL_TAUX_T4_438403#440689 AS COL_AL_TAUX_T4_438403#441926, AL_TAUX_T5_438404#440691 AS COL_AL_TAUX_T5_438404#441927, AL_TAUX_T6_438405#440693 AS COL_AL_TAUX_T6_438405#441928, AL_TAUX_T7_438406#440695 AS COL_AL_TAUX_T7_438406#441929, AL_TAUX_T8_438407#440697 AS COL_AL_TAUX_T8_438407#441930, AL_TAUX_T9_438408#440699 AS COL_AL_TAUX_T9_438408#441931, AL_TAUX_T1R_438409#440682 AS COL_AL_TAUX_T1R_438409#441932, AL_TAUX_T2R_438410#440684 AS COL_AL_TAUX_T2R_438410#441933, AL_TAUX_T3R_438411#440686 AS COL_AL_TAUX_T3R_438411#441934, AL_TAUX_T4R_438412#440688 AS COL_AL_TAUX_T4R_438412#441935, AL_TAUX_T5R_438413#440690 AS COL_AL_TAUX_T5R_438413#441936, AL_TAUX_T6R_438414#440692 AS COL_AL_TAUX_T6R_438414#441937, AL_TAUX_T7R_438415#440694 AS COL_AL_TAUX_T7R_438415#441938, AL_TAUX_T8R_438416#440696 AS COL_AL_TAUX_T8R_438416#441939, AL_TAUX_T9R_438417#440698 AS COL_AL_TAUX_T9R_438417#441940, AL_FLSEJ_438418#440659 AS COL_AL_FLSEJ_438418#441941, AL_FLICPT_438419#440658 AS COL_AL_FLICPT_438419#441942, AL_DATEDE_438420#440654 AS COL_AL_DATEDE_438420#441943, AL_NUMCPT_438421#440671 AS COL_AL_NUMCPT_438421#441944, AL_COMMENT_438422#440653 AS COL_AL_COMMENT_438422#441945, AL_FLTELE_438423#440660 AS COL_AL_FLTELE_438423#441946, AL_CODCHA_438424#440649 AS COL_AL_CODCHA_438424#441947, AL_LETADS_438425#440666 AS COL_AL_LETADS_438425#441948, AL_SITES_438426#440678 AS COL_AL_SITES_438426#441949, AL_URG_438427#440704 AS COL_AL_URG_438427#441950, AL_INT_STD_438428#440664 AS COL_AL_INT_STD_438428#441951, AL_INT_SPE_438429#440663 AS COL_AL_INT_SPE_438429#441952, AL_SPL_TRANS_438430#440679 AS COL_AL_SPL_TRANS_438430#441953, AL_RCP_438431#440675 AS COL_AL_RCP_438431#441954, AL_DATEFI_438432#440655 AS COL_AL_DATEFI_438432#441955, AL_PRIMAI_438433#440673 AS COL_AL_PRIMAI_438433#441956, AL_ICD_438434#440662 AS COL_AL_ICD_438434#441957, AL_TYPE_ICD_438435#440702 AS COL_AL_TYPE_ICD_438435#441958, ORIGINE_440156#440706 AS COL_ORIGINE_440156#441959]

(13) Union

(14) HashAggregate
Input [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Keys [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]

(15) Exchange
Input [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Arguments: hashpartitioning(AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26756]

(16) HashAggregate
Input [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Keys [60]: [AL_ANNVAL_438378#440647, AL_CLASSE_438397#440648, AL_CODCHA_438424#440649, AL_CODSIT_438387#440650, AL_CODUTI_438386#440651, AL_CODVAL_438377#440652, AL_COMMENT_438422#440653, AL_DATEDE_438420#440654, AL_DATEFI_438432#440655, AL_DATMAJ_438385#440656, AL_ENVADM_438393#440657, AL_FLICPT_438419#440658, AL_FLSEJ_438418#440659, AL_FLTELE_438423#440660, AL_FORFAI_438396#440661, AL_ICD_438434#440662, AL_INT_SPE_438429#440663, AL_INT_STD_438428#440664, AL_LETADM_438392#440665, AL_LETADS_438425#440666, AL_LIB30_438380#440667, AL_LIBMAJ_438381#440668, AL_MONNAIE_438388#440669, AL_NUMBMP_438390#440670, AL_NUMCPT_438421#440671, AL_ORDRE_438391#440672, AL_PRIMAI_438433#440673, AL_PRIOR_438383#440674, AL_RCP_438431#440675, AL_REMBOURS_438399#440676, AL_REVERS_438398#440677, AL_SITES_438426#440678, AL_SPL_TRANS_438430#440679, AL_TAUX_438382#440680, AL_TAUX_R_438395#440681, AL_TAUX_T1R_438409#440682, AL_TAUX_T1_438400#440683, AL_TAUX_T2R_438410#440684, AL_TAUX_T2_438401#440685, AL_TAUX_T3R_438411#440686, AL_TAUX_T3_438402#440687, AL_TAUX_T4R_438412#440688, AL_TAUX_T4_438403#440689, AL_TAUX_T5R_438413#440690, AL_TAUX_T5_438404#440691, AL_TAUX_T6R_438414#440692, AL_TAUX_T6_438405#440693, AL_TAUX_T7R_438415#440694, AL_TAUX_T7_438406#440695, AL_TAUX_T8R_438416#440696, AL_TAUX_T8_438407#440697, AL_TAUX_T9R_438417#440698, AL_TAUX_T9_438408#440699, AL_TYPEXA_438389#440700, AL_TYPE_438384#440701, AL_TYPE_ICD_438435#440702, AL_T_RED_438394#440703, AL_URG_438427#440704, AL_VALCOU_438379#440705, ORIGINE_440156#440706]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_CODVAL_438377#440652 AS COL_AL_CODVAL_438377#441900, AL_ANNVAL_438378#440647 AS COL_AL_ANNVAL_438378#441901, AL_VALCOU_438379#440705 AS COL_AL_VALCOU_438379#441902, AL_LIB30_438380#440667 AS COL_AL_LIB30_438380#441903, AL_LIBMAJ_438381#440668 AS COL_AL_LIBMAJ_438381#441904, AL_TAUX_438382#440680 AS COL_AL_TAUX_438382#441905, AL_PRIOR_438383#440674 AS COL_AL_PRIOR_438383#441906, AL_TYPE_438384#440701 AS COL_AL_TYPE_438384#441907, AL_DATMAJ_438385#440656 AS COL_AL_DATMAJ_438385#441908, AL_CODUTI_438386#440651 AS COL_AL_CODUTI_438386#441909, AL_CODSIT_438387#440650 AS COL_AL_CODSIT_438387#441910, AL_MONNAIE_438388#440669 AS COL_AL_MONNAIE_438388#441911, AL_TYPEXA_438389#440700 AS COL_AL_TYPEXA_438389#441912, AL_NUMBMP_438390#440670 AS COL_AL_NUMBMP_438390#441913, AL_ORDRE_438391#440672 AS COL_AL_ORDRE_438391#441914, AL_LETADM_438392#440665 AS COL_AL_LETADM_438392#441915, AL_ENVADM_438393#440657 AS COL_AL_ENVADM_438393#441916, AL_T_RED_438394#440703 AS COL_AL_T_RED_438394#441917, AL_TAUX_R_438395#440681 AS COL_AL_TAUX_R_438395#441918, AL_FORFAI_438396#440661 AS COL_AL_FORFAI_438396#441919, AL_CLASSE_438397#440648 AS COL_AL_CLASSE_438397#441920, AL_REVERS_438398#440677 AS COL_AL_REVERS_438398#441921, AL_REMBOURS_438399#440676 AS COL_AL_REMBOURS_438399#441922, AL_TAUX_T1_438400#440683 AS COL_AL_TAUX_T1_438400#441923, AL_TAUX_T2_438401#440685 AS COL_AL_TAUX_T2_438401#441924, AL_TAUX_T3_438402#440687 AS COL_AL_TAUX_T3_438402#441925, AL_TAUX_T4_438403#440689 AS COL_AL_TAUX_T4_438403#441926, AL_TAUX_T5_438404#440691 AS COL_AL_TAUX_T5_438404#441927, AL_TAUX_T6_438405#440693 AS COL_AL_TAUX_T6_438405#441928, AL_TAUX_T7_438406#440695 AS COL_AL_TAUX_T7_438406#441929, AL_TAUX_T8_438407#440697 AS COL_AL_TAUX_T8_438407#441930, AL_TAUX_T9_438408#440699 AS COL_AL_TAUX_T9_438408#441931, AL_TAUX_T1R_438409#440682 AS COL_AL_TAUX_T1R_438409#441932, AL_TAUX_T2R_438410#440684 AS COL_AL_TAUX_T2R_438410#441933, AL_TAUX_T3R_438411#440686 AS COL_AL_TAUX_T3R_438411#441934, AL_TAUX_T4R_438412#440688 AS COL_AL_TAUX_T4R_438412#441935, AL_TAUX_T5R_438413#440690 AS COL_AL_TAUX_T5R_438413#441936, AL_TAUX_T6R_438414#440692 AS COL_AL_TAUX_T6R_438414#441937, AL_TAUX_T7R_438415#440694 AS COL_AL_TAUX_T7R_438415#441938, AL_TAUX_T8R_438416#440696 AS COL_AL_TAUX_T8R_438416#441939, AL_TAUX_T9R_438417#440698 AS COL_AL_TAUX_T9R_438417#441940, AL_FLSEJ_438418#440659 AS COL_AL_FLSEJ_438418#441941, AL_FLICPT_438419#440658 AS COL_AL_FLICPT_438419#441942, AL_DATEDE_438420#440654 AS COL_AL_DATEDE_438420#441943, AL_NUMCPT_438421#440671 AS COL_AL_NUMCPT_438421#441944, AL_COMMENT_438422#440653 AS COL_AL_COMMENT_438422#441945, AL_FLTELE_438423#440660 AS COL_AL_FLTELE_438423#441946, AL_CODCHA_438424#440649 AS COL_AL_CODCHA_438424#441947, AL_LETADS_438425#440666 AS COL_AL_LETADS_438425#441948, AL_SITES_438426#440678 AS COL_AL_SITES_438426#441949, AL_URG_438427#440704 AS COL_AL_URG_438427#441950, AL_INT_STD_438428#440664 AS COL_AL_INT_STD_438428#441951, AL_INT_SPE_438429#440663 AS COL_AL_INT_SPE_438429#441952, AL_SPL_TRANS_438430#440679 AS COL_AL_SPL_TRANS_438430#441953, AL_RCP_438431#440675 AS COL_AL_RCP_438431#441954, AL_DATEFI_438432#440655 AS COL_AL_DATEFI_438432#441955, AL_PRIMAI_438433#440673 AS COL_AL_PRIMAI_438433#441956, AL_ICD_438434#440662 AS COL_AL_ICD_438434#441957, AL_TYPE_ICD_438435#440702 AS COL_AL_TYPE_ICD_438435#441958, ORIGINE_440156#440706 AS COL_ORIGINE_440156#441959]

(17) CollectLimit
Input [60]: [COL_AL_CODVAL_438377#441900, COL_AL_ANNVAL_438378#441901, COL_AL_VALCOU_438379#441902, COL_AL_LIB30_438380#441903, COL_AL_LIBMAJ_438381#441904, COL_AL_TAUX_438382#441905, COL_AL_PRIOR_438383#441906, COL_AL_TYPE_438384#441907, COL_AL_DATMAJ_438385#441908, COL_AL_CODUTI_438386#441909, COL_AL_CODSIT_438387#441910, COL_AL_MONNAIE_438388#441911, COL_AL_TYPEXA_438389#441912, COL_AL_NUMBMP_438390#441913, COL_AL_ORDRE_438391#441914, COL_AL_LETADM_438392#441915, COL_AL_ENVADM_438393#441916, COL_AL_T_RED_438394#441917, COL_AL_TAUX_R_438395#441918, COL_AL_FORFAI_438396#441919, COL_AL_CLASSE_438397#441920, COL_AL_REVERS_438398#441921, COL_AL_REMBOURS_438399#441922, COL_AL_TAUX_T1_438400#441923, COL_AL_TAUX_T2_438401#441924, COL_AL_TAUX_T3_438402#441925, COL_AL_TAUX_T4_438403#441926, COL_AL_TAUX_T5_438404#441927, COL_AL_TAUX_T6_438405#441928, COL_AL_TAUX_T7_438406#441929, COL_AL_TAUX_T8_438407#441930, COL_AL_TAUX_T9_438408#441931, COL_AL_TAUX_T1R_438409#441932, COL_AL_TAUX_T2R_438410#441933, COL_AL_TAUX_T3R_438411#441934, COL_AL_TAUX_T4R_438412#441935, COL_AL_TAUX_T5R_438413#441936, COL_AL_TAUX_T6R_438414#441937, COL_AL_TAUX_T7R_438415#441938, COL_AL_TAUX_T8R_438416#441939, COL_AL_TAUX_T9R_438417#441940, COL_AL_FLSEJ_438418#441941, COL_AL_FLICPT_438419#441942, COL_AL_DATEDE_438420#441943, COL_AL_NUMCPT_438421#441944, COL_AL_COMMENT_438422#441945, COL_AL_FLTELE_438423#441946, COL_AL_CODCHA_438424#441947, COL_AL_LETADS_438425#441948, COL_AL_SITES_438426#441949, COL_AL_URG_438427#441950, COL_AL_INT_STD_438428#441951, COL_AL_INT_SPE_438429#441952, COL_AL_SPL_TRANS_438430#441953, COL_AL_RCP_438431#441954, COL_AL_DATEFI_438432#441955, COL_AL_PRIMAI_438433#441956, COL_AL_ICD_438434#441957, COL_AL_TYPE_ICD_438435#441958, COL_ORIGINE_440156#441959]
Arguments: 1500

(18) AdaptiveSparkPlan
Output [60]: [COL_AL_CODVAL_438377#441900, COL_AL_ANNVAL_438378#441901, COL_AL_VALCOU_438379#441902, COL_AL_LIB30_438380#441903, COL_AL_LIBMAJ_438381#441904, COL_AL_TAUX_438382#441905, COL_AL_PRIOR_438383#441906, COL_AL_TYPE_438384#441907, COL_AL_DATMAJ_438385#441908, COL_AL_CODUTI_438386#441909, COL_AL_CODSIT_438387#441910, COL_AL_MONNAIE_438388#441911, COL_AL_TYPEXA_438389#441912, COL_AL_NUMBMP_438390#441913, COL_AL_ORDRE_438391#441914, COL_AL_LETADM_438392#441915, COL_AL_ENVADM_438393#441916, COL_AL_T_RED_438394#441917, COL_AL_TAUX_R_438395#441918, COL_AL_FORFAI_438396#441919, COL_AL_CLASSE_438397#441920, COL_AL_REVERS_438398#441921, COL_AL_REMBOURS_438399#441922, COL_AL_TAUX_T1_438400#441923, COL_AL_TAUX_T2_438401#441924, COL_AL_TAUX_T3_438402#441925, COL_AL_TAUX_T4_438403#441926, COL_AL_TAUX_T5_438404#441927, COL_AL_TAUX_T6_438405#441928, COL_AL_TAUX_T7_438406#441929, COL_AL_TAUX_T8_438407#441930, COL_AL_TAUX_T9_438408#441931, COL_AL_TAUX_T1R_438409#441932, COL_AL_TAUX_T2R_438410#441933, COL_AL_TAUX_T3R_438411#441934, COL_AL_TAUX_T4R_438412#441935, COL_AL_TAUX_T5R_438413#441936, COL_AL_TAUX_T6R_438414#441937, COL_AL_TAUX_T7R_438415#441938, COL_AL_TAUX_T8R_438416#441939, COL_AL_TAUX_T9R_438417#441940, COL_AL_FLSEJ_438418#441941, COL_AL_FLICPT_438419#441942, COL_AL_DATEDE_438420#441943, COL_AL_NUMCPT_438421#441944, COL_AL_COMMENT_438422#441945, COL_AL_FLTELE_438423#441946, COL_AL_CODCHA_438424#441947, COL_AL_LETADS_438425#441948, COL_AL_SITES_438426#441949, COL_AL_URG_438427#441950, COL_AL_INT_STD_438428#441951, COL_AL_INT_SPE_438429#441952, COL_AL_SPL_TRANS_438430#441953, COL_AL_RCP_438431#441954, COL_AL_DATEFI_438432#441955, COL_AL_PRIMAI_438433#441956, COL_AL_ICD_438434#441957, COL_AL_TYPE_ICD_438435#441958, COL_ORIGINE_440156#441959]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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