hdh-spark-job - Details for Query 1147

Submitted Time: 2026/10/23 11:41:34
Duration: 0.7 s
Succeeded Jobs: 1152 1153 1154

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="SortAggregate number of output rows: 1"]; 2 [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: 101.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: 64.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: 101.0 B"]; 3 [labelType="html" label="SortAggregate number of output rows: 1"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 152 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 117 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"]; } 6 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1957.4 KiB number of coalesced partitions: 1"]; 7 [labelType="html" label="Exchange shuffle records written: 18,360 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 7 ms (3 ms, 3 ms, 3 ms (stage 1580.0: task 1412)) 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 1580.0: task 1412)) 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 1580.0: task 1412))"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n379 ms (172 ms, 207 ms, 207 ms (stage 1580.0: task 1411))"; 9 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 284 ms (123 ms, 161 ms, 161 ms (stage 1580.0: task 1411)) peak memory total (min, med, max (stageId: taskId)) 129.0 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 1580.0: task 1412)) 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 1580.0: task 1412))"]; } 10 [labelType="html" label=" Union "]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 171 ms"; 12 [labelType="html" label=" Project "]; 13 [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 cluster14 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 133 ms"; 15 [labelType="html" label=" Project "]; 16 [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"]; } 1->0; 2->1; 3->2; 5->3; 6->5; 7->6; 9->7; 10->9; 12->10; 13->12; 15->10; 16->15; }

AdaptiveSparkPlan isFinalPlan=true

SortAggregate(key=[], functions=[count(1), count(COL_AL_VALCOU_438379#424425), min(COL_AL_VALCOU_438379#424425), max(COL_AL_VALCOU_438379#424425)])

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26081]

SortAggregate(key=[], functions=[partial_count(1), partial_count(COL_AL_VALCOU_438379#424425), partial_min(COL_AL_VALCOU_438379#424425), partial_max(COL_AL_VALCOU_438379#424425)])

HashAggregate(keys=[AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26045]

WholeStageCodegen (3)

Union

Project [al_annval#422758 AS AL_ANNVAL_438378#423170, al_classe#422777 AS AL_CLASSE_438397#423171, al_codcha#422804 AS AL_CODCHA_438424#423172, al_codsit#422767 AS AL_CODSIT_438387#423173, al_coduti#422766 AS AL_CODUTI_438386#423174, al_codval#422757 AS AL_CODVAL_438377#423175, al_comment#422802 AS AL_COMMENT_438422#423176, al_datede#422800 AS AL_DATEDE_438420#423177, al_datefi#422812 AS AL_DATEFI_438432#423178, al_datmaj#422765 AS AL_DATMAJ_438385#423179, al_envadm#422773 AS AL_ENVADM_438393#423180, al_flicpt#422799 AS AL_FLICPT_438419#423181, al_flsej#422798 AS AL_FLSEJ_438418#423182, al_fltele#422803 AS AL_FLTELE_438423#423183, al_forfai#422776 AS AL_FORFAI_438396#423184, al_icd#422814 AS AL_ICD_438434#423185, al_int_spe#422809 AS AL_INT_SPE_438429#423186, al_int_std#422808 AS AL_INT_STD_438428#423187, al_letadm#422772 AS AL_LETADM_438392#423188, al_letads#422805 AS AL_LETADS_438425#423189, al_lib30#422760 AS AL_LIB30_438380#423190, al_libmaj#422761 AS AL_LIBMAJ_438381#423191, al_monnaie#422768 AS AL_MONNAIE_438388#423192, al_numbmp#422770 AS AL_NUMBMP_438390#423193, ... 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#422758,al_classe#422777,al_codcha#422804,al_codsit#422767,al_coduti#422766,al_codval#422757,al_comment#422802,al_datede#422800,al_datefi#422812,al_datmaj#422765,al_envadm#422773,al_flicpt#422799,al_flsej#422798,al_fltele#422803,al_forfai#422776,al_icd#422814,al_int_spe#422809,al_int_std#422808,al_letadm#422772,al_letads#422805,al_lib30#422760,al_libmaj#422761,al_monnaie#422768,al_numbmp#422770,... 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#423291 AS AL_ANNVAL_438378#423703, al_classe#423310 AS AL_CLASSE_438397#423704, al_codcha#423337 AS AL_CODCHA_438424#423705, al_codsit#423300 AS AL_CODSIT_438387#423706, al_coduti#423299 AS AL_CODUTI_438386#423707, al_codval#423290 AS AL_CODVAL_438377#423708, al_comment#423335 AS AL_COMMENT_438422#423709, al_datede#423333 AS AL_DATEDE_438420#423710, al_datefi#423345 AS AL_DATEFI_438432#423711, al_datmaj#423298 AS AL_DATMAJ_438385#423712, al_envadm#423306 AS AL_ENVADM_438393#423713, al_flicpt#423332 AS AL_FLICPT_438419#423714, al_flsej#423331 AS AL_FLSEJ_438418#423715, al_fltele#423336 AS AL_FLTELE_438423#423716, al_forfai#423309 AS AL_FORFAI_438396#423717, al_icd#423347 AS AL_ICD_438434#423718, al_int_spe#423342 AS AL_INT_SPE_438429#423719, al_int_std#423341 AS AL_INT_STD_438428#423720, al_letadm#423305 AS AL_LETADM_438392#423721, al_letads#423338 AS AL_LETADS_438425#423722, al_lib30#423293 AS AL_LIB30_438380#423723, al_libmaj#423294 AS AL_LIBMAJ_438381#423724, al_monnaie#423301 AS AL_MONNAIE_438388#423725, al_numbmp#423303 AS AL_NUMBMP_438390#423726, ... 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#423291,al_classe#423310,al_codcha#423337,al_codsit#423300,al_coduti#423299,al_codval#423290,al_comment#423335,al_datede#423333,al_datefi#423345,al_datmaj#423298,al_envadm#423306,al_flicpt#423332,al_flsej#423331,al_fltele#423336,al_forfai#423309,al_icd#423347,al_int_spe#423342,al_int_std#423341,al_letadm#423305,al_letads#423338,al_lib30#423293,al_libmaj#423294,al_monnaie#423301,al_numbmp#423303,... 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 ==
   SortAggregate (14)
   +- ShuffleQueryStage (13), Statistics(sizeInBytes=64.0 B, rowCount=1)
      +- Exchange (12)
         +- SortAggregate (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 ==
   SortAggregate (21)
   +- Exchange (20)
      +- SortAggregate (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#422758, al_classe#422777, al_codcha#422804, al_codsit#422767, al_coduti#422766, al_codval#422757, al_comment#422802, al_datede#422800, al_datefi#422812, al_datmaj#422765, al_envadm#422773, al_flicpt#422799, al_flsej#422798, al_fltele#422803, al_forfai#422776, al_icd#422814, al_int_spe#422809, al_int_std#422808, al_letadm#422772, al_letads#422805, al_lib30#422760, al_libmaj#422761, al_monnaie#422768, al_numbmp#422770, al_numcpt#422801, al_ordre#422771, al_primai#422813, al_prior#422763, al_rcp#422811, al_rembours#422779, al_revers#422778, al_sites#422806, al_spl_trans#422810, al_taux#422762, al_taux_r#422775, al_taux_t1r#422789, al_taux_t1#422780, al_taux_t2r#422790, al_taux_t2#422781, al_taux_t3r#422791, al_taux_t3#422782, al_taux_t4r#422792, al_taux_t4#422783, al_taux_t5r#422793, al_taux_t5#422784, al_taux_t6r#422794, al_taux_t6#422785, al_taux_t7r#422795, al_taux_t7#422786, al_taux_t8r#422796, al_taux_t8#422787, al_taux_t9r#422797, al_taux_t9#422788, al_typexa#422769, al_type#422764, al_type_icd#422815, al_t_red#422774, al_urg#422807, al_valcou#422759]
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#422758 AS AL_ANNVAL_438378#423170, al_classe#422777 AS AL_CLASSE_438397#423171, al_codcha#422804 AS AL_CODCHA_438424#423172, al_codsit#422767 AS AL_CODSIT_438387#423173, al_coduti#422766 AS AL_CODUTI_438386#423174, al_codval#422757 AS AL_CODVAL_438377#423175, al_comment#422802 AS AL_COMMENT_438422#423176, al_datede#422800 AS AL_DATEDE_438420#423177, al_datefi#422812 AS AL_DATEFI_438432#423178, al_datmaj#422765 AS AL_DATMAJ_438385#423179, al_envadm#422773 AS AL_ENVADM_438393#423180, al_flicpt#422799 AS AL_FLICPT_438419#423181, al_flsej#422798 AS AL_FLSEJ_438418#423182, al_fltele#422803 AS AL_FLTELE_438423#423183, al_forfai#422776 AS AL_FORFAI_438396#423184, al_icd#422814 AS AL_ICD_438434#423185, al_int_spe#422809 AS AL_INT_SPE_438429#423186, al_int_std#422808 AS AL_INT_STD_438428#423187, al_letadm#422772 AS AL_LETADM_438392#423188, al_letads#422805 AS AL_LETADS_438425#423189, al_lib30#422760 AS AL_LIB30_438380#423190, al_libmaj#422761 AS AL_LIBMAJ_438381#423191, al_monnaie#422768 AS AL_MONNAIE_438388#423192, al_numbmp#422770 AS AL_NUMBMP_438390#423193, al_numcpt#422801 AS AL_NUMCPT_438421#423194, al_ordre#422771 AS AL_ORDRE_438391#423195, al_primai#422813 AS AL_PRIMAI_438433#423196, al_prior#422763 AS AL_PRIOR_438383#423197, al_rcp#422811 AS AL_RCP_438431#423198, al_rembours#422779 AS AL_REMBOURS_438399#423199, al_revers#422778 AS AL_REVERS_438398#423200, al_sites#422806 AS AL_SITES_438426#423201, al_spl_trans#422810 AS AL_SPL_TRANS_438430#423202, al_taux#422762 AS AL_TAUX_438382#423203, al_taux_r#422775 AS AL_TAUX_R_438395#423204, al_taux_t1r#422789 AS AL_TAUX_T1R_438409#423205, al_taux_t1#422780 AS AL_TAUX_T1_438400#423206, al_taux_t2r#422790 AS AL_TAUX_T2R_438410#423207, al_taux_t2#422781 AS AL_TAUX_T2_438401#423208, al_taux_t3r#422791 AS AL_TAUX_T3R_438411#423209, al_taux_t3#422782 AS AL_TAUX_T3_438402#423210, al_taux_t4r#422792 AS AL_TAUX_T4R_438412#423211, al_taux_t4#422783 AS AL_TAUX_T4_438403#423212, al_taux_t5r#422793 AS AL_TAUX_T5R_438413#423213, al_taux_t5#422784 AS AL_TAUX_T5_438404#423214, al_taux_t6r#422794 AS AL_TAUX_T6R_438414#423215, al_taux_t6#422785 AS AL_TAUX_T6_438405#423216, al_taux_t7r#422795 AS AL_TAUX_T7R_438415#423217, al_taux_t7#422786 AS AL_TAUX_T7_438406#423218, al_taux_t8r#422796 AS AL_TAUX_T8R_438416#423219, al_taux_t8#422787 AS AL_TAUX_T8_438407#423220, al_taux_t9r#422797 AS AL_TAUX_T9R_438417#423221, al_taux_t9#422788 AS AL_TAUX_T9_438408#423222, al_typexa#422769 AS AL_TYPEXA_438389#423223, al_type#422764 AS AL_TYPE_438384#423224, al_type_icd#422815 AS AL_TYPE_ICD_438435#423225, al_t_red#422774 AS AL_T_RED_438394#423226, al_urg#422807 AS AL_URG_438427#423227, al_valcou#422759 AS AL_VALCOU_438379#423228, null AS ORIGINE_440156#423229]
Input [59]: [al_annval#422758, al_classe#422777, al_codcha#422804, al_codsit#422767, al_coduti#422766, al_codval#422757, al_comment#422802, al_datede#422800, al_datefi#422812, al_datmaj#422765, al_envadm#422773, al_flicpt#422799, al_flsej#422798, al_fltele#422803, al_forfai#422776, al_icd#422814, al_int_spe#422809, al_int_std#422808, al_letadm#422772, al_letads#422805, al_lib30#422760, al_libmaj#422761, al_monnaie#422768, al_numbmp#422770, al_numcpt#422801, al_ordre#422771, al_primai#422813, al_prior#422763, al_rcp#422811, al_rembours#422779, al_revers#422778, al_sites#422806, al_spl_trans#422810, al_taux#422762, al_taux_r#422775, al_taux_t1r#422789, al_taux_t1#422780, al_taux_t2r#422790, al_taux_t2#422781, al_taux_t3r#422791, al_taux_t3#422782, al_taux_t4r#422792, al_taux_t4#422783, al_taux_t5r#422793, al_taux_t5#422784, al_taux_t6r#422794, al_taux_t6#422785, al_taux_t7r#422795, al_taux_t7#422786, al_taux_t8r#422796, al_taux_t8#422787, al_taux_t9r#422797, al_taux_t9#422788, al_typexa#422769, al_type#422764, al_type_icd#422815, al_t_red#422774, al_urg#422807, al_valcou#422759]

(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#423291, al_classe#423310, al_codcha#423337, al_codsit#423300, al_coduti#423299, al_codval#423290, al_comment#423335, al_datede#423333, al_datefi#423345, al_datmaj#423298, al_envadm#423306, al_flicpt#423332, al_flsej#423331, al_fltele#423336, al_forfai#423309, al_icd#423347, al_int_spe#423342, al_int_std#423341, al_letadm#423305, al_letads#423338, al_lib30#423293, al_libmaj#423294, al_monnaie#423301, al_numbmp#423303, al_numcpt#423334, al_ordre#423304, al_primai#423346, al_prior#423296, al_rcp#423344, al_rembours#423312, al_revers#423311, al_sites#423339, al_spl_trans#423343, al_taux#423295, al_taux_r#423308, al_taux_t1r#423322, al_taux_t1#423313, al_taux_t2r#423323, al_taux_t2#423314, al_taux_t3r#423324, al_taux_t3#423315, al_taux_t4r#423325, al_taux_t4#423316, al_taux_t5r#423326, al_taux_t5#423317, al_taux_t6r#423327, al_taux_t6#423318, al_taux_t7r#423328, al_taux_t7#423319, al_taux_t8r#423329, al_taux_t8#423320, al_taux_t9r#423330, al_taux_t9#423321, al_typexa#423302, al_type#423297, al_type_icd#423348, al_t_red#423307, al_urg#423340, al_valcou#423292]
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#423291 AS AL_ANNVAL_438378#423703, al_classe#423310 AS AL_CLASSE_438397#423704, al_codcha#423337 AS AL_CODCHA_438424#423705, al_codsit#423300 AS AL_CODSIT_438387#423706, al_coduti#423299 AS AL_CODUTI_438386#423707, al_codval#423290 AS AL_CODVAL_438377#423708, al_comment#423335 AS AL_COMMENT_438422#423709, al_datede#423333 AS AL_DATEDE_438420#423710, al_datefi#423345 AS AL_DATEFI_438432#423711, al_datmaj#423298 AS AL_DATMAJ_438385#423712, al_envadm#423306 AS AL_ENVADM_438393#423713, al_flicpt#423332 AS AL_FLICPT_438419#423714, al_flsej#423331 AS AL_FLSEJ_438418#423715, al_fltele#423336 AS AL_FLTELE_438423#423716, al_forfai#423309 AS AL_FORFAI_438396#423717, al_icd#423347 AS AL_ICD_438434#423718, al_int_spe#423342 AS AL_INT_SPE_438429#423719, al_int_std#423341 AS AL_INT_STD_438428#423720, al_letadm#423305 AS AL_LETADM_438392#423721, al_letads#423338 AS AL_LETADS_438425#423722, al_lib30#423293 AS AL_LIB30_438380#423723, al_libmaj#423294 AS AL_LIBMAJ_438381#423724, al_monnaie#423301 AS AL_MONNAIE_438388#423725, al_numbmp#423303 AS AL_NUMBMP_438390#423726, al_numcpt#423334 AS AL_NUMCPT_438421#423727, al_ordre#423304 AS AL_ORDRE_438391#423728, al_primai#423346 AS AL_PRIMAI_438433#423729, al_prior#423296 AS AL_PRIOR_438383#423730, al_rcp#423344 AS AL_RCP_438431#423731, al_rembours#423312 AS AL_REMBOURS_438399#423732, al_revers#423311 AS AL_REVERS_438398#423733, al_sites#423339 AS AL_SITES_438426#423734, al_spl_trans#423343 AS AL_SPL_TRANS_438430#423735, al_taux#423295 AS AL_TAUX_438382#423736, al_taux_r#423308 AS AL_TAUX_R_438395#423737, al_taux_t1r#423322 AS AL_TAUX_T1R_438409#423738, al_taux_t1#423313 AS AL_TAUX_T1_438400#423739, al_taux_t2r#423323 AS AL_TAUX_T2R_438410#423740, al_taux_t2#423314 AS AL_TAUX_T2_438401#423741, al_taux_t3r#423324 AS AL_TAUX_T3R_438411#423742, al_taux_t3#423315 AS AL_TAUX_T3_438402#423743, al_taux_t4r#423325 AS AL_TAUX_T4R_438412#423744, al_taux_t4#423316 AS AL_TAUX_T4_438403#423745, al_taux_t5r#423326 AS AL_TAUX_T5R_438413#423746, al_taux_t5#423317 AS AL_TAUX_T5_438404#423747, al_taux_t6r#423327 AS AL_TAUX_T6R_438414#423748, al_taux_t6#423318 AS AL_TAUX_T6_438405#423749, al_taux_t7r#423328 AS AL_TAUX_T7R_438415#423750, al_taux_t7#423319 AS AL_TAUX_T7_438406#423751, al_taux_t8r#423329 AS AL_TAUX_T8R_438416#423752, al_taux_t8#423320 AS AL_TAUX_T8_438407#423753, al_taux_t9r#423330 AS AL_TAUX_T9R_438417#423754, al_taux_t9#423321 AS AL_TAUX_T9_438408#423755, al_typexa#423302 AS AL_TYPEXA_438389#423756, al_type#423297 AS AL_TYPE_438384#423757, al_type_icd#423348 AS AL_TYPE_ICD_438435#423758, al_t_red#423307 AS AL_T_RED_438394#423759, al_urg#423340 AS AL_URG_438427#423760, al_valcou#423292 AS AL_VALCOU_438379#423761, null AS ORIGINE_440156#423762]
Input [59]: [al_annval#423291, al_classe#423310, al_codcha#423337, al_codsit#423300, al_coduti#423299, al_codval#423290, al_comment#423335, al_datede#423333, al_datefi#423345, al_datmaj#423298, al_envadm#423306, al_flicpt#423332, al_flsej#423331, al_fltele#423336, al_forfai#423309, al_icd#423347, al_int_spe#423342, al_int_std#423341, al_letadm#423305, al_letads#423338, al_lib30#423293, al_libmaj#423294, al_monnaie#423301, al_numbmp#423303, al_numcpt#423334, al_ordre#423304, al_primai#423346, al_prior#423296, al_rcp#423344, al_rembours#423312, al_revers#423311, al_sites#423339, al_spl_trans#423343, al_taux#423295, al_taux_r#423308, al_taux_t1r#423322, al_taux_t1#423313, al_taux_t2r#423323, al_taux_t2#423314, al_taux_t3r#423324, al_taux_t3#423315, al_taux_t4r#423325, al_taux_t4#423316, al_taux_t5r#423326, al_taux_t5#423317, al_taux_t6r#423327, al_taux_t6#423318, al_taux_t7r#423328, al_taux_t7#423319, al_taux_t8r#423329, al_taux_t8#423320, al_taux_t9r#423330, al_taux_t9#423321, al_typexa#423302, al_type#423297, al_type_icd#423348, al_t_red#423307, al_urg#423340, al_valcou#423292]

(5) Union

(6) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Keys [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]

(7) Exchange
Input [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Arguments: hashpartitioning(AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26045]

(8) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Arguments: 0

(9) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Arguments: coalesced

(10) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Keys [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Functions: []
Aggregate Attributes: []
Results [1]: [AL_VALCOU_438379#423228 AS COL_AL_VALCOU_438379#424425]

(11) SortAggregate
Input [1]: [COL_AL_VALCOU_438379#424425]
Keys: []
Functions [4]: [partial_count(1), partial_count(COL_AL_VALCOU_438379#424425), partial_min(COL_AL_VALCOU_438379#424425), partial_max(COL_AL_VALCOU_438379#424425)]
Aggregate Attributes [4]: [count#424623L, count#424624L, min#424625, max#424626]
Results [4]: [count#424627L, count#424628L, min#424629, max#424630]

(12) Exchange
Input [4]: [count#424627L, count#424628L, min#424629, max#424630]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26081]

(13) ShuffleQueryStage
Output [4]: [count#424627L, count#424628L, min#424629, max#424630]
Arguments: 1

(14) SortAggregate
Input [4]: [count#424627L, count#424628L, min#424629, max#424630]
Keys: []
Functions [4]: [count(1), count(COL_AL_VALCOU_438379#424425), min(COL_AL_VALCOU_438379#424425), max(COL_AL_VALCOU_438379#424425)]
Aggregate Attributes [4]: [count(1)#424543L, count(COL_AL_VALCOU_438379#424425)#424546L, min(COL_AL_VALCOU_438379#424425)#424549, max(COL_AL_VALCOU_438379#424425)#424551]
Results [4]: [count(1)#424543L AS COL_AL_VALCOU_4383791#424545L, count(COL_AL_VALCOU_438379#424425)#424546L AS COL_AL_VALCOU_4383792#424548L, min(COL_AL_VALCOU_438379#424425)#424549 AS COL_AL_VALCOU_4383794#424550, max(COL_AL_VALCOU_438379#424425)#424551 AS COL_AL_VALCOU_4383795#424552]

(15) Union

(16) HashAggregate
Input [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Keys [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]

(17) Exchange
Input [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Arguments: hashpartitioning(AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26017]

(18) HashAggregate
Input [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Keys [60]: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, AL_NUMCPT_438421#423194, AL_ORDRE_438391#423195, AL_PRIMAI_438433#423196, AL_PRIOR_438383#423197, AL_RCP_438431#423198, AL_REMBOURS_438399#423199, AL_REVERS_438398#423200, AL_SITES_438426#423201, AL_SPL_TRANS_438430#423202, AL_TAUX_438382#423203, AL_TAUX_R_438395#423204, AL_TAUX_T1R_438409#423205, AL_TAUX_T1_438400#423206, AL_TAUX_T2R_438410#423207, AL_TAUX_T2_438401#423208, AL_TAUX_T3R_438411#423209, AL_TAUX_T3_438402#423210, AL_TAUX_T4R_438412#423211, AL_TAUX_T4_438403#423212, AL_TAUX_T5R_438413#423213, AL_TAUX_T5_438404#423214, AL_TAUX_T6R_438414#423215, AL_TAUX_T6_438405#423216, AL_TAUX_T7R_438415#423217, AL_TAUX_T7_438406#423218, AL_TAUX_T8R_438416#423219, AL_TAUX_T8_438407#423220, AL_TAUX_T9R_438417#423221, AL_TAUX_T9_438408#423222, AL_TYPEXA_438389#423223, AL_TYPE_438384#423224, AL_TYPE_ICD_438435#423225, AL_T_RED_438394#423226, AL_URG_438427#423227, AL_VALCOU_438379#423228, ORIGINE_440156#423229]
Functions: []
Aggregate Attributes: []
Results [1]: [AL_VALCOU_438379#423228 AS COL_AL_VALCOU_438379#424425]

(19) SortAggregate
Input [1]: [COL_AL_VALCOU_438379#424425]
Keys: []
Functions [4]: [partial_count(1), partial_count(COL_AL_VALCOU_438379#424425), partial_min(COL_AL_VALCOU_438379#424425), partial_max(COL_AL_VALCOU_438379#424425)]
Aggregate Attributes [4]: [count#424623L, count#424624L, min#424625, max#424626]
Results [4]: [count#424627L, count#424628L, min#424629, max#424630]

(20) Exchange
Input [4]: [count#424627L, count#424628L, min#424629, max#424630]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26021]

(21) SortAggregate
Input [4]: [count#424627L, count#424628L, min#424629, max#424630]
Keys: []
Functions [4]: [count(1), count(COL_AL_VALCOU_438379#424425), min(COL_AL_VALCOU_438379#424425), max(COL_AL_VALCOU_438379#424425)]
Aggregate Attributes [4]: [count(1)#424543L, count(COL_AL_VALCOU_438379#424425)#424546L, min(COL_AL_VALCOU_438379#424425)#424549, max(COL_AL_VALCOU_438379#424425)#424551]
Results [4]: [count(1)#424543L AS COL_AL_VALCOU_4383791#424545L, count(COL_AL_VALCOU_438379#424425)#424546L AS COL_AL_VALCOU_4383792#424548L, min(COL_AL_VALCOU_438379#424425)#424549 AS COL_AL_VALCOU_4383794#424550, max(COL_AL_VALCOU_438379#424425)#424551 AS COL_AL_VALCOU_4383795#424552]

(22) AdaptiveSparkPlan
Output [4]: [COL_AL_VALCOU_4383791#424545L, COL_AL_VALCOU_4383792#424548L, COL_AL_VALCOU_4383794#424550, COL_AL_VALCOU_4383795#424552]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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