hdh-spark-job - Details for Query 1366

Submitted Time: 2026/10/23 13:28:08
Duration: 6 s
Succeeded Jobs: 1366 1368 1370

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: 10 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 10 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: 2 ms peak memory: 64.2 MiB number of output rows: 131 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 33.0 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 262 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 3 ms (1 ms, 1 ms, 1 ms (stage 1976.0: task 1724)) 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: 262 local bytes read: 31.5 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)) 211.9 KiB (105.9 KiB, 105.9 KiB, 105.9 KiB (stage 1976.0: task 1723)) 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)) 31.5 KiB (15.7 KiB, 15.7 KiB, 15.7 KiB (stage 1976.0: task 1723))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.5 s (730 ms, 815 ms, 815 ms (stage 1976.0: task 1724))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1.5 s (697 ms, 781 ms, 781 ms (stage 1976.0: task 1724)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1976.0: task 1723)) number of output rows: 262 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 1976.0: task 1723))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 771 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Filter number of output rows: 131"]; 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: 823 ms"; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="Filter number of output rows: 131"]; 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=37003]

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

HashAggregate(keys=[AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=36718]

WholeStageCodegen (3)

Union

Project [al_annval#674547 AS AL_ANNVAL_438378#675108, al_classe#674566 AS AL_CLASSE_438397#675109, al_codcha#674593 AS AL_CODCHA_438424#675110, al_codsit#674556 AS AL_CODSIT_438387#675111, al_coduti#674555 AS AL_CODUTI_438386#675112, al_codval#674546 AS AL_CODVAL_438377#675113, al_comment#674591 AS AL_COMMENT_438422#675114, al_datede#674589 AS AL_DATEDE_438420#675115, al_datefi#674601 AS AL_DATEFI_438432#675116, al_datmaj#674554 AS AL_DATMAJ_438385#675117, al_envadm#674562 AS AL_ENVADM_438393#675118, al_flicpt#674588 AS AL_FLICPT_438419#675119, al_flsej#674587 AS AL_FLSEJ_438418#675120, al_fltele#674592 AS AL_FLTELE_438423#675121, al_forfai#674565 AS AL_FORFAI_438396#675122, al_icd#674603 AS AL_ICD_438434#675123, al_int_spe#674598 AS AL_INT_SPE_438429#675124, al_int_std#674597 AS AL_INT_STD_438428#675125, al_letadm#674561 AS AL_LETADM_438392#675126, al_letads#674594 AS AL_LETADS_438425#675127, al_lib30#674549 AS AL_LIB30_438380#675128, al_libmaj#674550 AS AL_LIBMAJ_438381#675129, al_monnaie#674557 AS AL_MONNAIE_438388#675130, al_numbmp#674559 AS AL_NUMBMP_438390#675131, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#674546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#674546)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#674547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#674547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#674548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#674548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#674549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#674549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#674550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#674550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#674551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#674551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#674552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#674552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#674553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#674553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#674554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#674554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#674555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#674555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#674556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#674556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#674557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#674557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#674558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#674558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#674559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#674559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#674560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#674560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#674561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#674561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#674562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#674562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#674563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#674563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#674564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#674564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#674565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#674565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#674566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#674566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#674567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#674567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#674568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#674568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#674569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#674569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#674570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#674570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#674571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#674571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#674572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#674572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#674573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#674573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#674574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#674574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#674575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#674575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#674576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#674576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#674577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#674577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#674578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#674578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#674579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#674579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#674580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#674580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#674581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#674581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#674582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#674582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#674583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#674583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#674584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#674584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#674585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#674585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#674586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#674586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#674587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#674587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#674588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#674588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#674589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#674589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#674590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#674590)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#674591)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#674591)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#674592)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#674592)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#674593)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#674593)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#674594)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#674594)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#674595)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#674595)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#674596)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#674596)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#674597)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#674597)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#674598)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#674598)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#674599)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#674599)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#674600)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#674600)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#674601)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#674601)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#674602)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#674602)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#674603)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#674603)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#674604)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#674604)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) 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#674547,al_classe#674566,al_codcha#674593,al_codsit#674556,al_coduti#674555,al_codval#674546,al_comment#674591,al_datede#674589,al_datefi#674601,al_datmaj#674554,al_envadm#674562,al_flicpt#674588,al_flsej#674587,al_fltele#674592,al_forfai#674565,al_icd#674603,al_int_spe#674598,al_int_std#674597,al_letadm#674561,al_letads#674594,al_lib30#674549,al_libmaj#674550,al_monnaie#674557,al_numbmp#674559,... 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#675433 AS AL_ANNVAL_438378#676100, al_classe#675452 AS AL_CLASSE_438397#676101, al_codcha#675479 AS AL_CODCHA_438424#676102, al_codsit#675442 AS AL_CODSIT_438387#676103, al_coduti#675441 AS AL_CODUTI_438386#676104, al_codval#675432 AS AL_CODVAL_438377#676105, al_comment#675477 AS AL_COMMENT_438422#676106, al_datede#675475 AS AL_DATEDE_438420#676107, al_datefi#675487 AS AL_DATEFI_438432#676108, al_datmaj#675440 AS AL_DATMAJ_438385#676109, al_envadm#675448 AS AL_ENVADM_438393#676110, al_flicpt#675474 AS AL_FLICPT_438419#676111, al_flsej#675473 AS AL_FLSEJ_438418#676112, al_fltele#675478 AS AL_FLTELE_438423#676113, al_forfai#675451 AS AL_FORFAI_438396#676114, al_icd#675489 AS AL_ICD_438434#676115, al_int_spe#675484 AS AL_INT_SPE_438429#676116, al_int_std#675483 AS AL_INT_STD_438428#676117, al_letadm#675447 AS AL_LETADM_438392#676118, al_letads#675480 AS AL_LETADS_438425#676119, al_lib30#675435 AS AL_LIB30_438380#676120, al_libmaj#675436 AS AL_LIBMAJ_438381#676121, al_monnaie#675443 AS AL_MONNAIE_438388#676122, al_numbmp#675445 AS AL_NUMBMP_438390#676123, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#675432)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#675432)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#675433)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#675433)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#675434)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#675434)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#675435)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#675435)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#675436)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#675436)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#675437)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#675437)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#675438)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#675438)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#675439)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#675439)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#675440)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#675440)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#675441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#675441)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#675442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#675442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#675443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#675443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#675444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#675444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#675445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#675445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#675446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#675446)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#675447)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#675447)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#675448)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#675448)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#675449)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#675449)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#675450)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#675450)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#675451)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#675451)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#675452)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#675452)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#675453)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#675453)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#675454)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#675454)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#675455)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#675455)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#675456)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#675456)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#675457)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#675457)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#675458)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#675458)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#675459)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#675459)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#675460)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#675460)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#675461)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#675461)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#675462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#675462)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#675463)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#675463)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#675464)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#675464)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#675465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#675465)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#675466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#675466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#675467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#675467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#675468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#675468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#675469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#675469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#675470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#675470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#675471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#675471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#675472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#675472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#675473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#675473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#675474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#675474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#675475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#675475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#675476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#675476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#675477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#675477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#675478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#675478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#675479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#675479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#675480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#675480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#675481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#675481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#675482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#675482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#675483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#675483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#675484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#675484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#675485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#675485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#675486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#675486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#675487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#675487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#675488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#675488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#675489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#675489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#675490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#675490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) 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#675433,al_classe#675452,al_codcha#675479,al_codsit#675442,al_coduti#675441,al_codval#675432,al_comment#675477,al_datede#675475,al_datefi#675487,al_datmaj#675440,al_envadm#675448,al_flicpt#675474,al_flsej#675473,al_fltele#675478,al_forfai#675451,al_icd#675489,al_int_spe#675484,al_int_std#675483,al_letadm#675447,al_letads#675480,al_lib30#675435,al_libmaj#675436,al_monnaie#675443,al_numbmp#675445,... 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=211.9 KiB, rowCount=262)
                     +- 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#674547, al_classe#674566, al_codcha#674593, al_codsit#674556, al_coduti#674555, al_codval#674546, al_comment#674591, al_datede#674589, al_datefi#674601, al_datmaj#674554, al_envadm#674562, al_flicpt#674588, al_flsej#674587, al_fltele#674592, al_forfai#674565, al_icd#674603, al_int_spe#674598, al_int_std#674597, al_letadm#674561, al_letads#674594, al_lib30#674549, al_libmaj#674550, al_monnaie#674557, al_numbmp#674559, al_numcpt#674590, al_ordre#674560, al_primai#674602, al_prior#674552, al_rcp#674600, al_rembours#674568, al_revers#674567, al_sites#674595, al_spl_trans#674599, al_taux#674551, al_taux_r#674564, al_taux_t1r#674578, al_taux_t1#674569, al_taux_t2r#674579, al_taux_t2#674570, al_taux_t3r#674580, al_taux_t3#674571, al_taux_t4r#674581, al_taux_t4#674572, al_taux_t5r#674582, al_taux_t5#674573, al_taux_t6r#674583, al_taux_t6#674574, al_taux_t7r#674584, al_taux_t7#674575, al_taux_t8r#674585, al_taux_t8#674576, al_taux_t9r#674586, al_taux_t9#674577, al_typexa#674558, al_type#674553, al_type_icd#674604, al_t_red#674563, al_urg#674596, al_valcou#674548]
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#674547, al_classe#674566, al_codcha#674593, al_codsit#674556, al_coduti#674555, al_codval#674546, al_comment#674591, al_datede#674589, al_datefi#674601, al_datmaj#674554, al_envadm#674562, al_flicpt#674588, al_flsej#674587, al_fltele#674592, al_forfai#674565, al_icd#674603, al_int_spe#674598, al_int_std#674597, al_letadm#674561, al_letads#674594, al_lib30#674549, al_libmaj#674550, al_monnaie#674557, al_numbmp#674559, al_numcpt#674590, al_ordre#674560, al_primai#674602, al_prior#674552, al_rcp#674600, al_rembours#674568, al_revers#674567, al_sites#674595, al_spl_trans#674599, al_taux#674551, al_taux_r#674564, al_taux_t1r#674578, al_taux_t1#674569, al_taux_t2r#674579, al_taux_t2#674570, al_taux_t3r#674580, al_taux_t3#674571, al_taux_t4r#674581, al_taux_t4#674572, al_taux_t5r#674582, al_taux_t5#674573, al_taux_t6r#674583, al_taux_t6#674574, al_taux_t7r#674584, al_taux_t7#674575, al_taux_t8r#674585, al_taux_t8#674576, al_taux_t9r#674586, al_taux_t9#674577, al_typexa#674558, al_type#674553, al_type_icd#674604, al_t_red#674563, al_urg#674596, al_valcou#674548]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#674546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#674546)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#674547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#674547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#674548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#674548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#674549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#674549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#674550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#674550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#674551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#674551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#674552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#674552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#674553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#674553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#674554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#674554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#674555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#674555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#674556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#674556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#674557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#674557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#674558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#674558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#674559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#674559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#674560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#674560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#674561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#674561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#674562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#674562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#674563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#674563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#674564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#674564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#674565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#674565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#674566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#674566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#674567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#674567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#674568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#674568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#674569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#674569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#674570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#674570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#674571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#674571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#674572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#674572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#674573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#674573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#674574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#674574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#674575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#674575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#674576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#674576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#674577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#674577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#674578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#674578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#674579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#674579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#674580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#674580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#674581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#674581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#674582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#674582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#674583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#674583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#674584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#674584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#674585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#674585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#674586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#674586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#674587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#674587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#674588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#674588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#674589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#674589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#674590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#674590)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#674591)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#674591)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#674592)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#674592)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#674593)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#674593)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#674594)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#674594)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#674595)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#674595)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#674596)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#674596)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#674597)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#674597)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#674598)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#674598)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#674599)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#674599)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#674600)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#674600)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#674601)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#674601)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#674602)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#674602)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#674603)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#674603)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#674604)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#674604)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)

(3) Project [codegen id : 1]
Output [60]: [al_annval#674547 AS AL_ANNVAL_438378#675108, al_classe#674566 AS AL_CLASSE_438397#675109, al_codcha#674593 AS AL_CODCHA_438424#675110, al_codsit#674556 AS AL_CODSIT_438387#675111, al_coduti#674555 AS AL_CODUTI_438386#675112, al_codval#674546 AS AL_CODVAL_438377#675113, al_comment#674591 AS AL_COMMENT_438422#675114, al_datede#674589 AS AL_DATEDE_438420#675115, al_datefi#674601 AS AL_DATEFI_438432#675116, al_datmaj#674554 AS AL_DATMAJ_438385#675117, al_envadm#674562 AS AL_ENVADM_438393#675118, al_flicpt#674588 AS AL_FLICPT_438419#675119, al_flsej#674587 AS AL_FLSEJ_438418#675120, al_fltele#674592 AS AL_FLTELE_438423#675121, al_forfai#674565 AS AL_FORFAI_438396#675122, al_icd#674603 AS AL_ICD_438434#675123, al_int_spe#674598 AS AL_INT_SPE_438429#675124, al_int_std#674597 AS AL_INT_STD_438428#675125, al_letadm#674561 AS AL_LETADM_438392#675126, al_letads#674594 AS AL_LETADS_438425#675127, al_lib30#674549 AS AL_LIB30_438380#675128, al_libmaj#674550 AS AL_LIBMAJ_438381#675129, al_monnaie#674557 AS AL_MONNAIE_438388#675130, al_numbmp#674559 AS AL_NUMBMP_438390#675131, al_numcpt#674590 AS AL_NUMCPT_438421#675132, al_ordre#674560 AS AL_ORDRE_438391#675133, al_primai#674602 AS AL_PRIMAI_438433#675134, al_prior#674552 AS AL_PRIOR_438383#675135, al_rcp#674600 AS AL_RCP_438431#675187, al_rembours#674568 AS AL_REMBOURS_438399#675188, al_revers#674567 AS AL_REVERS_438398#675189, al_sites#674595 AS AL_SITES_438426#675190, al_spl_trans#674599 AS AL_SPL_TRANS_438430#675191, al_taux#674551 AS AL_TAUX_438382#675192, al_taux_r#674564 AS AL_TAUX_R_438395#675193, al_taux_t1r#674578 AS AL_TAUX_T1R_438409#675194, al_taux_t1#674569 AS AL_TAUX_T1_438400#675195, al_taux_t2r#674579 AS AL_TAUX_T2R_438410#675196, al_taux_t2#674570 AS AL_TAUX_T2_438401#675197, al_taux_t3r#674580 AS AL_TAUX_T3R_438411#675198, al_taux_t3#674571 AS AL_TAUX_T3_438402#675199, al_taux_t4r#674581 AS AL_TAUX_T4R_438412#675200, al_taux_t4#674572 AS AL_TAUX_T4_438403#675201, al_taux_t5r#674582 AS AL_TAUX_T5R_438413#675202, al_taux_t5#674573 AS AL_TAUX_T5_438404#675203, al_taux_t6r#674583 AS AL_TAUX_T6R_438414#675204, al_taux_t6#674574 AS AL_TAUX_T6_438405#675205, al_taux_t7r#674584 AS AL_TAUX_T7R_438415#675206, al_taux_t7#674575 AS AL_TAUX_T7_438406#675207, al_taux_t8r#674585 AS AL_TAUX_T8R_438416#675208, al_taux_t8#674576 AS AL_TAUX_T8_438407#675209, al_taux_t9r#674586 AS AL_TAUX_T9R_438417#675210, al_taux_t9#674577 AS AL_TAUX_T9_438408#675211, al_typexa#674558 AS AL_TYPEXA_438389#675212, al_type#674553 AS AL_TYPE_438384#675213, al_type_icd#674604 AS AL_TYPE_ICD_438435#675214, al_t_red#674563 AS AL_T_RED_438394#675215, al_urg#674596 AS AL_URG_438427#675216, al_valcou#674548 AS AL_VALCOU_438379#675217, null AS ORIGINE_440156#675218]
Input [59]: [al_annval#674547, al_classe#674566, al_codcha#674593, al_codsit#674556, al_coduti#674555, al_codval#674546, al_comment#674591, al_datede#674589, al_datefi#674601, al_datmaj#674554, al_envadm#674562, al_flicpt#674588, al_flsej#674587, al_fltele#674592, al_forfai#674565, al_icd#674603, al_int_spe#674598, al_int_std#674597, al_letadm#674561, al_letads#674594, al_lib30#674549, al_libmaj#674550, al_monnaie#674557, al_numbmp#674559, al_numcpt#674590, al_ordre#674560, al_primai#674602, al_prior#674552, al_rcp#674600, al_rembours#674568, al_revers#674567, al_sites#674595, al_spl_trans#674599, al_taux#674551, al_taux_r#674564, al_taux_t1r#674578, al_taux_t1#674569, al_taux_t2r#674579, al_taux_t2#674570, al_taux_t3r#674580, al_taux_t3#674571, al_taux_t4r#674581, al_taux_t4#674572, al_taux_t5r#674582, al_taux_t5#674573, al_taux_t6r#674583, al_taux_t6#674574, al_taux_t7r#674584, al_taux_t7#674575, al_taux_t8r#674585, al_taux_t8#674576, al_taux_t9r#674586, al_taux_t9#674577, al_typexa#674558, al_type#674553, al_type_icd#674604, al_t_red#674563, al_urg#674596, al_valcou#674548]

(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#675433, al_classe#675452, al_codcha#675479, al_codsit#675442, al_coduti#675441, al_codval#675432, al_comment#675477, al_datede#675475, al_datefi#675487, al_datmaj#675440, al_envadm#675448, al_flicpt#675474, al_flsej#675473, al_fltele#675478, al_forfai#675451, al_icd#675489, al_int_spe#675484, al_int_std#675483, al_letadm#675447, al_letads#675480, al_lib30#675435, al_libmaj#675436, al_monnaie#675443, al_numbmp#675445, al_numcpt#675476, al_ordre#675446, al_primai#675488, al_prior#675438, al_rcp#675486, al_rembours#675454, al_revers#675453, al_sites#675481, al_spl_trans#675485, al_taux#675437, al_taux_r#675450, al_taux_t1r#675464, al_taux_t1#675455, al_taux_t2r#675465, al_taux_t2#675456, al_taux_t3r#675466, al_taux_t3#675457, al_taux_t4r#675467, al_taux_t4#675458, al_taux_t5r#675468, al_taux_t5#675459, al_taux_t6r#675469, al_taux_t6#675460, al_taux_t7r#675470, al_taux_t7#675461, al_taux_t8r#675471, al_taux_t8#675462, al_taux_t9r#675472, al_taux_t9#675463, al_typexa#675444, al_type#675439, al_type_icd#675490, al_t_red#675449, al_urg#675482, al_valcou#675434]
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#675433, al_classe#675452, al_codcha#675479, al_codsit#675442, al_coduti#675441, al_codval#675432, al_comment#675477, al_datede#675475, al_datefi#675487, al_datmaj#675440, al_envadm#675448, al_flicpt#675474, al_flsej#675473, al_fltele#675478, al_forfai#675451, al_icd#675489, al_int_spe#675484, al_int_std#675483, al_letadm#675447, al_letads#675480, al_lib30#675435, al_libmaj#675436, al_monnaie#675443, al_numbmp#675445, al_numcpt#675476, al_ordre#675446, al_primai#675488, al_prior#675438, al_rcp#675486, al_rembours#675454, al_revers#675453, al_sites#675481, al_spl_trans#675485, al_taux#675437, al_taux_r#675450, al_taux_t1r#675464, al_taux_t1#675455, al_taux_t2r#675465, al_taux_t2#675456, al_taux_t3r#675466, al_taux_t3#675457, al_taux_t4r#675467, al_taux_t4#675458, al_taux_t5r#675468, al_taux_t5#675459, al_taux_t6r#675469, al_taux_t6#675460, al_taux_t7r#675470, al_taux_t7#675461, al_taux_t8r#675471, al_taux_t8#675462, al_taux_t9r#675472, al_taux_t9#675463, al_typexa#675444, al_type#675439, al_type_icd#675490, al_t_red#675449, al_urg#675482, al_valcou#675434]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#675432)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#675432)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#675433)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#675433)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#675434)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#675434)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#675435)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#675435)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#675436)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#675436)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#675437)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#675437)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#675438)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#675438)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#675439)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#675439)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#675440)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#675440)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#675441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#675441)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#675442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#675442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#675443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#675443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#675444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#675444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#675445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#675445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#675446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#675446)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#675447)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#675447)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#675448)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#675448)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#675449)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#675449)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#675450)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#675450)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#675451)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#675451)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#675452)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#675452)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#675453)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#675453)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#675454)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#675454)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#675455)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#675455)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#675456)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#675456)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#675457)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#675457)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#675458)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#675458)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#675459)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#675459)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#675460)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#675460)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#675461)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#675461)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#675462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#675462)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#675463)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#675463)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#675464)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#675464)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#675465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#675465)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#675466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#675466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#675467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#675467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#675468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#675468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#675469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#675469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#675470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#675470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#675471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#675471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#675472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#675472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#675473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#675473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#675474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#675474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#675475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#675475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#675476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#675476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#675477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#675477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#675478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#675478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#675479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#675479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#675480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#675480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#675481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#675481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#675482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#675482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#675483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#675483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#675484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#675484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#675485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#675485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#675486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#675486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#675487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#675487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#675488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#675488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#675489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#675489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#675490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#675490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)

(6) Project [codegen id : 2]
Output [60]: [al_annval#675433 AS AL_ANNVAL_438378#676100, al_classe#675452 AS AL_CLASSE_438397#676101, al_codcha#675479 AS AL_CODCHA_438424#676102, al_codsit#675442 AS AL_CODSIT_438387#676103, al_coduti#675441 AS AL_CODUTI_438386#676104, al_codval#675432 AS AL_CODVAL_438377#676105, al_comment#675477 AS AL_COMMENT_438422#676106, al_datede#675475 AS AL_DATEDE_438420#676107, al_datefi#675487 AS AL_DATEFI_438432#676108, al_datmaj#675440 AS AL_DATMAJ_438385#676109, al_envadm#675448 AS AL_ENVADM_438393#676110, al_flicpt#675474 AS AL_FLICPT_438419#676111, al_flsej#675473 AS AL_FLSEJ_438418#676112, al_fltele#675478 AS AL_FLTELE_438423#676113, al_forfai#675451 AS AL_FORFAI_438396#676114, al_icd#675489 AS AL_ICD_438434#676115, al_int_spe#675484 AS AL_INT_SPE_438429#676116, al_int_std#675483 AS AL_INT_STD_438428#676117, al_letadm#675447 AS AL_LETADM_438392#676118, al_letads#675480 AS AL_LETADS_438425#676119, al_lib30#675435 AS AL_LIB30_438380#676120, al_libmaj#675436 AS AL_LIBMAJ_438381#676121, al_monnaie#675443 AS AL_MONNAIE_438388#676122, al_numbmp#675445 AS AL_NUMBMP_438390#676123, al_numcpt#675476 AS AL_NUMCPT_438421#676124, al_ordre#675446 AS AL_ORDRE_438391#676125, al_primai#675488 AS AL_PRIMAI_438433#676126, al_prior#675438 AS AL_PRIOR_438383#676127, al_rcp#675486 AS AL_RCP_438431#676128, al_rembours#675454 AS AL_REMBOURS_438399#676129, al_revers#675453 AS AL_REVERS_438398#676130, al_sites#675481 AS AL_SITES_438426#676131, al_spl_trans#675485 AS AL_SPL_TRANS_438430#676132, al_taux#675437 AS AL_TAUX_438382#676133, al_taux_r#675450 AS AL_TAUX_R_438395#676134, al_taux_t1r#675464 AS AL_TAUX_T1R_438409#676135, al_taux_t1#675455 AS AL_TAUX_T1_438400#676136, al_taux_t2r#675465 AS AL_TAUX_T2R_438410#676137, al_taux_t2#675456 AS AL_TAUX_T2_438401#676138, al_taux_t3r#675466 AS AL_TAUX_T3R_438411#676139, al_taux_t3#675457 AS AL_TAUX_T3_438402#676140, al_taux_t4r#675467 AS AL_TAUX_T4R_438412#676141, al_taux_t4#675458 AS AL_TAUX_T4_438403#676142, al_taux_t5r#675468 AS AL_TAUX_T5R_438413#676143, al_taux_t5#675459 AS AL_TAUX_T5_438404#676144, al_taux_t6r#675469 AS AL_TAUX_T6R_438414#676145, al_taux_t6#675460 AS AL_TAUX_T6_438405#676146, al_taux_t7r#675470 AS AL_TAUX_T7R_438415#676147, al_taux_t7#675461 AS AL_TAUX_T7_438406#676148, al_taux_t8r#675471 AS AL_TAUX_T8R_438416#676149, al_taux_t8#675462 AS AL_TAUX_T8_438407#676150, al_taux_t9r#675472 AS AL_TAUX_T9R_438417#676151, al_taux_t9#675463 AS AL_TAUX_T9_438408#676152, al_typexa#675444 AS AL_TYPEXA_438389#676153, al_type#675439 AS AL_TYPE_438384#676154, al_type_icd#675490 AS AL_TYPE_ICD_438435#676155, al_t_red#675449 AS AL_T_RED_438394#676156, al_urg#675482 AS AL_URG_438427#676157, al_valcou#675434 AS AL_VALCOU_438379#676158, null AS ORIGINE_440156#676159]
Input [59]: [al_annval#675433, al_classe#675452, al_codcha#675479, al_codsit#675442, al_coduti#675441, al_codval#675432, al_comment#675477, al_datede#675475, al_datefi#675487, al_datmaj#675440, al_envadm#675448, al_flicpt#675474, al_flsej#675473, al_fltele#675478, al_forfai#675451, al_icd#675489, al_int_spe#675484, al_int_std#675483, al_letadm#675447, al_letads#675480, al_lib30#675435, al_libmaj#675436, al_monnaie#675443, al_numbmp#675445, al_numcpt#675476, al_ordre#675446, al_primai#675488, al_prior#675438, al_rcp#675486, al_rembours#675454, al_revers#675453, al_sites#675481, al_spl_trans#675485, al_taux#675437, al_taux_r#675450, al_taux_t1r#675464, al_taux_t1#675455, al_taux_t2r#675465, al_taux_t2#675456, al_taux_t3r#675466, al_taux_t3#675457, al_taux_t4r#675467, al_taux_t4#675458, al_taux_t5r#675468, al_taux_t5#675459, al_taux_t6r#675469, al_taux_t6#675460, al_taux_t7r#675470, al_taux_t7#675461, al_taux_t8r#675471, al_taux_t8#675462, al_taux_t9r#675472, al_taux_t9#675463, al_typexa#675444, al_type#675439, al_type_icd#675490, al_t_red#675449, al_urg#675482, al_valcou#675434]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Keys [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]

(9) Exchange
Input [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Arguments: hashpartitioning(AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=36718]

(10) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Arguments: 0

(11) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Keys [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(16) HashAggregate [codegen id : 5]
Input [1]: [count#677598L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#677053L]
Results [1]: [count(1)#677053L AS COL_ba26ab8e-af09-4718-96a6-77955d0c639c#677055L]

(17) Union

(18) HashAggregate
Input [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Keys [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]

(19) Exchange
Input [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Arguments: hashpartitioning(AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=36686]

(20) HashAggregate
Input [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Keys [60]: [AL_ANNVAL_438378#675108, AL_CLASSE_438397#675109, AL_CODCHA_438424#675110, AL_CODSIT_438387#675111, AL_CODUTI_438386#675112, AL_CODVAL_438377#675113, AL_COMMENT_438422#675114, AL_DATEDE_438420#675115, AL_DATEFI_438432#675116, AL_DATMAJ_438385#675117, AL_ENVADM_438393#675118, AL_FLICPT_438419#675119, AL_FLSEJ_438418#675120, AL_FLTELE_438423#675121, AL_FORFAI_438396#675122, AL_ICD_438434#675123, AL_INT_SPE_438429#675124, AL_INT_STD_438428#675125, AL_LETADM_438392#675126, AL_LETADS_438425#675127, AL_LIB30_438380#675128, AL_LIBMAJ_438381#675129, AL_MONNAIE_438388#675130, AL_NUMBMP_438390#675131, AL_NUMCPT_438421#675132, AL_ORDRE_438391#675133, AL_PRIMAI_438433#675134, AL_PRIOR_438383#675135, AL_RCP_438431#675187, AL_REMBOURS_438399#675188, AL_REVERS_438398#675189, AL_SITES_438426#675190, AL_SPL_TRANS_438430#675191, AL_TAUX_438382#675192, AL_TAUX_R_438395#675193, AL_TAUX_T1R_438409#675194, AL_TAUX_T1_438400#675195, AL_TAUX_T2R_438410#675196, AL_TAUX_T2_438401#675197, AL_TAUX_T3R_438411#675198, AL_TAUX_T3_438402#675199, AL_TAUX_T4R_438412#675200, AL_TAUX_T4_438403#675201, AL_TAUX_T5R_438413#675202, AL_TAUX_T5_438404#675203, AL_TAUX_T6R_438414#675204, AL_TAUX_T6_438405#675205, AL_TAUX_T7R_438415#675206, AL_TAUX_T7_438406#675207, AL_TAUX_T8R_438416#675208, AL_TAUX_T8_438407#675209, AL_TAUX_T9R_438417#675210, AL_TAUX_T9_438408#675211, AL_TYPEXA_438389#675212, AL_TYPE_438384#675213, AL_TYPE_ICD_438435#675214, AL_T_RED_438394#675215, AL_URG_438427#675216, AL_VALCOU_438379#675217, ORIGINE_440156#675218]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(23) HashAggregate
Input [1]: [count#677598L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#677053L]
Results [1]: [count(1)#677053L AS COL_ba26ab8e-af09-4718-96a6-77955d0c639c#677055L]

(24) AdaptiveSparkPlan
Output [1]: [COL_ba26ab8e-af09-4718-96a6-77955d0c639c#677055L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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