hdh-spark-job - Details for Query 1172

Submitted Time: 2026/10/23 11:57:14
Duration: 0.4 s
Succeeded Jobs: 1174 1175 1176

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: 113 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 113 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: 105 ms peak memory: 64.5 MiB number of output rows: 9,180 number of sort fallback tasks: 0 avg hash probes per key: 1.3"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1957.4 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 18,360 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 6 ms (3 ms, 3 ms, 3 ms (stage 1620.0: task 1442)) 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: 18,360 local bytes read: 1860.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)) 14.5 MiB (7.3 MiB, 7.3 MiB, 7.3 MiB (stage 1620.0: task 1442)) 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)) 1860.5 KiB (930.3 KiB, 930.3 KiB, 930.3 KiB (stage 1620.0: task 1442))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n284 ms (139 ms, 145 ms, 145 ms (stage 1620.0: task 1442))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 178 ms (86 ms, 92 ms, 92 ms (stage 1620.0: task 1442)) peak memory total (min, med, max (stageId: taskId)) 129.0 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 1620.0: task 1442)) number of output rows: 18,360 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1.4, 1.4, 1.4 (stage 1620.0: task 1442))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 103 ms"; 13 [labelType="html" label=" Project "]; 14 [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 cluster15 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 109 ms"; 16 [labelType="html" label=" Project "]; 17 [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; 16->11; 17->16; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (5)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26935]

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

HashAggregate(keys=[AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26899]

WholeStageCodegen (3)

Union

Project [al_annval#442262 AS AL_ANNVAL_438378#442674, al_classe#442281 AS AL_CLASSE_438397#442675, al_codcha#442308 AS AL_CODCHA_438424#442676, al_codsit#442271 AS AL_CODSIT_438387#442677, al_coduti#442270 AS AL_CODUTI_438386#442678, al_codval#442261 AS AL_CODVAL_438377#442679, al_comment#442306 AS AL_COMMENT_438422#442680, al_datede#442304 AS AL_DATEDE_438420#442681, al_datefi#442316 AS AL_DATEFI_438432#442682, al_datmaj#442269 AS AL_DATMAJ_438385#442683, al_envadm#442277 AS AL_ENVADM_438393#442684, al_flicpt#442303 AS AL_FLICPT_438419#442685, al_flsej#442302 AS AL_FLSEJ_438418#442686, al_fltele#442307 AS AL_FLTELE_438423#442687, al_forfai#442280 AS AL_FORFAI_438396#442688, al_icd#442318 AS AL_ICD_438434#442689, al_int_spe#442313 AS AL_INT_SPE_438429#442690, al_int_std#442312 AS AL_INT_STD_438428#442691, al_letadm#442276 AS AL_LETADM_438392#442692, al_letads#442309 AS AL_LETADS_438425#442693, al_lib30#442264 AS AL_LIB30_438380#442694, al_libmaj#442265 AS AL_LIBMAJ_438381#442695, al_monnaie#442272 AS AL_MONNAIE_438388#442696, al_numbmp#442274 AS AL_NUMBMP_438390#442697, ... 36 more fields]

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#442262,al_classe#442281,al_codcha#442308,al_codsit#442271,al_coduti#442270,al_codval#442261,al_comment#442306,al_datede#442304,al_datefi#442316,al_datmaj#442269,al_envadm#442277,al_flicpt#442303,al_flsej#442302,al_fltele#442307,al_forfai#442280,al_icd#442318,al_int_spe#442313,al_int_std#442312,al_letadm#442276,al_letads#442309,al_lib30#442264,al_libmaj#442265,al_monnaie#442272,al_numbmp#442274,... 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#442795 AS AL_ANNVAL_438378#443207, al_classe#442814 AS AL_CLASSE_438397#443208, al_codcha#442841 AS AL_CODCHA_438424#443209, al_codsit#442804 AS AL_CODSIT_438387#443210, al_coduti#442803 AS AL_CODUTI_438386#443211, al_codval#442794 AS AL_CODVAL_438377#443212, al_comment#442839 AS AL_COMMENT_438422#443213, al_datede#442837 AS AL_DATEDE_438420#443214, al_datefi#442849 AS AL_DATEFI_438432#443215, al_datmaj#442802 AS AL_DATMAJ_438385#443216, al_envadm#442810 AS AL_ENVADM_438393#443217, al_flicpt#442836 AS AL_FLICPT_438419#443218, al_flsej#442835 AS AL_FLSEJ_438418#443219, al_fltele#442840 AS AL_FLTELE_438423#443220, al_forfai#442813 AS AL_FORFAI_438396#443221, al_icd#442851 AS AL_ICD_438434#443222, al_int_spe#442846 AS AL_INT_SPE_438429#443223, al_int_std#442845 AS AL_INT_STD_438428#443224, al_letadm#442809 AS AL_LETADM_438392#443225, al_letads#442842 AS AL_LETADS_438425#443226, al_lib30#442797 AS AL_LIB30_438380#443227, al_libmaj#442798 AS AL_LIBMAJ_438381#443228, al_monnaie#442805 AS AL_MONNAIE_438388#443229, al_numbmp#442807 AS AL_NUMBMP_438390#443230, ... 36 more fields]

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#442795,al_classe#442814,al_codcha#442841,al_codsit#442804,al_coduti#442803,al_codval#442794,al_comment#442839,al_datede#442837,al_datefi#442849,al_datmaj#442802,al_envadm#442810,al_flicpt#442836,al_flsej#442835,al_fltele#442840,al_forfai#442813,al_icd#442851,al_int_spe#442846,al_int_std#442845,al_letadm#442809,al_letads#442842,al_lib30#442797,al_libmaj#442798,al_monnaie#442805,al_numbmp#442807,... 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 (22)
+- == Final Plan ==
   * HashAggregate (14)
   +- ShuffleQueryStage (13), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (12)
         +- * HashAggregate (11)
            +- * HashAggregate (10)
               +- AQEShuffleRead (9)
                  +- ShuffleQueryStage (8), Statistics(sizeInBytes=14.5 MiB, rowCount=1.84E+4)
                     +- Exchange (7)
                        +- * HashAggregate (6)
                           +- Union (5)
                              :- * Project (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 (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]  (3)
+- == Initial Plan ==
   HashAggregate (21)
   +- Exchange (20)
      +- HashAggregate (19)
         +- HashAggregate (18)
            +- Exchange (17)
               +- HashAggregate (16)
                  +- Union (15)
                     :- Project (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 (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]  (3)


(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#442262, al_classe#442281, al_codcha#442308, al_codsit#442271, al_coduti#442270, al_codval#442261, al_comment#442306, al_datede#442304, al_datefi#442316, al_datmaj#442269, al_envadm#442277, al_flicpt#442303, al_flsej#442302, al_fltele#442307, al_forfai#442280, al_icd#442318, al_int_spe#442313, al_int_std#442312, al_letadm#442276, al_letads#442309, al_lib30#442264, al_libmaj#442265, al_monnaie#442272, al_numbmp#442274, al_numcpt#442305, al_ordre#442275, al_primai#442317, al_prior#442267, al_rcp#442315, al_rembours#442283, al_revers#442282, al_sites#442310, al_spl_trans#442314, al_taux#442266, al_taux_r#442279, al_taux_t1r#442293, al_taux_t1#442284, al_taux_t2r#442294, al_taux_t2#442285, al_taux_t3r#442295, al_taux_t3#442286, al_taux_t4r#442296, al_taux_t4#442287, al_taux_t5r#442297, al_taux_t5#442288, al_taux_t6r#442298, al_taux_t6#442289, al_taux_t7r#442299, al_taux_t7#442290, al_taux_t8r#442300, al_taux_t8#442291, al_taux_t9r#442301, al_taux_t9#442292, al_typexa#442273, al_type#442268, al_type_icd#442319, al_t_red#442278, al_urg#442311, al_valcou#442263]
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) Project [codegen id : 1]
Output [60]: [al_annval#442262 AS AL_ANNVAL_438378#442674, al_classe#442281 AS AL_CLASSE_438397#442675, al_codcha#442308 AS AL_CODCHA_438424#442676, al_codsit#442271 AS AL_CODSIT_438387#442677, al_coduti#442270 AS AL_CODUTI_438386#442678, al_codval#442261 AS AL_CODVAL_438377#442679, al_comment#442306 AS AL_COMMENT_438422#442680, al_datede#442304 AS AL_DATEDE_438420#442681, al_datefi#442316 AS AL_DATEFI_438432#442682, al_datmaj#442269 AS AL_DATMAJ_438385#442683, al_envadm#442277 AS AL_ENVADM_438393#442684, al_flicpt#442303 AS AL_FLICPT_438419#442685, al_flsej#442302 AS AL_FLSEJ_438418#442686, al_fltele#442307 AS AL_FLTELE_438423#442687, al_forfai#442280 AS AL_FORFAI_438396#442688, al_icd#442318 AS AL_ICD_438434#442689, al_int_spe#442313 AS AL_INT_SPE_438429#442690, al_int_std#442312 AS AL_INT_STD_438428#442691, al_letadm#442276 AS AL_LETADM_438392#442692, al_letads#442309 AS AL_LETADS_438425#442693, al_lib30#442264 AS AL_LIB30_438380#442694, al_libmaj#442265 AS AL_LIBMAJ_438381#442695, al_monnaie#442272 AS AL_MONNAIE_438388#442696, al_numbmp#442274 AS AL_NUMBMP_438390#442697, al_numcpt#442305 AS AL_NUMCPT_438421#442698, al_ordre#442275 AS AL_ORDRE_438391#442699, al_primai#442317 AS AL_PRIMAI_438433#442700, al_prior#442267 AS AL_PRIOR_438383#442701, al_rcp#442315 AS AL_RCP_438431#442702, al_rembours#442283 AS AL_REMBOURS_438399#442703, al_revers#442282 AS AL_REVERS_438398#442704, al_sites#442310 AS AL_SITES_438426#442705, al_spl_trans#442314 AS AL_SPL_TRANS_438430#442706, al_taux#442266 AS AL_TAUX_438382#442707, al_taux_r#442279 AS AL_TAUX_R_438395#442708, al_taux_t1r#442293 AS AL_TAUX_T1R_438409#442709, al_taux_t1#442284 AS AL_TAUX_T1_438400#442710, al_taux_t2r#442294 AS AL_TAUX_T2R_438410#442711, al_taux_t2#442285 AS AL_TAUX_T2_438401#442712, al_taux_t3r#442295 AS AL_TAUX_T3R_438411#442713, al_taux_t3#442286 AS AL_TAUX_T3_438402#442714, al_taux_t4r#442296 AS AL_TAUX_T4R_438412#442715, al_taux_t4#442287 AS AL_TAUX_T4_438403#442716, al_taux_t5r#442297 AS AL_TAUX_T5R_438413#442717, al_taux_t5#442288 AS AL_TAUX_T5_438404#442718, al_taux_t6r#442298 AS AL_TAUX_T6R_438414#442719, al_taux_t6#442289 AS AL_TAUX_T6_438405#442720, al_taux_t7r#442299 AS AL_TAUX_T7R_438415#442721, al_taux_t7#442290 AS AL_TAUX_T7_438406#442722, al_taux_t8r#442300 AS AL_TAUX_T8R_438416#442723, al_taux_t8#442291 AS AL_TAUX_T8_438407#442724, al_taux_t9r#442301 AS AL_TAUX_T9R_438417#442725, al_taux_t9#442292 AS AL_TAUX_T9_438408#442726, al_typexa#442273 AS AL_TYPEXA_438389#442727, al_type#442268 AS AL_TYPE_438384#442728, al_type_icd#442319 AS AL_TYPE_ICD_438435#442729, al_t_red#442278 AS AL_T_RED_438394#442730, al_urg#442311 AS AL_URG_438427#442731, al_valcou#442263 AS AL_VALCOU_438379#442732, null AS ORIGINE_440156#442733]
Input [59]: [al_annval#442262, al_classe#442281, al_codcha#442308, al_codsit#442271, al_coduti#442270, al_codval#442261, al_comment#442306, al_datede#442304, al_datefi#442316, al_datmaj#442269, al_envadm#442277, al_flicpt#442303, al_flsej#442302, al_fltele#442307, al_forfai#442280, al_icd#442318, al_int_spe#442313, al_int_std#442312, al_letadm#442276, al_letads#442309, al_lib30#442264, al_libmaj#442265, al_monnaie#442272, al_numbmp#442274, al_numcpt#442305, al_ordre#442275, al_primai#442317, al_prior#442267, al_rcp#442315, al_rembours#442283, al_revers#442282, al_sites#442310, al_spl_trans#442314, al_taux#442266, al_taux_r#442279, al_taux_t1r#442293, al_taux_t1#442284, al_taux_t2r#442294, al_taux_t2#442285, al_taux_t3r#442295, al_taux_t3#442286, al_taux_t4r#442296, al_taux_t4#442287, al_taux_t5r#442297, al_taux_t5#442288, al_taux_t6r#442298, al_taux_t6#442289, al_taux_t7r#442299, al_taux_t7#442290, al_taux_t8r#442300, al_taux_t8#442291, al_taux_t9r#442301, al_taux_t9#442292, al_typexa#442273, al_type#442268, al_type_icd#442319, al_t_red#442278, al_urg#442311, al_valcou#442263]

(3) 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#442795, al_classe#442814, al_codcha#442841, al_codsit#442804, al_coduti#442803, al_codval#442794, al_comment#442839, al_datede#442837, al_datefi#442849, al_datmaj#442802, al_envadm#442810, al_flicpt#442836, al_flsej#442835, al_fltele#442840, al_forfai#442813, al_icd#442851, al_int_spe#442846, al_int_std#442845, al_letadm#442809, al_letads#442842, al_lib30#442797, al_libmaj#442798, al_monnaie#442805, al_numbmp#442807, al_numcpt#442838, al_ordre#442808, al_primai#442850, al_prior#442800, al_rcp#442848, al_rembours#442816, al_revers#442815, al_sites#442843, al_spl_trans#442847, al_taux#442799, al_taux_r#442812, al_taux_t1r#442826, al_taux_t1#442817, al_taux_t2r#442827, al_taux_t2#442818, al_taux_t3r#442828, al_taux_t3#442819, al_taux_t4r#442829, al_taux_t4#442820, al_taux_t5r#442830, al_taux_t5#442821, al_taux_t6r#442831, al_taux_t6#442822, al_taux_t7r#442832, al_taux_t7#442823, al_taux_t8r#442833, al_taux_t8#442824, al_taux_t9r#442834, al_taux_t9#442825, al_typexa#442806, al_type#442801, al_type_icd#442852, al_t_red#442811, al_urg#442844, al_valcou#442796]
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>

(4) Project [codegen id : 2]
Output [60]: [al_annval#442795 AS AL_ANNVAL_438378#443207, al_classe#442814 AS AL_CLASSE_438397#443208, al_codcha#442841 AS AL_CODCHA_438424#443209, al_codsit#442804 AS AL_CODSIT_438387#443210, al_coduti#442803 AS AL_CODUTI_438386#443211, al_codval#442794 AS AL_CODVAL_438377#443212, al_comment#442839 AS AL_COMMENT_438422#443213, al_datede#442837 AS AL_DATEDE_438420#443214, al_datefi#442849 AS AL_DATEFI_438432#443215, al_datmaj#442802 AS AL_DATMAJ_438385#443216, al_envadm#442810 AS AL_ENVADM_438393#443217, al_flicpt#442836 AS AL_FLICPT_438419#443218, al_flsej#442835 AS AL_FLSEJ_438418#443219, al_fltele#442840 AS AL_FLTELE_438423#443220, al_forfai#442813 AS AL_FORFAI_438396#443221, al_icd#442851 AS AL_ICD_438434#443222, al_int_spe#442846 AS AL_INT_SPE_438429#443223, al_int_std#442845 AS AL_INT_STD_438428#443224, al_letadm#442809 AS AL_LETADM_438392#443225, al_letads#442842 AS AL_LETADS_438425#443226, al_lib30#442797 AS AL_LIB30_438380#443227, al_libmaj#442798 AS AL_LIBMAJ_438381#443228, al_monnaie#442805 AS AL_MONNAIE_438388#443229, al_numbmp#442807 AS AL_NUMBMP_438390#443230, al_numcpt#442838 AS AL_NUMCPT_438421#443231, al_ordre#442808 AS AL_ORDRE_438391#443232, al_primai#442850 AS AL_PRIMAI_438433#443233, al_prior#442800 AS AL_PRIOR_438383#443234, al_rcp#442848 AS AL_RCP_438431#443235, al_rembours#442816 AS AL_REMBOURS_438399#443236, al_revers#442815 AS AL_REVERS_438398#443237, al_sites#442843 AS AL_SITES_438426#443238, al_spl_trans#442847 AS AL_SPL_TRANS_438430#443239, al_taux#442799 AS AL_TAUX_438382#443240, al_taux_r#442812 AS AL_TAUX_R_438395#443241, al_taux_t1r#442826 AS AL_TAUX_T1R_438409#443242, al_taux_t1#442817 AS AL_TAUX_T1_438400#443243, al_taux_t2r#442827 AS AL_TAUX_T2R_438410#443244, al_taux_t2#442818 AS AL_TAUX_T2_438401#443245, al_taux_t3r#442828 AS AL_TAUX_T3R_438411#443246, al_taux_t3#442819 AS AL_TAUX_T3_438402#443247, al_taux_t4r#442829 AS AL_TAUX_T4R_438412#443248, al_taux_t4#442820 AS AL_TAUX_T4_438403#443249, al_taux_t5r#442830 AS AL_TAUX_T5R_438413#443250, al_taux_t5#442821 AS AL_TAUX_T5_438404#443251, al_taux_t6r#442831 AS AL_TAUX_T6R_438414#443252, al_taux_t6#442822 AS AL_TAUX_T6_438405#443253, al_taux_t7r#442832 AS AL_TAUX_T7R_438415#443254, al_taux_t7#442823 AS AL_TAUX_T7_438406#443255, al_taux_t8r#442833 AS AL_TAUX_T8R_438416#443256, al_taux_t8#442824 AS AL_TAUX_T8_438407#443257, al_taux_t9r#442834 AS AL_TAUX_T9R_438417#443258, al_taux_t9#442825 AS AL_TAUX_T9_438408#443259, al_typexa#442806 AS AL_TYPEXA_438389#443260, al_type#442801 AS AL_TYPE_438384#443261, al_type_icd#442852 AS AL_TYPE_ICD_438435#443262, al_t_red#442811 AS AL_T_RED_438394#443263, al_urg#442844 AS AL_URG_438427#443264, al_valcou#442796 AS AL_VALCOU_438379#443265, null AS ORIGINE_440156#443266]
Input [59]: [al_annval#442795, al_classe#442814, al_codcha#442841, al_codsit#442804, al_coduti#442803, al_codval#442794, al_comment#442839, al_datede#442837, al_datefi#442849, al_datmaj#442802, al_envadm#442810, al_flicpt#442836, al_flsej#442835, al_fltele#442840, al_forfai#442813, al_icd#442851, al_int_spe#442846, al_int_std#442845, al_letadm#442809, al_letads#442842, al_lib30#442797, al_libmaj#442798, al_monnaie#442805, al_numbmp#442807, al_numcpt#442838, al_ordre#442808, al_primai#442850, al_prior#442800, al_rcp#442848, al_rembours#442816, al_revers#442815, al_sites#442843, al_spl_trans#442847, al_taux#442799, al_taux_r#442812, al_taux_t1r#442826, al_taux_t1#442817, al_taux_t2r#442827, al_taux_t2#442818, al_taux_t3r#442828, al_taux_t3#442819, al_taux_t4r#442829, al_taux_t4#442820, al_taux_t5r#442830, al_taux_t5#442821, al_taux_t6r#442831, al_taux_t6#442822, al_taux_t7r#442832, al_taux_t7#442823, al_taux_t8r#442833, al_taux_t8#442824, al_taux_t9r#442834, al_taux_t9#442825, al_typexa#442806, al_type#442801, al_type_icd#442852, al_t_red#442811, al_urg#442844, al_valcou#442796]

(5) Union

(6) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Keys [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]

(7) Exchange
Input [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Arguments: hashpartitioning(AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26899]

(8) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Arguments: 0

(9) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Arguments: coalesced

(10) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Keys [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Functions: []
Aggregate Attributes: []
Results: []

(11) HashAggregate [codegen id : 4]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#444290L]
Results [1]: [count#444291L]

(12) Exchange
Input [1]: [count#444291L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26935]

(13) ShuffleQueryStage
Output [1]: [count#444291L]
Arguments: 1

(14) HashAggregate [codegen id : 5]
Input [1]: [count#444291L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#444287L]
Results [1]: [count(1)#444287L AS count#444288L]

(15) Union

(16) HashAggregate
Input [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Keys [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]

(17) Exchange
Input [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Arguments: hashpartitioning(AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26871]

(18) HashAggregate
Input [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Keys [60]: [AL_ANNVAL_438378#442674, AL_CLASSE_438397#442675, AL_CODCHA_438424#442676, AL_CODSIT_438387#442677, AL_CODUTI_438386#442678, AL_CODVAL_438377#442679, AL_COMMENT_438422#442680, AL_DATEDE_438420#442681, AL_DATEFI_438432#442682, AL_DATMAJ_438385#442683, AL_ENVADM_438393#442684, AL_FLICPT_438419#442685, AL_FLSEJ_438418#442686, AL_FLTELE_438423#442687, AL_FORFAI_438396#442688, AL_ICD_438434#442689, AL_INT_SPE_438429#442690, AL_INT_STD_438428#442691, AL_LETADM_438392#442692, AL_LETADS_438425#442693, AL_LIB30_438380#442694, AL_LIBMAJ_438381#442695, AL_MONNAIE_438388#442696, AL_NUMBMP_438390#442697, AL_NUMCPT_438421#442698, AL_ORDRE_438391#442699, AL_PRIMAI_438433#442700, AL_PRIOR_438383#442701, AL_RCP_438431#442702, AL_REMBOURS_438399#442703, AL_REVERS_438398#442704, AL_SITES_438426#442705, AL_SPL_TRANS_438430#442706, AL_TAUX_438382#442707, AL_TAUX_R_438395#442708, AL_TAUX_T1R_438409#442709, AL_TAUX_T1_438400#442710, AL_TAUX_T2R_438410#442711, AL_TAUX_T2_438401#442712, AL_TAUX_T3R_438411#442713, AL_TAUX_T3_438402#442714, AL_TAUX_T4R_438412#442715, AL_TAUX_T4_438403#442716, AL_TAUX_T5R_438413#442717, AL_TAUX_T5_438404#442718, AL_TAUX_T6R_438414#442719, AL_TAUX_T6_438405#442720, AL_TAUX_T7R_438415#442721, AL_TAUX_T7_438406#442722, AL_TAUX_T8R_438416#442723, AL_TAUX_T8_438407#442724, AL_TAUX_T9R_438417#442725, AL_TAUX_T9_438408#442726, AL_TYPEXA_438389#442727, AL_TYPE_438384#442728, AL_TYPE_ICD_438435#442729, AL_T_RED_438394#442730, AL_URG_438427#442731, AL_VALCOU_438379#442732, ORIGINE_440156#442733]
Functions: []
Aggregate Attributes: []
Results: []

(19) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#444290L]
Results [1]: [count#444291L]

(20) Exchange
Input [1]: [count#444291L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26875]

(21) HashAggregate
Input [1]: [count#444291L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#444287L]
Results [1]: [count(1)#444287L AS count#444288L]

(22) AdaptiveSparkPlan
Output [1]: [count#444288L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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