hdh-spark-job - Details for Query 1468

Submitted Time: 2026/10/23 13:29:40
Duration: 2 s
Succeeded Jobs: 1465 1468 1470

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: 8 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)) 2 ms (1 ms, 1 ms, 1 ms (stage 2134.0: task 1865)) 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 2134.0: task 1865)) 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 2134.0: task 1865))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.4 s (690 ms, 700 ms, 700 ms (stage 2134.0: task 1864))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1.3 s (660 ms, 669 ms, 669 ms (stage 2134.0: task 1864)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 2134.0: task 1865)) 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 2134.0: task 1865))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 742 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: 687 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=40440]

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

HashAggregate(keys=[AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=40181]

WholeStageCodegen (3)

Union

Project [al_annval#749302 AS AL_ANNVAL_438378#749915, al_classe#749321 AS AL_CLASSE_438397#749916, al_codcha#749348 AS AL_CODCHA_438424#749917, al_codsit#749311 AS AL_CODSIT_438387#749918, al_coduti#749310 AS AL_CODUTI_438386#749919, al_codval#749301 AS AL_CODVAL_438377#749920, al_comment#749346 AS AL_COMMENT_438422#749921, al_datede#749344 AS AL_DATEDE_438420#749922, al_datefi#749356 AS AL_DATEFI_438432#749923, al_datmaj#749309 AS AL_DATMAJ_438385#749924, al_envadm#749317 AS AL_ENVADM_438393#749925, al_flicpt#749343 AS AL_FLICPT_438419#749926, al_flsej#749342 AS AL_FLSEJ_438418#749927, al_fltele#749347 AS AL_FLTELE_438423#749928, al_forfai#749320 AS AL_FORFAI_438396#749929, al_icd#749358 AS AL_ICD_438434#749930, al_int_spe#749353 AS AL_INT_SPE_438429#749931, al_int_std#749352 AS AL_INT_STD_438428#749932, al_letadm#749316 AS AL_LETADM_438392#749933, al_letads#749349 AS AL_LETADS_438425#749934, al_lib30#749304 AS AL_LIB30_438380#749935, al_libmaj#749305 AS AL_LIBMAJ_438381#749936, al_monnaie#749312 AS AL_MONNAIE_438388#749937, al_numbmp#749314 AS AL_NUMBMP_438390#749938, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#749301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#749301)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#749302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#749302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#749303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#749303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#749304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#749304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#749305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#749305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#749306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#749306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#749307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#749307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#749308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#749308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#749309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#749309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#749310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#749310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#749311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#749311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#749312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#749312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#749313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#749313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#749314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#749314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#749315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#749315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#749316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#749316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#749317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#749317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#749318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#749318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#749319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#749319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#749320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#749320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#749321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#749321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#749322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#749322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#749323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#749323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#749324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#749324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#749325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#749325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#749326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#749326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#749327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#749327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#749328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#749328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#749329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#749329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#749330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#749330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#749331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#749331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#749332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#749332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#749333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#749333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#749334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#749334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#749335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#749335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#749336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#749336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#749337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#749337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#749338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#749338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#749339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#749339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#749340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#749340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#749341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#749341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#749342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#749342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#749343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#749343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#749344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#749344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#749345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#749345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#749346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#749346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#749347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#749347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#749348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#749348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#749349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#749349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#749350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#749350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#749351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#749351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#749352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#749352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#749353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#749353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#749354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#749354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#749355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#749355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#749356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#749356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#749357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#749357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#749358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#749358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#749359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#749359)), 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#749302,al_classe#749321,al_codcha#749348,al_codsit#749311,al_coduti#749310,al_codval#749301,al_comment#749346,al_datede#749344,al_datefi#749356,al_datmaj#749309,al_envadm#749317,al_flicpt#749343,al_flsej#749342,al_fltele#749347,al_forfai#749320,al_icd#749358,al_int_spe#749353,al_int_std#749352,al_letadm#749316,al_letads#749349,al_lib30#749304,al_libmaj#749305,al_monnaie#749312,al_numbmp#749314,... 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#750302 AS AL_ANNVAL_438378#750918, al_classe#750321 AS AL_CLASSE_438397#750919, al_codcha#750348 AS AL_CODCHA_438424#750920, al_codsit#750311 AS AL_CODSIT_438387#750921, al_coduti#750310 AS AL_CODUTI_438386#750922, al_codval#750301 AS AL_CODVAL_438377#750923, al_comment#750346 AS AL_COMMENT_438422#750924, al_datede#750344 AS AL_DATEDE_438420#750925, al_datefi#750356 AS AL_DATEFI_438432#750926, al_datmaj#750309 AS AL_DATMAJ_438385#750927, al_envadm#750317 AS AL_ENVADM_438393#750928, al_flicpt#750343 AS AL_FLICPT_438419#750929, al_flsej#750342 AS AL_FLSEJ_438418#750930, al_fltele#750347 AS AL_FLTELE_438423#750931, al_forfai#750320 AS AL_FORFAI_438396#750932, al_icd#750358 AS AL_ICD_438434#750933, al_int_spe#750353 AS AL_INT_SPE_438429#750934, al_int_std#750352 AS AL_INT_STD_438428#750936, al_letadm#750316 AS AL_LETADM_438392#750937, al_letads#750349 AS AL_LETADS_438425#750938, al_lib30#750304 AS AL_LIB30_438380#750939, al_libmaj#750305 AS AL_LIBMAJ_438381#750940, al_monnaie#750312 AS AL_MONNAIE_438388#750941, al_numbmp#750314 AS AL_NUMBMP_438390#750942, ... 36 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#750301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#750301)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#750302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#750302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#750303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#750303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#750304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#750304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#750305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#750305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#750306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#750306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#750307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#750307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#750308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#750308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#750309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#750309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#750310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#750310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#750311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#750311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#750312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#750312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#750313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#750313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#750314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#750314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#750315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#750315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#750316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#750316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#750317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#750317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#750318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#750318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#750319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#750319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#750320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#750320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#750321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#750321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#750322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#750322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#750323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#750323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#750324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#750324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#750325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#750325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#750326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#750326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#750327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#750327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#750328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#750328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#750329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#750329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#750330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#750330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#750331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#750331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#750332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#750332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#750333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#750333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#750334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#750334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#750335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#750335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#750336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#750336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#750337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#750337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#750338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#750338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#750339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#750339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#750340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#750340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#750341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#750341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#750342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#750342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#750343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#750343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#750344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#750344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#750345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#750345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#750346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#750346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#750347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#750347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#750348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#750348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#750349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#750349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#750350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#750350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#750351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#750351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#750352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#750352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#750353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#750353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#750354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#750354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#750355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#750355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#750356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#750356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#750357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#750357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#750358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#750358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#750359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#750359)), 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#750302,al_classe#750321,al_codcha#750348,al_codsit#750311,al_coduti#750310,al_codval#750301,al_comment#750346,al_datede#750344,al_datefi#750356,al_datmaj#750309,al_envadm#750317,al_flicpt#750343,al_flsej#750342,al_fltele#750347,al_forfai#750320,al_icd#750358,al_int_spe#750353,al_int_std#750352,al_letadm#750316,al_letads#750349,al_lib30#750304,al_libmaj#750305,al_monnaie#750312,al_numbmp#750314,... 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#749302, al_classe#749321, al_codcha#749348, al_codsit#749311, al_coduti#749310, al_codval#749301, al_comment#749346, al_datede#749344, al_datefi#749356, al_datmaj#749309, al_envadm#749317, al_flicpt#749343, al_flsej#749342, al_fltele#749347, al_forfai#749320, al_icd#749358, al_int_spe#749353, al_int_std#749352, al_letadm#749316, al_letads#749349, al_lib30#749304, al_libmaj#749305, al_monnaie#749312, al_numbmp#749314, al_numcpt#749345, al_ordre#749315, al_primai#749357, al_prior#749307, al_rcp#749355, al_rembours#749323, al_revers#749322, al_sites#749350, al_spl_trans#749354, al_taux#749306, al_taux_r#749319, al_taux_t1r#749333, al_taux_t1#749324, al_taux_t2r#749334, al_taux_t2#749325, al_taux_t3r#749335, al_taux_t3#749326, al_taux_t4r#749336, al_taux_t4#749327, al_taux_t5r#749337, al_taux_t5#749328, al_taux_t6r#749338, al_taux_t6#749329, al_taux_t7r#749339, al_taux_t7#749330, al_taux_t8r#749340, al_taux_t8#749331, al_taux_t9r#749341, al_taux_t9#749332, al_typexa#749313, al_type#749308, al_type_icd#749359, al_t_red#749318, al_urg#749351, al_valcou#749303]
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#749302, al_classe#749321, al_codcha#749348, al_codsit#749311, al_coduti#749310, al_codval#749301, al_comment#749346, al_datede#749344, al_datefi#749356, al_datmaj#749309, al_envadm#749317, al_flicpt#749343, al_flsej#749342, al_fltele#749347, al_forfai#749320, al_icd#749358, al_int_spe#749353, al_int_std#749352, al_letadm#749316, al_letads#749349, al_lib30#749304, al_libmaj#749305, al_monnaie#749312, al_numbmp#749314, al_numcpt#749345, al_ordre#749315, al_primai#749357, al_prior#749307, al_rcp#749355, al_rembours#749323, al_revers#749322, al_sites#749350, al_spl_trans#749354, al_taux#749306, al_taux_r#749319, al_taux_t1r#749333, al_taux_t1#749324, al_taux_t2r#749334, al_taux_t2#749325, al_taux_t3r#749335, al_taux_t3#749326, al_taux_t4r#749336, al_taux_t4#749327, al_taux_t5r#749337, al_taux_t5#749328, al_taux_t6r#749338, al_taux_t6#749329, al_taux_t7r#749339, al_taux_t7#749330, al_taux_t8r#749340, al_taux_t8#749331, al_taux_t9r#749341, al_taux_t9#749332, al_typexa#749313, al_type#749308, al_type_icd#749359, al_t_red#749318, al_urg#749351, al_valcou#749303]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#749301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#749301)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#749302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#749302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#749303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#749303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#749304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#749304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#749305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#749305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#749306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#749306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#749307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#749307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#749308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#749308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#749309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#749309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#749310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#749310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#749311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#749311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#749312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#749312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#749313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#749313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#749314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#749314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#749315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#749315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#749316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#749316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#749317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#749317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#749318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#749318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#749319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#749319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#749320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#749320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#749321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#749321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#749322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#749322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#749323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#749323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#749324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#749324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#749325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#749325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#749326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#749326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#749327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#749327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#749328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#749328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#749329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#749329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#749330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#749330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#749331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#749331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#749332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#749332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#749333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#749333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#749334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#749334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#749335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#749335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#749336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#749336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#749337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#749337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#749338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#749338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#749339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#749339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#749340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#749340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#749341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#749341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#749342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#749342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#749343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#749343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#749344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#749344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#749345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#749345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#749346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#749346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#749347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#749347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#749348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#749348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#749349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#749349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#749350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#749350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#749351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#749351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#749352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#749352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#749353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#749353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#749354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#749354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#749355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#749355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#749356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#749356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#749357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#749357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#749358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#749358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#749359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#749359)), 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#749302 AS AL_ANNVAL_438378#749915, al_classe#749321 AS AL_CLASSE_438397#749916, al_codcha#749348 AS AL_CODCHA_438424#749917, al_codsit#749311 AS AL_CODSIT_438387#749918, al_coduti#749310 AS AL_CODUTI_438386#749919, al_codval#749301 AS AL_CODVAL_438377#749920, al_comment#749346 AS AL_COMMENT_438422#749921, al_datede#749344 AS AL_DATEDE_438420#749922, al_datefi#749356 AS AL_DATEFI_438432#749923, al_datmaj#749309 AS AL_DATMAJ_438385#749924, al_envadm#749317 AS AL_ENVADM_438393#749925, al_flicpt#749343 AS AL_FLICPT_438419#749926, al_flsej#749342 AS AL_FLSEJ_438418#749927, al_fltele#749347 AS AL_FLTELE_438423#749928, al_forfai#749320 AS AL_FORFAI_438396#749929, al_icd#749358 AS AL_ICD_438434#749930, al_int_spe#749353 AS AL_INT_SPE_438429#749931, al_int_std#749352 AS AL_INT_STD_438428#749932, al_letadm#749316 AS AL_LETADM_438392#749933, al_letads#749349 AS AL_LETADS_438425#749934, al_lib30#749304 AS AL_LIB30_438380#749935, al_libmaj#749305 AS AL_LIBMAJ_438381#749936, al_monnaie#749312 AS AL_MONNAIE_438388#749937, al_numbmp#749314 AS AL_NUMBMP_438390#749938, al_numcpt#749345 AS AL_NUMCPT_438421#749939, al_ordre#749315 AS AL_ORDRE_438391#749940, al_primai#749357 AS AL_PRIMAI_438433#749941, al_prior#749307 AS AL_PRIOR_438383#749942, al_rcp#749355 AS AL_RCP_438431#749943, al_rembours#749323 AS AL_REMBOURS_438399#749944, al_revers#749322 AS AL_REVERS_438398#749945, al_sites#749350 AS AL_SITES_438426#749946, al_spl_trans#749354 AS AL_SPL_TRANS_438430#749947, al_taux#749306 AS AL_TAUX_438382#749948, al_taux_r#749319 AS AL_TAUX_R_438395#749949, al_taux_t1r#749333 AS AL_TAUX_T1R_438409#749950, al_taux_t1#749324 AS AL_TAUX_T1_438400#749951, al_taux_t2r#749334 AS AL_TAUX_T2R_438410#749952, al_taux_t2#749325 AS AL_TAUX_T2_438401#749953, al_taux_t3r#749335 AS AL_TAUX_T3R_438411#749954, al_taux_t3#749326 AS AL_TAUX_T3_438402#749955, al_taux_t4r#749336 AS AL_TAUX_T4R_438412#749956, al_taux_t4#749327 AS AL_TAUX_T4_438403#749957, al_taux_t5r#749337 AS AL_TAUX_T5R_438413#749958, al_taux_t5#749328 AS AL_TAUX_T5_438404#749959, al_taux_t6r#749338 AS AL_TAUX_T6R_438414#749960, al_taux_t6#749329 AS AL_TAUX_T6_438405#749961, al_taux_t7r#749339 AS AL_TAUX_T7R_438415#749962, al_taux_t7#749330 AS AL_TAUX_T7_438406#749963, al_taux_t8r#749340 AS AL_TAUX_T8R_438416#749964, al_taux_t8#749331 AS AL_TAUX_T8_438407#749965, al_taux_t9r#749341 AS AL_TAUX_T9R_438417#749966, al_taux_t9#749332 AS AL_TAUX_T9_438408#749967, al_typexa#749313 AS AL_TYPEXA_438389#749968, al_type#749308 AS AL_TYPE_438384#749969, al_type_icd#749359 AS AL_TYPE_ICD_438435#749970, al_t_red#749318 AS AL_T_RED_438394#749971, al_urg#749351 AS AL_URG_438427#749972, al_valcou#749303 AS AL_VALCOU_438379#749973, null AS ORIGINE_440156#749974]
Input [59]: [al_annval#749302, al_classe#749321, al_codcha#749348, al_codsit#749311, al_coduti#749310, al_codval#749301, al_comment#749346, al_datede#749344, al_datefi#749356, al_datmaj#749309, al_envadm#749317, al_flicpt#749343, al_flsej#749342, al_fltele#749347, al_forfai#749320, al_icd#749358, al_int_spe#749353, al_int_std#749352, al_letadm#749316, al_letads#749349, al_lib30#749304, al_libmaj#749305, al_monnaie#749312, al_numbmp#749314, al_numcpt#749345, al_ordre#749315, al_primai#749357, al_prior#749307, al_rcp#749355, al_rembours#749323, al_revers#749322, al_sites#749350, al_spl_trans#749354, al_taux#749306, al_taux_r#749319, al_taux_t1r#749333, al_taux_t1#749324, al_taux_t2r#749334, al_taux_t2#749325, al_taux_t3r#749335, al_taux_t3#749326, al_taux_t4r#749336, al_taux_t4#749327, al_taux_t5r#749337, al_taux_t5#749328, al_taux_t6r#749338, al_taux_t6#749329, al_taux_t7r#749339, al_taux_t7#749330, al_taux_t8r#749340, al_taux_t8#749331, al_taux_t9r#749341, al_taux_t9#749332, al_typexa#749313, al_type#749308, al_type_icd#749359, al_t_red#749318, al_urg#749351, al_valcou#749303]

(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#750302, al_classe#750321, al_codcha#750348, al_codsit#750311, al_coduti#750310, al_codval#750301, al_comment#750346, al_datede#750344, al_datefi#750356, al_datmaj#750309, al_envadm#750317, al_flicpt#750343, al_flsej#750342, al_fltele#750347, al_forfai#750320, al_icd#750358, al_int_spe#750353, al_int_std#750352, al_letadm#750316, al_letads#750349, al_lib30#750304, al_libmaj#750305, al_monnaie#750312, al_numbmp#750314, al_numcpt#750345, al_ordre#750315, al_primai#750357, al_prior#750307, al_rcp#750355, al_rembours#750323, al_revers#750322, al_sites#750350, al_spl_trans#750354, al_taux#750306, al_taux_r#750319, al_taux_t1r#750333, al_taux_t1#750324, al_taux_t2r#750334, al_taux_t2#750325, al_taux_t3r#750335, al_taux_t3#750326, al_taux_t4r#750336, al_taux_t4#750327, al_taux_t5r#750337, al_taux_t5#750328, al_taux_t6r#750338, al_taux_t6#750329, al_taux_t7r#750339, al_taux_t7#750330, al_taux_t8r#750340, al_taux_t8#750331, al_taux_t9r#750341, al_taux_t9#750332, al_typexa#750313, al_type#750308, al_type_icd#750359, al_t_red#750318, al_urg#750351, al_valcou#750303]
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#750302, al_classe#750321, al_codcha#750348, al_codsit#750311, al_coduti#750310, al_codval#750301, al_comment#750346, al_datede#750344, al_datefi#750356, al_datmaj#750309, al_envadm#750317, al_flicpt#750343, al_flsej#750342, al_fltele#750347, al_forfai#750320, al_icd#750358, al_int_spe#750353, al_int_std#750352, al_letadm#750316, al_letads#750349, al_lib30#750304, al_libmaj#750305, al_monnaie#750312, al_numbmp#750314, al_numcpt#750345, al_ordre#750315, al_primai#750357, al_prior#750307, al_rcp#750355, al_rembours#750323, al_revers#750322, al_sites#750350, al_spl_trans#750354, al_taux#750306, al_taux_r#750319, al_taux_t1r#750333, al_taux_t1#750324, al_taux_t2r#750334, al_taux_t2#750325, al_taux_t3r#750335, al_taux_t3#750326, al_taux_t4r#750336, al_taux_t4#750327, al_taux_t5r#750337, al_taux_t5#750328, al_taux_t6r#750338, al_taux_t6#750329, al_taux_t7r#750339, al_taux_t7#750330, al_taux_t8r#750340, al_taux_t8#750331, al_taux_t9r#750341, al_taux_t9#750332, al_typexa#750313, al_type#750308, al_type_icd#750359, al_t_red#750318, al_urg#750351, al_valcou#750303]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(al_codval#750301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codval#750301)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_annval#750302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_annval#750302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_valcou#750303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_valcou#750303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_lib30#750304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_lib30#750304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_libmaj#750305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_libmaj#750305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux#750306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux#750306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_prior#750307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_prior#750307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type#750308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type#750308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datmaj#750309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datmaj#750309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_coduti#750310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_coduti#750310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codsit#750311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codsit#750311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_monnaie#750312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_monnaie#750312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_typexa#750313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_typexa#750313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numbmp#750314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numbmp#750314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_ordre#750315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_ordre#750315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letadm#750316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letadm#750316)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_envadm#750317)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_envadm#750317)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_t_red#750318)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_t_red#750318)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_r#750319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_r#750319)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_forfai#750320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_forfai#750320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_classe#750321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_classe#750321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_revers#750322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_revers#750322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rembours#750323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rembours#750323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1#750324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1#750324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2#750325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2#750325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3#750326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3#750326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4#750327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4#750327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5#750328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5#750328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6#750329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6#750329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7#750330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7#750330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8#750331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8#750331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9#750332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9#750332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t1r#750333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t1r#750333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t2r#750334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t2r#750334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t3r#750335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t3r#750335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t4r#750336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t4r#750336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t5r#750337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t5r#750337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t6r#750338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t6r#750338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t7r#750339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t7r#750339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t8r#750340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t8r#750340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_taux_t9r#750341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_taux_t9r#750341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flsej#750342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flsej#750342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_flicpt#750343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_flicpt#750343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datede#750344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datede#750344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_numcpt#750345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_numcpt#750345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_comment#750346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_comment#750346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_fltele#750347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_fltele#750347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_codcha#750348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_codcha#750348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_letads#750349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_letads#750349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_sites#750350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_sites#750350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_urg#750351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_urg#750351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_std#750352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_std#750352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_int_spe#750353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_int_spe#750353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_spl_trans#750354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_spl_trans#750354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_rcp#750355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_rcp#750355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_datefi#750356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_datefi#750356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_primai#750357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_primai#750357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_icd#750358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_icd#750358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(al_type_icd#750359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(al_type_icd#750359)), 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#750302 AS AL_ANNVAL_438378#750918, al_classe#750321 AS AL_CLASSE_438397#750919, al_codcha#750348 AS AL_CODCHA_438424#750920, al_codsit#750311 AS AL_CODSIT_438387#750921, al_coduti#750310 AS AL_CODUTI_438386#750922, al_codval#750301 AS AL_CODVAL_438377#750923, al_comment#750346 AS AL_COMMENT_438422#750924, al_datede#750344 AS AL_DATEDE_438420#750925, al_datefi#750356 AS AL_DATEFI_438432#750926, al_datmaj#750309 AS AL_DATMAJ_438385#750927, al_envadm#750317 AS AL_ENVADM_438393#750928, al_flicpt#750343 AS AL_FLICPT_438419#750929, al_flsej#750342 AS AL_FLSEJ_438418#750930, al_fltele#750347 AS AL_FLTELE_438423#750931, al_forfai#750320 AS AL_FORFAI_438396#750932, al_icd#750358 AS AL_ICD_438434#750933, al_int_spe#750353 AS AL_INT_SPE_438429#750934, al_int_std#750352 AS AL_INT_STD_438428#750936, al_letadm#750316 AS AL_LETADM_438392#750937, al_letads#750349 AS AL_LETADS_438425#750938, al_lib30#750304 AS AL_LIB30_438380#750939, al_libmaj#750305 AS AL_LIBMAJ_438381#750940, al_monnaie#750312 AS AL_MONNAIE_438388#750941, al_numbmp#750314 AS AL_NUMBMP_438390#750942, al_numcpt#750345 AS AL_NUMCPT_438421#750943, al_ordre#750315 AS AL_ORDRE_438391#750944, al_primai#750357 AS AL_PRIMAI_438433#750945, al_prior#750307 AS AL_PRIOR_438383#750946, al_rcp#750355 AS AL_RCP_438431#750947, al_rembours#750323 AS AL_REMBOURS_438399#750948, al_revers#750322 AS AL_REVERS_438398#750949, al_sites#750350 AS AL_SITES_438426#750950, al_spl_trans#750354 AS AL_SPL_TRANS_438430#750951, al_taux#750306 AS AL_TAUX_438382#750952, al_taux_r#750319 AS AL_TAUX_R_438395#750953, al_taux_t1r#750333 AS AL_TAUX_T1R_438409#750954, al_taux_t1#750324 AS AL_TAUX_T1_438400#750955, al_taux_t2r#750334 AS AL_TAUX_T2R_438410#750956, al_taux_t2#750325 AS AL_TAUX_T2_438401#750957, al_taux_t3r#750335 AS AL_TAUX_T3R_438411#750958, al_taux_t3#750326 AS AL_TAUX_T3_438402#750959, al_taux_t4r#750336 AS AL_TAUX_T4R_438412#750960, al_taux_t4#750327 AS AL_TAUX_T4_438403#750961, al_taux_t5r#750337 AS AL_TAUX_T5R_438413#750962, al_taux_t5#750328 AS AL_TAUX_T5_438404#750963, al_taux_t6r#750338 AS AL_TAUX_T6R_438414#750964, al_taux_t6#750329 AS AL_TAUX_T6_438405#750966, al_taux_t7r#750339 AS AL_TAUX_T7R_438415#750967, al_taux_t7#750330 AS AL_TAUX_T7_438406#750968, al_taux_t8r#750340 AS AL_TAUX_T8R_438416#750969, al_taux_t8#750331 AS AL_TAUX_T8_438407#750970, al_taux_t9r#750341 AS AL_TAUX_T9R_438417#750971, al_taux_t9#750332 AS AL_TAUX_T9_438408#750973, al_typexa#750313 AS AL_TYPEXA_438389#750974, al_type#750308 AS AL_TYPE_438384#750975, al_type_icd#750359 AS AL_TYPE_ICD_438435#750976, al_t_red#750318 AS AL_T_RED_438394#750977, al_urg#750351 AS AL_URG_438427#750978, al_valcou#750303 AS AL_VALCOU_438379#750980, null AS ORIGINE_440156#750996]
Input [59]: [al_annval#750302, al_classe#750321, al_codcha#750348, al_codsit#750311, al_coduti#750310, al_codval#750301, al_comment#750346, al_datede#750344, al_datefi#750356, al_datmaj#750309, al_envadm#750317, al_flicpt#750343, al_flsej#750342, al_fltele#750347, al_forfai#750320, al_icd#750358, al_int_spe#750353, al_int_std#750352, al_letadm#750316, al_letads#750349, al_lib30#750304, al_libmaj#750305, al_monnaie#750312, al_numbmp#750314, al_numcpt#750345, al_ordre#750315, al_primai#750357, al_prior#750307, al_rcp#750355, al_rembours#750323, al_revers#750322, al_sites#750350, al_spl_trans#750354, al_taux#750306, al_taux_r#750319, al_taux_t1r#750333, al_taux_t1#750324, al_taux_t2r#750334, al_taux_t2#750325, al_taux_t3r#750335, al_taux_t3#750326, al_taux_t4r#750336, al_taux_t4#750327, al_taux_t5r#750337, al_taux_t5#750328, al_taux_t6r#750338, al_taux_t6#750329, al_taux_t7r#750339, al_taux_t7#750330, al_taux_t8r#750340, al_taux_t8#750331, al_taux_t9r#750341, al_taux_t9#750332, al_typexa#750313, al_type#750308, al_type_icd#750359, al_t_red#750318, al_urg#750351, al_valcou#750303]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Keys [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]

(9) Exchange
Input [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Arguments: hashpartitioning(AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=40181]

(10) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Arguments: 0

(11) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Keys [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(16) HashAggregate [codegen id : 5]
Input [1]: [count#752007L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#751939L]
Results [1]: [count(1)#751939L AS COL_34b7c2c3-1bfc-43dc-bd7a-c36f60fe8b7e#751941L]

(17) Union

(18) HashAggregate
Input [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Keys [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]

(19) Exchange
Input [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Arguments: hashpartitioning(AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=40149]

(20) HashAggregate
Input [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Keys [60]: [AL_ANNVAL_438378#749915, AL_CLASSE_438397#749916, AL_CODCHA_438424#749917, AL_CODSIT_438387#749918, AL_CODUTI_438386#749919, AL_CODVAL_438377#749920, AL_COMMENT_438422#749921, AL_DATEDE_438420#749922, AL_DATEFI_438432#749923, AL_DATMAJ_438385#749924, AL_ENVADM_438393#749925, AL_FLICPT_438419#749926, AL_FLSEJ_438418#749927, AL_FLTELE_438423#749928, AL_FORFAI_438396#749929, AL_ICD_438434#749930, AL_INT_SPE_438429#749931, AL_INT_STD_438428#749932, AL_LETADM_438392#749933, AL_LETADS_438425#749934, AL_LIB30_438380#749935, AL_LIBMAJ_438381#749936, AL_MONNAIE_438388#749937, AL_NUMBMP_438390#749938, AL_NUMCPT_438421#749939, AL_ORDRE_438391#749940, AL_PRIMAI_438433#749941, AL_PRIOR_438383#749942, AL_RCP_438431#749943, AL_REMBOURS_438399#749944, AL_REVERS_438398#749945, AL_SITES_438426#749946, AL_SPL_TRANS_438430#749947, AL_TAUX_438382#749948, AL_TAUX_R_438395#749949, AL_TAUX_T1R_438409#749950, AL_TAUX_T1_438400#749951, AL_TAUX_T2R_438410#749952, AL_TAUX_T2_438401#749953, AL_TAUX_T3R_438411#749954, AL_TAUX_T3_438402#749955, AL_TAUX_T4R_438412#749956, AL_TAUX_T4_438403#749957, AL_TAUX_T5R_438413#749958, AL_TAUX_T5_438404#749959, AL_TAUX_T6R_438414#749960, AL_TAUX_T6_438405#749961, AL_TAUX_T7R_438415#749962, AL_TAUX_T7_438406#749963, AL_TAUX_T8R_438416#749964, AL_TAUX_T8_438407#749965, AL_TAUX_T9R_438417#749966, AL_TAUX_T9_438408#749967, AL_TYPEXA_438389#749968, AL_TYPE_438384#749969, AL_TYPE_ICD_438435#749970, AL_T_RED_438394#749971, AL_URG_438427#749972, AL_VALCOU_438379#749973, ORIGINE_440156#749974]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(23) HashAggregate
Input [1]: [count#752007L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#751939L]
Results [1]: [count(1)#751939L AS COL_34b7c2c3-1bfc-43dc-bd7a-c36f60fe8b7e#751941L]

(24) AdaptiveSparkPlan
Output [1]: [COL_34b7c2c3-1bfc-43dc-bd7a-c36f60fe8b7e#751941L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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