hdh-spark-job - Details for Query 1166

Submitted Time: 2026/10/23 11:55:13
Duration: 3 s
Succeeded Jobs: 1169 1171 1172

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 (5)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 6 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 6 ms peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [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"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 2.2 KiB number of coalesced partitions: 1"]; 8 [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 1611.0: task 1434)) 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 1611.0: task 1435)) 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 1611.0: task 1435))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.4 s (690 ms, 739 ms, 739 ms (stage 1611.0: task 1434))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1.4 s (679 ms, 728 ms, 728 ms (stage 1611.0: task 1434)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1611.0: task 1435)) 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 1611.0: task 1435))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 738 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 \"xplore\".\"h_valeu\") as x) [numPartitions=1] number of output rows: 9,180"]; } subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 690 ms"; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="Filter number of output rows: 3"]; 19 [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; 5->3; 6->5; 7->6; 8->7; 10->8; 11->10; 13->11; 14->13; 15->14; 17->11; 18->17; 19->18; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (5)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26814]

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

HashAggregate(keys=[AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26705]

WholeStageCodegen (3)

Union

Project [al_annval#438204 AS AL_ANNVAL_438378#438616, al_classe#438223 AS AL_CLASSE_438397#438617, al_codcha#438250 AS AL_CODCHA_438424#438618, al_codsit#438213 AS AL_CODSIT_438387#438619, al_coduti#438212 AS AL_CODUTI_438386#438620, al_codval#438203 AS AL_CODVAL_438377#438621, al_comment#438248 AS AL_COMMENT_438422#438622, al_datede#438246 AS AL_DATEDE_438420#438623, al_datefi#438258 AS AL_DATEFI_438432#438624, al_datmaj#438211 AS AL_DATMAJ_438385#438625, al_envadm#438219 AS AL_ENVADM_438393#438626, al_flicpt#438245 AS AL_FLICPT_438419#438627, al_flsej#438244 AS AL_FLSEJ_438418#438628, al_fltele#438249 AS AL_FLTELE_438423#438629, al_forfai#438222 AS AL_FORFAI_438396#438630, al_icd#438260 AS AL_ICD_438434#438631, al_int_spe#438255 AS AL_INT_SPE_438429#438632, al_int_std#438254 AS AL_INT_STD_438428#438633, al_letadm#438218 AS AL_LETADM_438392#438634, al_letads#438251 AS AL_LETADS_438425#438635, al_lib30#438206 AS AL_LIB30_438380#438636, al_libmaj#438207 AS AL_LIBMAJ_438381#438637, al_monnaie#438214 AS AL_MONNAIE_438388#438638, al_numbmp#438216 AS AL_NUMBMP_438390#438639, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#438203)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#438203)), MOB) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#438204)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#438204)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#438205)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#438205)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#438206)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#438206)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#438207)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#438207)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#438208)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#438208)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#438209)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#438209)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#438210)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type#438210)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#438211)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#438211)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#438212)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#438212)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#438213)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#438213)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#438214)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#438214)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#438215)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#438215)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#438216)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#438216)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#438217)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#438217)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#438218)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#438218)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#438219)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#438219)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#438220)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#438220)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#438221)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#438221)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#438222)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#438222)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#438223)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#438223)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#438224)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#438224)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#438225)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#438225)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#438226)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#438226)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#438227)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#438227)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#438228)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#438228)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#438229)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#438229)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#438230)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#438230)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#438231)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#438231)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#438232)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#438232)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#438233)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#438233)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#438234)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#438234)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#438235)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#438235)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#438236)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#438236)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#438237)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#438237)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#438238)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#438238)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#438239)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#438239)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#438240)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#438240)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#438241)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#438241)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#438242)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#438242)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#438243)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#438243)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#438244)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#438244)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#438245)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#438245)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#438246)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#438246)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#438247)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#438247)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#438248)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#438248)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#438249)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#438249)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#438250)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#438250)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#438251)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#438251)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#438252)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#438252)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#438253)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#438253)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#438254)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#438254)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#438255)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#438255)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#438256)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#438256)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#438257)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#438257)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#438258)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#438258)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#438259)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#438259)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#438260)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#438260)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#438261)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#438261)), 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#438204,al_classe#438223,al_codcha#438250,al_codsit#438213,al_coduti#438212,al_codval#438203,al_comment#438248,al_datede#438246,al_datefi#438258,al_datmaj#438211,al_envadm#438219,al_flicpt#438245,al_flsej#438244,al_fltele#438249,al_forfai#438222,al_icd#438260,al_int_spe#438255,al_int_std#438254,al_letadm#438218,al_letads#438251,al_lib30#438206,al_libmaj#438207,al_monnaie#438214,al_numbmp#438216,... 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#438737 AS AL_ANNVAL_438378#439149, al_classe#438756 AS AL_CLASSE_438397#439150, al_codcha#438783 AS AL_CODCHA_438424#439151, al_codsit#438746 AS AL_CODSIT_438387#439152, al_coduti#438745 AS AL_CODUTI_438386#439153, al_codval#438736 AS AL_CODVAL_438377#439154, al_comment#438781 AS AL_COMMENT_438422#439155, al_datede#438779 AS AL_DATEDE_438420#439156, al_datefi#438791 AS AL_DATEFI_438432#439157, al_datmaj#438744 AS AL_DATMAJ_438385#439158, al_envadm#438752 AS AL_ENVADM_438393#439159, al_flicpt#438778 AS AL_FLICPT_438419#439160, al_flsej#438777 AS AL_FLSEJ_438418#439161, al_fltele#438782 AS AL_FLTELE_438423#439162, al_forfai#438755 AS AL_FORFAI_438396#439163, al_icd#438793 AS AL_ICD_438434#439164, al_int_spe#438788 AS AL_INT_SPE_438429#439165, al_int_std#438787 AS AL_INT_STD_438428#439166, al_letadm#438751 AS AL_LETADM_438392#439167, al_letads#438784 AS AL_LETADS_438425#439168, al_lib30#438739 AS AL_LIB30_438380#439169, al_libmaj#438740 AS AL_LIBMAJ_438381#439170, al_monnaie#438747 AS AL_MONNAIE_438388#439171, al_numbmp#438749 AS AL_NUMBMP_438390#439172, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#438736)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#438736)), MOB) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#438737)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#438737)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#438738)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#438738)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#438739)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#438739)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#438740)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#438740)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#438741)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#438741)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#438742)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#438742)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#438743)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type#438743)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#438744)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#438744)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#438745)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#438745)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#438746)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#438746)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#438747)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#438747)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#438748)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#438748)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#438749)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#438749)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#438750)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#438750)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#438751)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#438751)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#438752)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#438752)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#438753)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#438753)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#438754)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#438754)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#438755)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#438755)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#438756)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#438756)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#438757)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#438757)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#438758)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#438758)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#438759)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#438759)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#438760)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#438760)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#438761)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#438761)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#438762)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#438762)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#438763)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#438763)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#438764)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#438764)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#438765)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#438765)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#438766)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#438766)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#438767)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#438767)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#438768)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#438768)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#438769)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#438769)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#438770)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#438770)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#438771)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#438771)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#438772)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#438772)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#438773)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#438773)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#438774)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#438774)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#438775)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#438775)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#438776)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#438776)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#438777)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#438777)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#438778)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#438778)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#438779)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#438779)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#438780)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#438780)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#438781)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#438781)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#438782)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#438782)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#438783)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#438783)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#438784)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#438784)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#438785)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#438785)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#438786)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#438786)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#438787)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#438787)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#438788)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#438788)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#438789)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#438789)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#438790)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#438790)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#438791)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#438791)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#438792)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#438792)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#438793)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#438793)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#438794)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#438794)), 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#438737,al_classe#438756,al_codcha#438783,al_codsit#438746,al_coduti#438745,al_codval#438736,al_comment#438781,al_datede#438779,al_datefi#438791,al_datmaj#438744,al_envadm#438752,al_flicpt#438778,al_flsej#438777,al_fltele#438782,al_forfai#438755,al_icd#438793,al_int_spe#438788,al_int_std#438787,al_letadm#438751,al_letads#438784,al_lib30#438739,al_libmaj#438740,al_monnaie#438747,al_numbmp#438749,... 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 (24)
+- == Final Plan ==
   * HashAggregate (16)
   +- ShuffleQueryStage (15), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (14)
         +- * HashAggregate (13)
            +- * 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 ==
   HashAggregate (23)
   +- Exchange (22)
      +- HashAggregate (21)
         +- HashAggregate (20)
            +- Exchange (19)
               +- HashAggregate (18)
                  +- Union (17)
                     :- 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#438204, al_classe#438223, al_codcha#438250, al_codsit#438213, al_coduti#438212, al_codval#438203, al_comment#438248, al_datede#438246, al_datefi#438258, al_datmaj#438211, al_envadm#438219, al_flicpt#438245, al_flsej#438244, al_fltele#438249, al_forfai#438222, al_icd#438260, al_int_spe#438255, al_int_std#438254, al_letadm#438218, al_letads#438251, al_lib30#438206, al_libmaj#438207, al_monnaie#438214, al_numbmp#438216, al_numcpt#438247, al_ordre#438217, al_primai#438259, al_prior#438209, al_rcp#438257, al_rembours#438225, al_revers#438224, al_sites#438252, al_spl_trans#438256, al_taux#438208, al_taux_r#438221, al_taux_t1r#438235, al_taux_t1#438226, al_taux_t2r#438236, al_taux_t2#438227, al_taux_t3r#438237, al_taux_t3#438228, al_taux_t4r#438238, al_taux_t4#438229, al_taux_t5r#438239, al_taux_t5#438230, al_taux_t6r#438240, al_taux_t6#438231, al_taux_t7r#438241, al_taux_t7#438232, al_taux_t8r#438242, al_taux_t8#438233, al_taux_t9r#438243, al_taux_t9#438234, al_typexa#438215, al_type#438210, al_type_icd#438261, al_t_red#438220, al_urg#438253, al_valcou#438205]
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#438204, al_classe#438223, al_codcha#438250, al_codsit#438213, al_coduti#438212, al_codval#438203, al_comment#438248, al_datede#438246, al_datefi#438258, al_datmaj#438211, al_envadm#438219, al_flicpt#438245, al_flsej#438244, al_fltele#438249, al_forfai#438222, al_icd#438260, al_int_spe#438255, al_int_std#438254, al_letadm#438218, al_letads#438251, al_lib30#438206, al_libmaj#438207, al_monnaie#438214, al_numbmp#438216, al_numcpt#438247, al_ordre#438217, al_primai#438259, al_prior#438209, al_rcp#438257, al_rembours#438225, al_revers#438224, al_sites#438252, al_spl_trans#438256, al_taux#438208, al_taux_r#438221, al_taux_t1r#438235, al_taux_t1#438226, al_taux_t2r#438236, al_taux_t2#438227, al_taux_t3r#438237, al_taux_t3#438228, al_taux_t4r#438238, al_taux_t4#438229, al_taux_t5r#438239, al_taux_t5#438230, al_taux_t6r#438240, al_taux_t6#438231, al_taux_t7r#438241, al_taux_t7#438232, al_taux_t8r#438242, al_taux_t8#438233, al_taux_t9r#438243, al_taux_t9#438234, al_typexa#438215, al_type#438210, al_type_icd#438261, al_t_red#438220, al_urg#438253, al_valcou#438205]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#438203)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#438203)), MOB) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#438204)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#438204)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#438205)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#438205)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#438206)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#438206)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#438207)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#438207)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#438208)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#438208)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#438209)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#438209)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#438210)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type#438210)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#438211)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#438211)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#438212)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#438212)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#438213)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#438213)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#438214)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#438214)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#438215)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#438215)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#438216)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#438216)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#438217)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#438217)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#438218)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#438218)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#438219)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#438219)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#438220)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#438220)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#438221)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#438221)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#438222)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#438222)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#438223)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#438223)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#438224)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#438224)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#438225)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#438225)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#438226)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#438226)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#438227)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#438227)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#438228)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#438228)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#438229)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#438229)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#438230)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#438230)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#438231)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#438231)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#438232)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#438232)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#438233)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#438233)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#438234)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#438234)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#438235)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#438235)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#438236)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#438236)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#438237)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#438237)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#438238)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#438238)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#438239)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#438239)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#438240)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#438240)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#438241)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#438241)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#438242)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#438242)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#438243)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#438243)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#438244)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#438244)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#438245)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#438245)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#438246)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#438246)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#438247)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#438247)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#438248)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#438248)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#438249)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#438249)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#438250)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#438250)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#438251)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#438251)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#438252)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#438252)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#438253)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#438253)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#438254)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#438254)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#438255)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#438255)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#438256)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#438256)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#438257)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#438257)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#438258)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#438258)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#438259)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#438259)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#438260)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#438260)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#438261)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#438261)), 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#438204 AS AL_ANNVAL_438378#438616, al_classe#438223 AS AL_CLASSE_438397#438617, al_codcha#438250 AS AL_CODCHA_438424#438618, al_codsit#438213 AS AL_CODSIT_438387#438619, al_coduti#438212 AS AL_CODUTI_438386#438620, al_codval#438203 AS AL_CODVAL_438377#438621, al_comment#438248 AS AL_COMMENT_438422#438622, al_datede#438246 AS AL_DATEDE_438420#438623, al_datefi#438258 AS AL_DATEFI_438432#438624, al_datmaj#438211 AS AL_DATMAJ_438385#438625, al_envadm#438219 AS AL_ENVADM_438393#438626, al_flicpt#438245 AS AL_FLICPT_438419#438627, al_flsej#438244 AS AL_FLSEJ_438418#438628, al_fltele#438249 AS AL_FLTELE_438423#438629, al_forfai#438222 AS AL_FORFAI_438396#438630, al_icd#438260 AS AL_ICD_438434#438631, al_int_spe#438255 AS AL_INT_SPE_438429#438632, al_int_std#438254 AS AL_INT_STD_438428#438633, al_letadm#438218 AS AL_LETADM_438392#438634, al_letads#438251 AS AL_LETADS_438425#438635, al_lib30#438206 AS AL_LIB30_438380#438636, al_libmaj#438207 AS AL_LIBMAJ_438381#438637, al_monnaie#438214 AS AL_MONNAIE_438388#438638, al_numbmp#438216 AS AL_NUMBMP_438390#438639, al_numcpt#438247 AS AL_NUMCPT_438421#438640, al_ordre#438217 AS AL_ORDRE_438391#438641, al_primai#438259 AS AL_PRIMAI_438433#438642, al_prior#438209 AS AL_PRIOR_438383#438643, al_rcp#438257 AS AL_RCP_438431#438644, al_rembours#438225 AS AL_REMBOURS_438399#438645, al_revers#438224 AS AL_REVERS_438398#438646, al_sites#438252 AS AL_SITES_438426#438647, al_spl_trans#438256 AS AL_SPL_TRANS_438430#438648, al_taux#438208 AS AL_TAUX_438382#438649, al_taux_r#438221 AS AL_TAUX_R_438395#438650, al_taux_t1r#438235 AS AL_TAUX_T1R_438409#438651, al_taux_t1#438226 AS AL_TAUX_T1_438400#438652, al_taux_t2r#438236 AS AL_TAUX_T2R_438410#438653, al_taux_t2#438227 AS AL_TAUX_T2_438401#438654, al_taux_t3r#438237 AS AL_TAUX_T3R_438411#438655, al_taux_t3#438228 AS AL_TAUX_T3_438402#438656, al_taux_t4r#438238 AS AL_TAUX_T4R_438412#438657, al_taux_t4#438229 AS AL_TAUX_T4_438403#438658, al_taux_t5r#438239 AS AL_TAUX_T5R_438413#438659, al_taux_t5#438230 AS AL_TAUX_T5_438404#438660, al_taux_t6r#438240 AS AL_TAUX_T6R_438414#438661, al_taux_t6#438231 AS AL_TAUX_T6_438405#438662, al_taux_t7r#438241 AS AL_TAUX_T7R_438415#438663, al_taux_t7#438232 AS AL_TAUX_T7_438406#438664, al_taux_t8r#438242 AS AL_TAUX_T8R_438416#438665, al_taux_t8#438233 AS AL_TAUX_T8_438407#438666, al_taux_t9r#438243 AS AL_TAUX_T9R_438417#438667, al_taux_t9#438234 AS AL_TAUX_T9_438408#438668, al_typexa#438215 AS AL_TYPEXA_438389#438669, al_type#438210 AS AL_TYPE_438384#438670, al_type_icd#438261 AS AL_TYPE_ICD_438435#438671, al_t_red#438220 AS AL_T_RED_438394#438672, al_urg#438253 AS AL_URG_438427#438673, al_valcou#438205 AS AL_VALCOU_438379#438674, null AS ORIGINE_440156#438675]
Input [59]: [al_annval#438204, al_classe#438223, al_codcha#438250, al_codsit#438213, al_coduti#438212, al_codval#438203, al_comment#438248, al_datede#438246, al_datefi#438258, al_datmaj#438211, al_envadm#438219, al_flicpt#438245, al_flsej#438244, al_fltele#438249, al_forfai#438222, al_icd#438260, al_int_spe#438255, al_int_std#438254, al_letadm#438218, al_letads#438251, al_lib30#438206, al_libmaj#438207, al_monnaie#438214, al_numbmp#438216, al_numcpt#438247, al_ordre#438217, al_primai#438259, al_prior#438209, al_rcp#438257, al_rembours#438225, al_revers#438224, al_sites#438252, al_spl_trans#438256, al_taux#438208, al_taux_r#438221, al_taux_t1r#438235, al_taux_t1#438226, al_taux_t2r#438236, al_taux_t2#438227, al_taux_t3r#438237, al_taux_t3#438228, al_taux_t4r#438238, al_taux_t4#438229, al_taux_t5r#438239, al_taux_t5#438230, al_taux_t6r#438240, al_taux_t6#438231, al_taux_t7r#438241, al_taux_t7#438232, al_taux_t8r#438242, al_taux_t8#438233, al_taux_t9r#438243, al_taux_t9#438234, al_typexa#438215, al_type#438210, al_type_icd#438261, al_t_red#438220, al_urg#438253, al_valcou#438205]

(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#438737, al_classe#438756, al_codcha#438783, al_codsit#438746, al_coduti#438745, al_codval#438736, al_comment#438781, al_datede#438779, al_datefi#438791, al_datmaj#438744, al_envadm#438752, al_flicpt#438778, al_flsej#438777, al_fltele#438782, al_forfai#438755, al_icd#438793, al_int_spe#438788, al_int_std#438787, al_letadm#438751, al_letads#438784, al_lib30#438739, al_libmaj#438740, al_monnaie#438747, al_numbmp#438749, al_numcpt#438780, al_ordre#438750, al_primai#438792, al_prior#438742, al_rcp#438790, al_rembours#438758, al_revers#438757, al_sites#438785, al_spl_trans#438789, al_taux#438741, al_taux_r#438754, al_taux_t1r#438768, al_taux_t1#438759, al_taux_t2r#438769, al_taux_t2#438760, al_taux_t3r#438770, al_taux_t3#438761, al_taux_t4r#438771, al_taux_t4#438762, al_taux_t5r#438772, al_taux_t5#438763, al_taux_t6r#438773, al_taux_t6#438764, al_taux_t7r#438774, al_taux_t7#438765, al_taux_t8r#438775, al_taux_t8#438766, al_taux_t9r#438776, al_taux_t9#438767, al_typexa#438748, al_type#438743, al_type_icd#438794, al_t_red#438753, al_urg#438786, al_valcou#438738]
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#438737, al_classe#438756, al_codcha#438783, al_codsit#438746, al_coduti#438745, al_codval#438736, al_comment#438781, al_datede#438779, al_datefi#438791, al_datmaj#438744, al_envadm#438752, al_flicpt#438778, al_flsej#438777, al_fltele#438782, al_forfai#438755, al_icd#438793, al_int_spe#438788, al_int_std#438787, al_letadm#438751, al_letads#438784, al_lib30#438739, al_libmaj#438740, al_monnaie#438747, al_numbmp#438749, al_numcpt#438780, al_ordre#438750, al_primai#438792, al_prior#438742, al_rcp#438790, al_rembours#438758, al_revers#438757, al_sites#438785, al_spl_trans#438789, al_taux#438741, al_taux_r#438754, al_taux_t1r#438768, al_taux_t1#438759, al_taux_t2r#438769, al_taux_t2#438760, al_taux_t3r#438770, al_taux_t3#438761, al_taux_t4r#438771, al_taux_t4#438762, al_taux_t5r#438772, al_taux_t5#438763, al_taux_t6r#438773, al_taux_t6#438764, al_taux_t7r#438774, al_taux_t7#438765, al_taux_t8r#438775, al_taux_t8#438766, al_taux_t9r#438776, al_taux_t9#438767, al_typexa#438748, al_type#438743, al_type_icd#438794, al_t_red#438753, al_urg#438786, al_valcou#438738]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#438736)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#438736)), MOB) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#438737)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#438737)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#438738)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#438738)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#438739)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#438739)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#438740)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#438740)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#438741)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#438741)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#438742)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#438742)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#438743)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type#438743)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#438744)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#438744)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#438745)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#438745)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#438746)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#438746)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#438747)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#438747)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#438748)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#438748)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#438749)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#438749)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#438750)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#438750)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#438751)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#438751)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#438752)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#438752)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#438753)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#438753)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#438754)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#438754)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#438755)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#438755)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#438756)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#438756)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#438757)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#438757)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#438758)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#438758)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#438759)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#438759)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#438760)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#438760)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#438761)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#438761)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#438762)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#438762)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#438763)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#438763)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#438764)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#438764)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#438765)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#438765)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#438766)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#438766)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#438767)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#438767)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#438768)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#438768)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#438769)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#438769)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#438770)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#438770)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#438771)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#438771)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#438772)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#438772)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#438773)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#438773)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#438774)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#438774)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#438775)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#438775)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#438776)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#438776)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#438777)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#438777)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#438778)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#438778)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#438779)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#438779)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#438780)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#438780)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#438781)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#438781)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#438782)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#438782)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#438783)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#438783)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#438784)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#438784)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#438785)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#438785)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#438786)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#438786)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#438787)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#438787)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#438788)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#438788)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#438789)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#438789)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#438790)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#438790)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#438791)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#438791)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#438792)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#438792)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#438793)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#438793)), MOB) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#438794)), MOB)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#438794)), 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#438737 AS AL_ANNVAL_438378#439149, al_classe#438756 AS AL_CLASSE_438397#439150, al_codcha#438783 AS AL_CODCHA_438424#439151, al_codsit#438746 AS AL_CODSIT_438387#439152, al_coduti#438745 AS AL_CODUTI_438386#439153, al_codval#438736 AS AL_CODVAL_438377#439154, al_comment#438781 AS AL_COMMENT_438422#439155, al_datede#438779 AS AL_DATEDE_438420#439156, al_datefi#438791 AS AL_DATEFI_438432#439157, al_datmaj#438744 AS AL_DATMAJ_438385#439158, al_envadm#438752 AS AL_ENVADM_438393#439159, al_flicpt#438778 AS AL_FLICPT_438419#439160, al_flsej#438777 AS AL_FLSEJ_438418#439161, al_fltele#438782 AS AL_FLTELE_438423#439162, al_forfai#438755 AS AL_FORFAI_438396#439163, al_icd#438793 AS AL_ICD_438434#439164, al_int_spe#438788 AS AL_INT_SPE_438429#439165, al_int_std#438787 AS AL_INT_STD_438428#439166, al_letadm#438751 AS AL_LETADM_438392#439167, al_letads#438784 AS AL_LETADS_438425#439168, al_lib30#438739 AS AL_LIB30_438380#439169, al_libmaj#438740 AS AL_LIBMAJ_438381#439170, al_monnaie#438747 AS AL_MONNAIE_438388#439171, al_numbmp#438749 AS AL_NUMBMP_438390#439172, al_numcpt#438780 AS AL_NUMCPT_438421#439173, al_ordre#438750 AS AL_ORDRE_438391#439174, al_primai#438792 AS AL_PRIMAI_438433#439175, al_prior#438742 AS AL_PRIOR_438383#439176, al_rcp#438790 AS AL_RCP_438431#439177, al_rembours#438758 AS AL_REMBOURS_438399#439178, al_revers#438757 AS AL_REVERS_438398#439179, al_sites#438785 AS AL_SITES_438426#439180, al_spl_trans#438789 AS AL_SPL_TRANS_438430#439181, al_taux#438741 AS AL_TAUX_438382#439182, al_taux_r#438754 AS AL_TAUX_R_438395#439183, al_taux_t1r#438768 AS AL_TAUX_T1R_438409#439184, al_taux_t1#438759 AS AL_TAUX_T1_438400#439185, al_taux_t2r#438769 AS AL_TAUX_T2R_438410#439186, al_taux_t2#438760 AS AL_TAUX_T2_438401#439187, al_taux_t3r#438770 AS AL_TAUX_T3R_438411#439188, al_taux_t3#438761 AS AL_TAUX_T3_438402#439189, al_taux_t4r#438771 AS AL_TAUX_T4R_438412#439190, al_taux_t4#438762 AS AL_TAUX_T4_438403#439191, al_taux_t5r#438772 AS AL_TAUX_T5R_438413#439192, al_taux_t5#438763 AS AL_TAUX_T5_438404#439193, al_taux_t6r#438773 AS AL_TAUX_T6R_438414#439194, al_taux_t6#438764 AS AL_TAUX_T6_438405#439195, al_taux_t7r#438774 AS AL_TAUX_T7R_438415#439196, al_taux_t7#438765 AS AL_TAUX_T7_438406#439197, al_taux_t8r#438775 AS AL_TAUX_T8R_438416#439198, al_taux_t8#438766 AS AL_TAUX_T8_438407#439199, al_taux_t9r#438776 AS AL_TAUX_T9R_438417#439200, al_taux_t9#438767 AS AL_TAUX_T9_438408#439201, al_typexa#438748 AS AL_TYPEXA_438389#439202, al_type#438743 AS AL_TYPE_438384#439203, al_type_icd#438794 AS AL_TYPE_ICD_438435#439204, al_t_red#438753 AS AL_T_RED_438394#439205, al_urg#438786 AS AL_URG_438427#439206, al_valcou#438738 AS AL_VALCOU_438379#439207, null AS ORIGINE_440156#439208]
Input [59]: [al_annval#438737, al_classe#438756, al_codcha#438783, al_codsit#438746, al_coduti#438745, al_codval#438736, al_comment#438781, al_datede#438779, al_datefi#438791, al_datmaj#438744, al_envadm#438752, al_flicpt#438778, al_flsej#438777, al_fltele#438782, al_forfai#438755, al_icd#438793, al_int_spe#438788, al_int_std#438787, al_letadm#438751, al_letads#438784, al_lib30#438739, al_libmaj#438740, al_monnaie#438747, al_numbmp#438749, al_numcpt#438780, al_ordre#438750, al_primai#438792, al_prior#438742, al_rcp#438790, al_rembours#438758, al_revers#438757, al_sites#438785, al_spl_trans#438789, al_taux#438741, al_taux_r#438754, al_taux_t1r#438768, al_taux_t1#438759, al_taux_t2r#438769, al_taux_t2#438760, al_taux_t3r#438770, al_taux_t3#438761, al_taux_t4r#438771, al_taux_t4#438762, al_taux_t5r#438772, al_taux_t5#438763, al_taux_t6r#438773, al_taux_t6#438764, al_taux_t7r#438774, al_taux_t7#438765, al_taux_t8r#438775, al_taux_t8#438766, al_taux_t9r#438776, al_taux_t9#438767, al_typexa#438748, al_type#438743, al_type_icd#438794, al_t_red#438753, al_urg#438786, al_valcou#438738]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Keys [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]

(9) Exchange
Input [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Arguments: hashpartitioning(AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26705]

(10) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Arguments: 0

(11) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Keys [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Functions: []
Aggregate Attributes: []
Results: []

(13) HashAggregate [codegen id : 4]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#440232L]
Results [1]: [count#440233L]

(14) Exchange
Input [1]: [count#440233L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26814]

(15) ShuffleQueryStage
Output [1]: [count#440233L]
Arguments: 1

(16) HashAggregate [codegen id : 5]
Input [1]: [count#440233L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#440229L]
Results [1]: [count(1)#440229L AS count#440230L]

(17) Union

(18) HashAggregate
Input [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Keys [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]

(19) Exchange
Input [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Arguments: hashpartitioning(AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26673]

(20) HashAggregate
Input [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Keys [60]: [AL_ANNVAL_438378#438616, AL_CLASSE_438397#438617, AL_CODCHA_438424#438618, AL_CODSIT_438387#438619, AL_CODUTI_438386#438620, AL_CODVAL_438377#438621, AL_COMMENT_438422#438622, AL_DATEDE_438420#438623, AL_DATEFI_438432#438624, AL_DATMAJ_438385#438625, AL_ENVADM_438393#438626, AL_FLICPT_438419#438627, AL_FLSEJ_438418#438628, AL_FLTELE_438423#438629, AL_FORFAI_438396#438630, AL_ICD_438434#438631, AL_INT_SPE_438429#438632, AL_INT_STD_438428#438633, AL_LETADM_438392#438634, AL_LETADS_438425#438635, AL_LIB30_438380#438636, AL_LIBMAJ_438381#438637, AL_MONNAIE_438388#438638, AL_NUMBMP_438390#438639, AL_NUMCPT_438421#438640, AL_ORDRE_438391#438641, AL_PRIMAI_438433#438642, AL_PRIOR_438383#438643, AL_RCP_438431#438644, AL_REMBOURS_438399#438645, AL_REVERS_438398#438646, AL_SITES_438426#438647, AL_SPL_TRANS_438430#438648, AL_TAUX_438382#438649, AL_TAUX_R_438395#438650, AL_TAUX_T1R_438409#438651, AL_TAUX_T1_438400#438652, AL_TAUX_T2R_438410#438653, AL_TAUX_T2_438401#438654, AL_TAUX_T3R_438411#438655, AL_TAUX_T3_438402#438656, AL_TAUX_T4R_438412#438657, AL_TAUX_T4_438403#438658, AL_TAUX_T5R_438413#438659, AL_TAUX_T5_438404#438660, AL_TAUX_T6R_438414#438661, AL_TAUX_T6_438405#438662, AL_TAUX_T7R_438415#438663, AL_TAUX_T7_438406#438664, AL_TAUX_T8R_438416#438665, AL_TAUX_T8_438407#438666, AL_TAUX_T9R_438417#438667, AL_TAUX_T9_438408#438668, AL_TYPEXA_438389#438669, AL_TYPE_438384#438670, AL_TYPE_ICD_438435#438671, AL_T_RED_438394#438672, AL_URG_438427#438673, AL_VALCOU_438379#438674, ORIGINE_440156#438675]
Functions: []
Aggregate Attributes: []
Results: []

(21) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#440232L]
Results [1]: [count#440233L]

(22) Exchange
Input [1]: [count#440233L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26677]

(23) HashAggregate
Input [1]: [count#440233L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#440229L]
Results [1]: [count(1)#440229L AS count#440230L]

(24) AdaptiveSparkPlan
Output [1]: [count#440230L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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