hdh-spark-job - Details for Query 1418

Submitted Time: 2026/10/23 13:29:11
Duration: 5 s
Succeeded Jobs: 1421 1424 1426

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: 9 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 9 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 2062.0: task 1801)) 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 2062.0: task 1801)) 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 2062.0: task 1801))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.5 s (752 ms, 786 ms, 786 ms (stage 2062.0: task 1802))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1.5 s (716 ms, 749 ms, 749 ms (stage 2062.0: task 1802)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 2062.0: task 1801)) 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 2062.0: task 1801))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 796 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: 814 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=38954]

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

HashAggregate(keys=[AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=38499]

WholeStageCodegen (3)

Union

Project [al_annval#712405 AS AL_ANNVAL_438378#712817, al_classe#712424 AS AL_CLASSE_438397#712818, al_codcha#712451 AS AL_CODCHA_438424#712819, al_codsit#712414 AS AL_CODSIT_438387#712820, al_coduti#712413 AS AL_CODUTI_438386#712821, al_codval#712404 AS AL_CODVAL_438377#712822, al_comment#712449 AS AL_COMMENT_438422#712823, al_datede#712447 AS AL_DATEDE_438420#712824, al_datefi#712459 AS AL_DATEFI_438432#712825, al_datmaj#712412 AS AL_DATMAJ_438385#712826, al_envadm#712420 AS AL_ENVADM_438393#712827, al_flicpt#712446 AS AL_FLICPT_438419#712828, al_flsej#712445 AS AL_FLSEJ_438418#712829, al_fltele#712450 AS AL_FLTELE_438423#712830, al_forfai#712423 AS AL_FORFAI_438396#712831, al_icd#712461 AS AL_ICD_438434#712832, al_int_spe#712456 AS AL_INT_SPE_438429#712833, al_int_std#712455 AS AL_INT_STD_438428#712834, al_letadm#712419 AS AL_LETADM_438392#712835, al_letads#712452 AS AL_LETADS_438425#712836, al_lib30#712407 AS AL_LIB30_438380#712837, al_libmaj#712408 AS AL_LIBMAJ_438381#712838, al_monnaie#712415 AS AL_MONNAIE_438388#712839, al_numbmp#712417 AS AL_NUMBMP_438390#712840, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#712404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#712404)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#712405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#712405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#712406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#712406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#712407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#712407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#712408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#712408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#712409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#712409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#712410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#712410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#712411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#712411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#712412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#712412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#712413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#712413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#712414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#712414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#712415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#712415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#712416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#712416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#712417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#712417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#712418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#712418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#712419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#712419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#712420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#712420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#712421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#712421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#712422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#712422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#712423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#712423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#712424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#712424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#712425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#712425)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#712426)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#712426)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#712427)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#712427)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#712428)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#712428)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#712429)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#712429)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#712430)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#712430)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#712431)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#712431)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#712432)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#712432)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#712433)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#712433)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#712434)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#712434)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#712435)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#712435)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#712436)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#712436)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#712437)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#712437)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#712438)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#712438)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#712439)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#712439)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#712440)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#712440)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#712441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#712441)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#712442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#712442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#712443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#712443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#712444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#712444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#712445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#712445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#712446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#712446)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#712447)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#712447)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#712448)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#712448)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#712449)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#712449)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#712450)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#712450)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#712451)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#712451)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#712452)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#712452)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#712453)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#712453)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#712454)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#712454)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#712455)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#712455)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#712456)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#712456)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#712457)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#712457)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#712458)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#712458)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#712459)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#712459)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#712460)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#712460)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#712461)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#712461)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#712462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#712462)), 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#712405,al_classe#712424,al_codcha#712451,al_codsit#712414,al_coduti#712413,al_codval#712404,al_comment#712449,al_datede#712447,al_datefi#712459,al_datmaj#712412,al_envadm#712420,al_flicpt#712446,al_flsej#712445,al_fltele#712450,al_forfai#712423,al_icd#712461,al_int_spe#712456,al_int_std#712455,al_letadm#712419,al_letads#712452,al_lib30#712407,al_libmaj#712408,al_monnaie#712415,al_numbmp#712417,... 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#712938 AS AL_ANNVAL_438378#713350, al_classe#712957 AS AL_CLASSE_438397#713351, al_codcha#712984 AS AL_CODCHA_438424#713352, al_codsit#712947 AS AL_CODSIT_438387#713353, al_coduti#712946 AS AL_CODUTI_438386#713354, al_codval#712937 AS AL_CODVAL_438377#713355, al_comment#712982 AS AL_COMMENT_438422#713356, al_datede#712980 AS AL_DATEDE_438420#713357, al_datefi#712992 AS AL_DATEFI_438432#713358, al_datmaj#712945 AS AL_DATMAJ_438385#713359, al_envadm#712953 AS AL_ENVADM_438393#713360, al_flicpt#712979 AS AL_FLICPT_438419#713361, al_flsej#712978 AS AL_FLSEJ_438418#713362, al_fltele#712983 AS AL_FLTELE_438423#713363, al_forfai#712956 AS AL_FORFAI_438396#713364, al_icd#712994 AS AL_ICD_438434#713365, al_int_spe#712989 AS AL_INT_SPE_438429#713366, al_int_std#712988 AS AL_INT_STD_438428#713367, al_letadm#712952 AS AL_LETADM_438392#713368, al_letads#712985 AS AL_LETADS_438425#713369, al_lib30#712940 AS AL_LIB30_438380#713370, al_libmaj#712941 AS AL_LIBMAJ_438381#713371, al_monnaie#712948 AS AL_MONNAIE_438388#713372, al_numbmp#712950 AS AL_NUMBMP_438390#713373, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#712937)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#712937)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#712938)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#712938)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#712939)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#712939)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#712940)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#712940)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#712941)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#712941)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#712942)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#712942)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#712943)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#712943)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#712944)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#712944)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#712945)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#712945)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#712946)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#712946)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#712947)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#712947)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#712948)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#712948)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#712949)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#712949)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#712950)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#712950)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#712951)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#712951)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#712952)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#712952)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#712953)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#712953)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#712954)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#712954)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#712955)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#712955)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#712956)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#712956)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#712957)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#712957)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#712958)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#712958)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#712959)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#712959)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#712960)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#712960)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#712961)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#712961)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#712962)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#712962)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#712963)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#712963)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#712964)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#712964)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#712965)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#712965)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#712966)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#712966)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#712967)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#712967)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#712968)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#712968)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#712969)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#712969)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#712970)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#712970)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#712971)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#712971)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#712972)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#712972)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#712973)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#712973)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#712974)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#712974)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#712975)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#712975)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#712976)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#712976)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#712977)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#712977)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#712978)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#712978)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#712979)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#712979)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#712980)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#712980)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#712981)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#712981)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#712982)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#712982)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#712983)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#712983)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#712984)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#712984)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#712985)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#712985)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#712986)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#712986)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#712987)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#712987)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#712988)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#712988)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#712989)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#712989)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#712990)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#712990)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#712991)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#712991)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#712992)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#712992)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#712993)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#712993)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#712994)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#712994)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#712995)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#712995)), 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#712938,al_classe#712957,al_codcha#712984,al_codsit#712947,al_coduti#712946,al_codval#712937,al_comment#712982,al_datede#712980,al_datefi#712992,al_datmaj#712945,al_envadm#712953,al_flicpt#712979,al_flsej#712978,al_fltele#712983,al_forfai#712956,al_icd#712994,al_int_spe#712989,al_int_std#712988,al_letadm#712952,al_letads#712985,al_lib30#712940,al_libmaj#712941,al_monnaie#712948,al_numbmp#712950,... 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#712405, al_classe#712424, al_codcha#712451, al_codsit#712414, al_coduti#712413, al_codval#712404, al_comment#712449, al_datede#712447, al_datefi#712459, al_datmaj#712412, al_envadm#712420, al_flicpt#712446, al_flsej#712445, al_fltele#712450, al_forfai#712423, al_icd#712461, al_int_spe#712456, al_int_std#712455, al_letadm#712419, al_letads#712452, al_lib30#712407, al_libmaj#712408, al_monnaie#712415, al_numbmp#712417, al_numcpt#712448, al_ordre#712418, al_primai#712460, al_prior#712410, al_rcp#712458, al_rembours#712426, al_revers#712425, al_sites#712453, al_spl_trans#712457, al_taux#712409, al_taux_r#712422, al_taux_t1r#712436, al_taux_t1#712427, al_taux_t2r#712437, al_taux_t2#712428, al_taux_t3r#712438, al_taux_t3#712429, al_taux_t4r#712439, al_taux_t4#712430, al_taux_t5r#712440, al_taux_t5#712431, al_taux_t6r#712441, al_taux_t6#712432, al_taux_t7r#712442, al_taux_t7#712433, al_taux_t8r#712443, al_taux_t8#712434, al_taux_t9r#712444, al_taux_t9#712435, al_typexa#712416, al_type#712411, al_type_icd#712462, al_t_red#712421, al_urg#712454, al_valcou#712406]
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#712405, al_classe#712424, al_codcha#712451, al_codsit#712414, al_coduti#712413, al_codval#712404, al_comment#712449, al_datede#712447, al_datefi#712459, al_datmaj#712412, al_envadm#712420, al_flicpt#712446, al_flsej#712445, al_fltele#712450, al_forfai#712423, al_icd#712461, al_int_spe#712456, al_int_std#712455, al_letadm#712419, al_letads#712452, al_lib30#712407, al_libmaj#712408, al_monnaie#712415, al_numbmp#712417, al_numcpt#712448, al_ordre#712418, al_primai#712460, al_prior#712410, al_rcp#712458, al_rembours#712426, al_revers#712425, al_sites#712453, al_spl_trans#712457, al_taux#712409, al_taux_r#712422, al_taux_t1r#712436, al_taux_t1#712427, al_taux_t2r#712437, al_taux_t2#712428, al_taux_t3r#712438, al_taux_t3#712429, al_taux_t4r#712439, al_taux_t4#712430, al_taux_t5r#712440, al_taux_t5#712431, al_taux_t6r#712441, al_taux_t6#712432, al_taux_t7r#712442, al_taux_t7#712433, al_taux_t8r#712443, al_taux_t8#712434, al_taux_t9r#712444, al_taux_t9#712435, al_typexa#712416, al_type#712411, al_type_icd#712462, al_t_red#712421, al_urg#712454, al_valcou#712406]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#712404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#712404)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#712405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#712405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#712406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#712406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#712407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#712407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#712408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#712408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#712409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#712409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#712410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#712410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#712411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#712411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#712412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#712412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#712413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#712413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#712414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#712414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#712415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#712415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#712416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#712416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#712417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#712417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#712418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#712418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#712419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#712419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#712420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#712420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#712421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#712421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#712422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#712422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#712423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#712423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#712424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#712424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#712425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#712425)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#712426)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#712426)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#712427)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#712427)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#712428)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#712428)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#712429)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#712429)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#712430)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#712430)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#712431)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#712431)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#712432)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#712432)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#712433)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#712433)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#712434)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#712434)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#712435)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#712435)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#712436)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#712436)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#712437)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#712437)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#712438)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#712438)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#712439)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#712439)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#712440)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#712440)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#712441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#712441)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#712442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#712442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#712443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#712443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#712444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#712444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#712445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#712445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#712446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#712446)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#712447)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#712447)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#712448)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#712448)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#712449)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#712449)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#712450)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#712450)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#712451)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#712451)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#712452)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#712452)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#712453)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#712453)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#712454)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#712454)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#712455)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#712455)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#712456)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#712456)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#712457)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#712457)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#712458)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#712458)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#712459)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#712459)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#712460)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#712460)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#712461)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#712461)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#712462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#712462)), 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#712405 AS AL_ANNVAL_438378#712817, al_classe#712424 AS AL_CLASSE_438397#712818, al_codcha#712451 AS AL_CODCHA_438424#712819, al_codsit#712414 AS AL_CODSIT_438387#712820, al_coduti#712413 AS AL_CODUTI_438386#712821, al_codval#712404 AS AL_CODVAL_438377#712822, al_comment#712449 AS AL_COMMENT_438422#712823, al_datede#712447 AS AL_DATEDE_438420#712824, al_datefi#712459 AS AL_DATEFI_438432#712825, al_datmaj#712412 AS AL_DATMAJ_438385#712826, al_envadm#712420 AS AL_ENVADM_438393#712827, al_flicpt#712446 AS AL_FLICPT_438419#712828, al_flsej#712445 AS AL_FLSEJ_438418#712829, al_fltele#712450 AS AL_FLTELE_438423#712830, al_forfai#712423 AS AL_FORFAI_438396#712831, al_icd#712461 AS AL_ICD_438434#712832, al_int_spe#712456 AS AL_INT_SPE_438429#712833, al_int_std#712455 AS AL_INT_STD_438428#712834, al_letadm#712419 AS AL_LETADM_438392#712835, al_letads#712452 AS AL_LETADS_438425#712836, al_lib30#712407 AS AL_LIB30_438380#712837, al_libmaj#712408 AS AL_LIBMAJ_438381#712838, al_monnaie#712415 AS AL_MONNAIE_438388#712839, al_numbmp#712417 AS AL_NUMBMP_438390#712840, al_numcpt#712448 AS AL_NUMCPT_438421#712841, al_ordre#712418 AS AL_ORDRE_438391#712842, al_primai#712460 AS AL_PRIMAI_438433#712843, al_prior#712410 AS AL_PRIOR_438383#712844, al_rcp#712458 AS AL_RCP_438431#712845, al_rembours#712426 AS AL_REMBOURS_438399#712846, al_revers#712425 AS AL_REVERS_438398#712847, al_sites#712453 AS AL_SITES_438426#712848, al_spl_trans#712457 AS AL_SPL_TRANS_438430#712849, al_taux#712409 AS AL_TAUX_438382#712850, al_taux_r#712422 AS AL_TAUX_R_438395#712851, al_taux_t1r#712436 AS AL_TAUX_T1R_438409#712852, al_taux_t1#712427 AS AL_TAUX_T1_438400#712853, al_taux_t2r#712437 AS AL_TAUX_T2R_438410#712854, al_taux_t2#712428 AS AL_TAUX_T2_438401#712855, al_taux_t3r#712438 AS AL_TAUX_T3R_438411#712856, al_taux_t3#712429 AS AL_TAUX_T3_438402#712857, al_taux_t4r#712439 AS AL_TAUX_T4R_438412#712858, al_taux_t4#712430 AS AL_TAUX_T4_438403#712859, al_taux_t5r#712440 AS AL_TAUX_T5R_438413#712860, al_taux_t5#712431 AS AL_TAUX_T5_438404#712861, al_taux_t6r#712441 AS AL_TAUX_T6R_438414#712862, al_taux_t6#712432 AS AL_TAUX_T6_438405#712863, al_taux_t7r#712442 AS AL_TAUX_T7R_438415#712864, al_taux_t7#712433 AS AL_TAUX_T7_438406#712865, al_taux_t8r#712443 AS AL_TAUX_T8R_438416#712866, al_taux_t8#712434 AS AL_TAUX_T8_438407#712867, al_taux_t9r#712444 AS AL_TAUX_T9R_438417#712868, al_taux_t9#712435 AS AL_TAUX_T9_438408#712869, al_typexa#712416 AS AL_TYPEXA_438389#712870, al_type#712411 AS AL_TYPE_438384#712871, al_type_icd#712462 AS AL_TYPE_ICD_438435#712872, al_t_red#712421 AS AL_T_RED_438394#712873, al_urg#712454 AS AL_URG_438427#712874, al_valcou#712406 AS AL_VALCOU_438379#712875, null AS ORIGINE_440156#712876]
Input [59]: [al_annval#712405, al_classe#712424, al_codcha#712451, al_codsit#712414, al_coduti#712413, al_codval#712404, al_comment#712449, al_datede#712447, al_datefi#712459, al_datmaj#712412, al_envadm#712420, al_flicpt#712446, al_flsej#712445, al_fltele#712450, al_forfai#712423, al_icd#712461, al_int_spe#712456, al_int_std#712455, al_letadm#712419, al_letads#712452, al_lib30#712407, al_libmaj#712408, al_monnaie#712415, al_numbmp#712417, al_numcpt#712448, al_ordre#712418, al_primai#712460, al_prior#712410, al_rcp#712458, al_rembours#712426, al_revers#712425, al_sites#712453, al_spl_trans#712457, al_taux#712409, al_taux_r#712422, al_taux_t1r#712436, al_taux_t1#712427, al_taux_t2r#712437, al_taux_t2#712428, al_taux_t3r#712438, al_taux_t3#712429, al_taux_t4r#712439, al_taux_t4#712430, al_taux_t5r#712440, al_taux_t5#712431, al_taux_t6r#712441, al_taux_t6#712432, al_taux_t7r#712442, al_taux_t7#712433, al_taux_t8r#712443, al_taux_t8#712434, al_taux_t9r#712444, al_taux_t9#712435, al_typexa#712416, al_type#712411, al_type_icd#712462, al_t_red#712421, al_urg#712454, al_valcou#712406]

(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#712938, al_classe#712957, al_codcha#712984, al_codsit#712947, al_coduti#712946, al_codval#712937, al_comment#712982, al_datede#712980, al_datefi#712992, al_datmaj#712945, al_envadm#712953, al_flicpt#712979, al_flsej#712978, al_fltele#712983, al_forfai#712956, al_icd#712994, al_int_spe#712989, al_int_std#712988, al_letadm#712952, al_letads#712985, al_lib30#712940, al_libmaj#712941, al_monnaie#712948, al_numbmp#712950, al_numcpt#712981, al_ordre#712951, al_primai#712993, al_prior#712943, al_rcp#712991, al_rembours#712959, al_revers#712958, al_sites#712986, al_spl_trans#712990, al_taux#712942, al_taux_r#712955, al_taux_t1r#712969, al_taux_t1#712960, al_taux_t2r#712970, al_taux_t2#712961, al_taux_t3r#712971, al_taux_t3#712962, al_taux_t4r#712972, al_taux_t4#712963, al_taux_t5r#712973, al_taux_t5#712964, al_taux_t6r#712974, al_taux_t6#712965, al_taux_t7r#712975, al_taux_t7#712966, al_taux_t8r#712976, al_taux_t8#712967, al_taux_t9r#712977, al_taux_t9#712968, al_typexa#712949, al_type#712944, al_type_icd#712995, al_t_red#712954, al_urg#712987, al_valcou#712939]
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#712938, al_classe#712957, al_codcha#712984, al_codsit#712947, al_coduti#712946, al_codval#712937, al_comment#712982, al_datede#712980, al_datefi#712992, al_datmaj#712945, al_envadm#712953, al_flicpt#712979, al_flsej#712978, al_fltele#712983, al_forfai#712956, al_icd#712994, al_int_spe#712989, al_int_std#712988, al_letadm#712952, al_letads#712985, al_lib30#712940, al_libmaj#712941, al_monnaie#712948, al_numbmp#712950, al_numcpt#712981, al_ordre#712951, al_primai#712993, al_prior#712943, al_rcp#712991, al_rembours#712959, al_revers#712958, al_sites#712986, al_spl_trans#712990, al_taux#712942, al_taux_r#712955, al_taux_t1r#712969, al_taux_t1#712960, al_taux_t2r#712970, al_taux_t2#712961, al_taux_t3r#712971, al_taux_t3#712962, al_taux_t4r#712972, al_taux_t4#712963, al_taux_t5r#712973, al_taux_t5#712964, al_taux_t6r#712974, al_taux_t6#712965, al_taux_t7r#712975, al_taux_t7#712966, al_taux_t8r#712976, al_taux_t8#712967, al_taux_t9r#712977, al_taux_t9#712968, al_typexa#712949, al_type#712944, al_type_icd#712995, al_t_red#712954, al_urg#712987, al_valcou#712939]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#712937)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#712937)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#712938)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#712938)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#712939)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#712939)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#712940)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#712940)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#712941)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#712941)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#712942)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#712942)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#712943)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#712943)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#712944)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#712944)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#712945)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#712945)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#712946)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#712946)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#712947)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#712947)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#712948)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#712948)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#712949)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#712949)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#712950)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#712950)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#712951)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#712951)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#712952)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#712952)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#712953)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#712953)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#712954)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#712954)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#712955)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#712955)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#712956)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#712956)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#712957)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#712957)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#712958)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#712958)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#712959)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#712959)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#712960)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#712960)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#712961)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#712961)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#712962)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#712962)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#712963)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#712963)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#712964)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#712964)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#712965)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#712965)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#712966)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#712966)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#712967)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#712967)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#712968)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#712968)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#712969)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#712969)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#712970)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#712970)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#712971)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#712971)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#712972)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#712972)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#712973)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#712973)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#712974)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#712974)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#712975)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#712975)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#712976)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#712976)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#712977)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#712977)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#712978)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#712978)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#712979)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#712979)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#712980)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#712980)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#712981)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#712981)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#712982)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#712982)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#712983)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#712983)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#712984)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#712984)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#712985)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#712985)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#712986)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#712986)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#712987)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#712987)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#712988)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#712988)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#712989)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#712989)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#712990)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#712990)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#712991)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#712991)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#712992)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#712992)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#712993)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#712993)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#712994)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#712994)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#712995)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#712995)), 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#712938 AS AL_ANNVAL_438378#713350, al_classe#712957 AS AL_CLASSE_438397#713351, al_codcha#712984 AS AL_CODCHA_438424#713352, al_codsit#712947 AS AL_CODSIT_438387#713353, al_coduti#712946 AS AL_CODUTI_438386#713354, al_codval#712937 AS AL_CODVAL_438377#713355, al_comment#712982 AS AL_COMMENT_438422#713356, al_datede#712980 AS AL_DATEDE_438420#713357, al_datefi#712992 AS AL_DATEFI_438432#713358, al_datmaj#712945 AS AL_DATMAJ_438385#713359, al_envadm#712953 AS AL_ENVADM_438393#713360, al_flicpt#712979 AS AL_FLICPT_438419#713361, al_flsej#712978 AS AL_FLSEJ_438418#713362, al_fltele#712983 AS AL_FLTELE_438423#713363, al_forfai#712956 AS AL_FORFAI_438396#713364, al_icd#712994 AS AL_ICD_438434#713365, al_int_spe#712989 AS AL_INT_SPE_438429#713366, al_int_std#712988 AS AL_INT_STD_438428#713367, al_letadm#712952 AS AL_LETADM_438392#713368, al_letads#712985 AS AL_LETADS_438425#713369, al_lib30#712940 AS AL_LIB30_438380#713370, al_libmaj#712941 AS AL_LIBMAJ_438381#713371, al_monnaie#712948 AS AL_MONNAIE_438388#713372, al_numbmp#712950 AS AL_NUMBMP_438390#713373, al_numcpt#712981 AS AL_NUMCPT_438421#713374, al_ordre#712951 AS AL_ORDRE_438391#713375, al_primai#712993 AS AL_PRIMAI_438433#713376, al_prior#712943 AS AL_PRIOR_438383#713377, al_rcp#712991 AS AL_RCP_438431#713378, al_rembours#712959 AS AL_REMBOURS_438399#713379, al_revers#712958 AS AL_REVERS_438398#713380, al_sites#712986 AS AL_SITES_438426#713381, al_spl_trans#712990 AS AL_SPL_TRANS_438430#713382, al_taux#712942 AS AL_TAUX_438382#713383, al_taux_r#712955 AS AL_TAUX_R_438395#713384, al_taux_t1r#712969 AS AL_TAUX_T1R_438409#713385, al_taux_t1#712960 AS AL_TAUX_T1_438400#713386, al_taux_t2r#712970 AS AL_TAUX_T2R_438410#713387, al_taux_t2#712961 AS AL_TAUX_T2_438401#713388, al_taux_t3r#712971 AS AL_TAUX_T3R_438411#713389, al_taux_t3#712962 AS AL_TAUX_T3_438402#713390, al_taux_t4r#712972 AS AL_TAUX_T4R_438412#713391, al_taux_t4#712963 AS AL_TAUX_T4_438403#713392, al_taux_t5r#712973 AS AL_TAUX_T5R_438413#713393, al_taux_t5#712964 AS AL_TAUX_T5_438404#713394, al_taux_t6r#712974 AS AL_TAUX_T6R_438414#713395, al_taux_t6#712965 AS AL_TAUX_T6_438405#713396, al_taux_t7r#712975 AS AL_TAUX_T7R_438415#713397, al_taux_t7#712966 AS AL_TAUX_T7_438406#713398, al_taux_t8r#712976 AS AL_TAUX_T8R_438416#713399, al_taux_t8#712967 AS AL_TAUX_T8_438407#713400, al_taux_t9r#712977 AS AL_TAUX_T9R_438417#713401, al_taux_t9#712968 AS AL_TAUX_T9_438408#713402, al_typexa#712949 AS AL_TYPEXA_438389#713403, al_type#712944 AS AL_TYPE_438384#713404, al_type_icd#712995 AS AL_TYPE_ICD_438435#713405, al_t_red#712954 AS AL_T_RED_438394#713406, al_urg#712987 AS AL_URG_438427#713407, al_valcou#712939 AS AL_VALCOU_438379#713408, null AS ORIGINE_440156#713409]
Input [59]: [al_annval#712938, al_classe#712957, al_codcha#712984, al_codsit#712947, al_coduti#712946, al_codval#712937, al_comment#712982, al_datede#712980, al_datefi#712992, al_datmaj#712945, al_envadm#712953, al_flicpt#712979, al_flsej#712978, al_fltele#712983, al_forfai#712956, al_icd#712994, al_int_spe#712989, al_int_std#712988, al_letadm#712952, al_letads#712985, al_lib30#712940, al_libmaj#712941, al_monnaie#712948, al_numbmp#712950, al_numcpt#712981, al_ordre#712951, al_primai#712993, al_prior#712943, al_rcp#712991, al_rembours#712959, al_revers#712958, al_sites#712986, al_spl_trans#712990, al_taux#712942, al_taux_r#712955, al_taux_t1r#712969, al_taux_t1#712960, al_taux_t2r#712970, al_taux_t2#712961, al_taux_t3r#712971, al_taux_t3#712962, al_taux_t4r#712972, al_taux_t4#712963, al_taux_t5r#712973, al_taux_t5#712964, al_taux_t6r#712974, al_taux_t6#712965, al_taux_t7r#712975, al_taux_t7#712966, al_taux_t8r#712976, al_taux_t8#712967, al_taux_t9r#712977, al_taux_t9#712968, al_typexa#712949, al_type#712944, al_type_icd#712995, al_t_red#712954, al_urg#712987, al_valcou#712939]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Keys [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]

(9) Exchange
Input [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Arguments: hashpartitioning(AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=38499]

(10) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Arguments: 0

(11) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Keys [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(16) HashAggregate [codegen id : 5]
Input [1]: [count#715807L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#714223L]
Results [1]: [count(1)#714223L AS COL_e4d6b5b1-1458-4400-bc7a-0588834e2aed#714225L]

(17) Union

(18) HashAggregate
Input [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Keys [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]

(19) Exchange
Input [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Arguments: hashpartitioning(AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=38457]

(20) HashAggregate
Input [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Keys [60]: [AL_ANNVAL_438378#712817, AL_CLASSE_438397#712818, AL_CODCHA_438424#712819, AL_CODSIT_438387#712820, AL_CODUTI_438386#712821, AL_CODVAL_438377#712822, AL_COMMENT_438422#712823, AL_DATEDE_438420#712824, AL_DATEFI_438432#712825, AL_DATMAJ_438385#712826, AL_ENVADM_438393#712827, AL_FLICPT_438419#712828, AL_FLSEJ_438418#712829, AL_FLTELE_438423#712830, AL_FORFAI_438396#712831, AL_ICD_438434#712832, AL_INT_SPE_438429#712833, AL_INT_STD_438428#712834, AL_LETADM_438392#712835, AL_LETADS_438425#712836, AL_LIB30_438380#712837, AL_LIBMAJ_438381#712838, AL_MONNAIE_438388#712839, AL_NUMBMP_438390#712840, AL_NUMCPT_438421#712841, AL_ORDRE_438391#712842, AL_PRIMAI_438433#712843, AL_PRIOR_438383#712844, AL_RCP_438431#712845, AL_REMBOURS_438399#712846, AL_REVERS_438398#712847, AL_SITES_438426#712848, AL_SPL_TRANS_438430#712849, AL_TAUX_438382#712850, AL_TAUX_R_438395#712851, AL_TAUX_T1R_438409#712852, AL_TAUX_T1_438400#712853, AL_TAUX_T2R_438410#712854, AL_TAUX_T2_438401#712855, AL_TAUX_T3R_438411#712856, AL_TAUX_T3_438402#712857, AL_TAUX_T4R_438412#712858, AL_TAUX_T4_438403#712859, AL_TAUX_T5R_438413#712860, AL_TAUX_T5_438404#712861, AL_TAUX_T6R_438414#712862, AL_TAUX_T6_438405#712863, AL_TAUX_T7R_438415#712864, AL_TAUX_T7_438406#712865, AL_TAUX_T8R_438416#712866, AL_TAUX_T8_438407#712867, AL_TAUX_T9R_438417#712868, AL_TAUX_T9_438408#712869, AL_TYPEXA_438389#712870, AL_TYPE_438384#712871, AL_TYPE_ICD_438435#712872, AL_T_RED_438394#712873, AL_URG_438427#712874, AL_VALCOU_438379#712875, ORIGINE_440156#712876]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(23) HashAggregate
Input [1]: [count#715807L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#714223L]
Results [1]: [count(1)#714223L AS COL_e4d6b5b1-1458-4400-bc7a-0588834e2aed#714225L]

(24) AdaptiveSparkPlan
Output [1]: [COL_e4d6b5b1-1458-4400-bc7a-0588834e2aed#714225L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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