hdh-spark-job - Details for Query 1150

Submitted Time: 2026/10/23 11:41:37
Duration: 0.7 s
Succeeded Jobs: 1155 1156 1157

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" TakeOrderedAndProject "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 14 ms"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 7 ms peak memory: 64.5 MiB number of output rows: 8,402 number of sort fallback tasks: 0 avg hash probes per key: 1.4"]; } 4 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 81.3 KiB number of coalesced partitions: 1"]; 5 [labelType="html" label="Exchange shuffle records written: 8,402 local merged chunks fetched: 0 shuffle write time: 2 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: 8,402 local bytes read: 77.0 KiB 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: 262.9 KiB 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: 77.0 KiB"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 161 ms"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 143 ms peak memory: 64.2 MiB number of output rows: 8,402 number of sort fallback tasks: 0 avg hash probes per key: 1"]; 8 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 128 ms peak memory: 64.5 MiB number of output rows: 9,179 number of sort fallback tasks: 0 avg hash probes per key: 1.3"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1957.4 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 18,358 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 9 ms (4 ms, 5 ms, 5 ms (stage 1586.0: task 1415)) 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,358 local bytes read: 1860.1 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 1586.0: task 1416)) 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.1 KiB (930.0 KiB, 930.0 KiB, 930.0 KiB (stage 1586.0: task 1416))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n369 ms (184 ms, 185 ms, 185 ms (stage 1586.0: task 1416))"; 12 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 272 ms (136 ms, 136 ms, 136 ms (stage 1586.0: task 1416)) peak memory total (min, med, max (stageId: taskId)) 129.0 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 1586.0: task 1416)) number of output rows: 18,358 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1.4, 1.4, 1.4 (stage 1586.0: task 1416))"]; } 13 [labelType="html" label=" Union "]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 147 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 \"xplore\".\"h_valeu\") as x) [numPartitions=1] number of output rows: 9,179"]; } subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 147 ms"; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="Scan JDBCRelation((SELECT \"al_codval\", \"al_annval\", \"al_valcou\", \"al_lib30\", \"al_libmaj\", \"al_taux\", \"al_prior\", \"al_type\", \"al_datmaj\", \"al_coduti\", \"al_codsit\", \"al_monnaie\", \"al_typexa\", \"al_numbmp\", \"al_ordre\", \"al_letadm\", \"al_envadm\", \"al_t_red\", \"al_taux_r\", \"al_forfai\", \"al_classe\", \"al_revers\", \"al_rembours\", \"al_taux_t1\", \"al_taux_t2\", \"al_taux_t3\", \"al_taux_t4\", \"al_taux_t5\", \"al_taux_t6\", \"al_taux_t7\", \"al_taux_t8\", \"al_taux_t9\", \"al_taux_t1r\", \"al_taux_t2r\", \"al_taux_t3r\", \"al_taux_t4r\", \"al_taux_t5r\", \"al_taux_t6r\", \"al_taux_t7r\", \"al_taux_t8r\", \"al_taux_t9r\", \"al_flsej\", \"al_flicpt\", \"al_datede\", \"al_numcpt\", \"al_comment\", \"al_fltele\", \"al_codcha\", \"al_letads\", \"al_sites\", \"al_urg\", \"al_int_std\", \"al_int_spe\", \"al_spl_trans\", \"al_rcp\", \"al_datefi\", \"al_primai\", \"al_icd\", \"al_type_icd\" FROM \"xplore2\".\"h_valeu\") as x) [numPartitions=1] number of output rows: 9,179"]; } 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; 12->10; 13->12; 15->13; 16->15; 18->13; 19->18; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=10, orderBy=[COL_AL_VALCOU_4383792#426494L DESC NULLS LAST], output=[COL_AL_VALCOU_4383791#426431,COL_AL_VALCOU_4383792#426494L])

HashAggregate(keys=[COL_AL_VALCOU_438379#426313], functions=[count(1)])

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_AL_VALCOU_438379#426313, 10), ENSURE_REQUIREMENTS, [plan_id=26203]

HashAggregate(keys=[COL_AL_VALCOU_438379#426313], functions=[partial_count(1)])

HashAggregate(keys=[AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26162]

WholeStageCodegen (3)

Union

Project [al_annval#424646 AS AL_ANNVAL_438378#425058, al_classe#424665 AS AL_CLASSE_438397#425059, al_codcha#424692 AS AL_CODCHA_438424#425060, al_codsit#424655 AS AL_CODSIT_438387#425061, al_coduti#424654 AS AL_CODUTI_438386#425062, al_codval#424645 AS AL_CODVAL_438377#425063, al_comment#424690 AS AL_COMMENT_438422#425064, al_datede#424688 AS AL_DATEDE_438420#425065, al_datefi#424700 AS AL_DATEFI_438432#425066, al_datmaj#424653 AS AL_DATMAJ_438385#425067, al_envadm#424661 AS AL_ENVADM_438393#425068, al_flicpt#424687 AS AL_FLICPT_438419#425069, al_flsej#424686 AS AL_FLSEJ_438418#425070, al_fltele#424691 AS AL_FLTELE_438423#425071, al_forfai#424664 AS AL_FORFAI_438396#425072, al_icd#424702 AS AL_ICD_438434#425073, al_int_spe#424697 AS AL_INT_SPE_438429#425074, al_int_std#424696 AS AL_INT_STD_438428#425075, al_letadm#424660 AS AL_LETADM_438392#425076, al_letads#424693 AS AL_LETADS_438425#425077, al_lib30#424648 AS AL_LIB30_438380#425078, al_libmaj#424649 AS AL_LIBMAJ_438381#425079, al_monnaie#424656 AS AL_MONNAIE_438388#425080, al_numbmp#424658 AS AL_NUMBMP_438390#425081, ... 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#424646,al_classe#424665,al_codcha#424692,al_codsit#424655,al_coduti#424654,al_codval#424645,al_comment#424690,al_datede#424688,al_datefi#424700,al_datmaj#424653,al_envadm#424661,al_flicpt#424687,al_flsej#424686,al_fltele#424691,al_forfai#424664,al_icd#424702,al_int_spe#424697,al_int_std#424696,al_letadm#424660,al_letads#424693,al_lib30#424648,al_libmaj#424649,al_monnaie#424656,al_numbmp#424658,... 35 more fields] PushedFilters: [*IsNotNull(al_valcou)], ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_co...

WholeStageCodegen (1)

Project [al_annval#425179 AS AL_ANNVAL_438378#425591, al_classe#425198 AS AL_CLASSE_438397#425592, al_codcha#425225 AS AL_CODCHA_438424#425593, al_codsit#425188 AS AL_CODSIT_438387#425594, al_coduti#425187 AS AL_CODUTI_438386#425595, al_codval#425178 AS AL_CODVAL_438377#425596, al_comment#425223 AS AL_COMMENT_438422#425597, al_datede#425221 AS AL_DATEDE_438420#425598, al_datefi#425233 AS AL_DATEFI_438432#425599, al_datmaj#425186 AS AL_DATMAJ_438385#425600, al_envadm#425194 AS AL_ENVADM_438393#425601, al_flicpt#425220 AS AL_FLICPT_438419#425602, al_flsej#425219 AS AL_FLSEJ_438418#425603, al_fltele#425224 AS AL_FLTELE_438423#425604, al_forfai#425197 AS AL_FORFAI_438396#425605, al_icd#425235 AS AL_ICD_438434#425606, al_int_spe#425230 AS AL_INT_SPE_438429#425607, al_int_std#425229 AS AL_INT_STD_438428#425608, al_letadm#425193 AS AL_LETADM_438392#425609, al_letads#425226 AS AL_LETADS_438425#425610, al_lib30#425181 AS AL_LIB30_438380#425611, al_libmaj#425182 AS AL_LIBMAJ_438381#425612, al_monnaie#425189 AS AL_MONNAIE_438388#425613, al_numbmp#425191 AS AL_NUMBMP_438390#425614, ... 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#425179,al_classe#425198,al_codcha#425225,al_codsit#425188,al_coduti#425187,al_codval#425178,al_comment#425223,al_datede#425221,al_datefi#425233,al_datmaj#425186,al_envadm#425194,al_flicpt#425220,al_flsej#425219,al_fltele#425224,al_forfai#425197,al_icd#425235,al_int_spe#425230,al_int_std#425229,al_letadm#425193,al_letads#425226,al_lib30#425181,al_libmaj#425182,al_monnaie#425189,al_numbmp#425191,... 35 more fields] PushedFilters: [*IsNotNull(al_valcou)], 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 (25)
+- == Final Plan ==
   TakeOrderedAndProject (16)
   +- * HashAggregate (15)
      +- AQEShuffleRead (14)
         +- ShuffleQueryStage (13), Statistics(sizeInBytes=262.9 KiB, rowCount=8.40E+3)
            +- 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 ==
   TakeOrderedAndProject (24)
   +- HashAggregate (23)
      +- Exchange (22)
         +- HashAggregate (21)
            +- HashAggregate (20)
               +- Exchange (19)
                  +- HashAggregate (18)
                     +- Union (17)
                        :- 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#424646, al_classe#424665, al_codcha#424692, al_codsit#424655, al_coduti#424654, al_codval#424645, al_comment#424690, al_datede#424688, al_datefi#424700, al_datmaj#424653, al_envadm#424661, al_flicpt#424687, al_flsej#424686, al_fltele#424691, al_forfai#424664, al_icd#424702, al_int_spe#424697, al_int_std#424696, al_letadm#424660, al_letads#424693, al_lib30#424648, al_libmaj#424649, al_monnaie#424656, al_numbmp#424658, al_numcpt#424689, al_ordre#424659, al_primai#424701, al_prior#424651, al_rcp#424699, al_rembours#424667, al_revers#424666, al_sites#424694, al_spl_trans#424698, al_taux#424650, al_taux_r#424663, al_taux_t1r#424677, al_taux_t1#424668, al_taux_t2r#424678, al_taux_t2#424669, al_taux_t3r#424679, al_taux_t3#424670, al_taux_t4r#424680, al_taux_t4#424671, al_taux_t5r#424681, al_taux_t5#424672, al_taux_t6r#424682, al_taux_t6#424673, al_taux_t7r#424683, al_taux_t7#424674, al_taux_t8r#424684, al_taux_t8#424675, al_taux_t9r#424685, al_taux_t9#424676, al_typexa#424657, al_type#424652, al_type_icd#424703, al_t_red#424662, al_urg#424695, al_valcou#424647]
PushedFilters: [*IsNotNull(al_valcou)]
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#424646 AS AL_ANNVAL_438378#425058, al_classe#424665 AS AL_CLASSE_438397#425059, al_codcha#424692 AS AL_CODCHA_438424#425060, al_codsit#424655 AS AL_CODSIT_438387#425061, al_coduti#424654 AS AL_CODUTI_438386#425062, al_codval#424645 AS AL_CODVAL_438377#425063, al_comment#424690 AS AL_COMMENT_438422#425064, al_datede#424688 AS AL_DATEDE_438420#425065, al_datefi#424700 AS AL_DATEFI_438432#425066, al_datmaj#424653 AS AL_DATMAJ_438385#425067, al_envadm#424661 AS AL_ENVADM_438393#425068, al_flicpt#424687 AS AL_FLICPT_438419#425069, al_flsej#424686 AS AL_FLSEJ_438418#425070, al_fltele#424691 AS AL_FLTELE_438423#425071, al_forfai#424664 AS AL_FORFAI_438396#425072, al_icd#424702 AS AL_ICD_438434#425073, al_int_spe#424697 AS AL_INT_SPE_438429#425074, al_int_std#424696 AS AL_INT_STD_438428#425075, al_letadm#424660 AS AL_LETADM_438392#425076, al_letads#424693 AS AL_LETADS_438425#425077, al_lib30#424648 AS AL_LIB30_438380#425078, al_libmaj#424649 AS AL_LIBMAJ_438381#425079, al_monnaie#424656 AS AL_MONNAIE_438388#425080, al_numbmp#424658 AS AL_NUMBMP_438390#425081, al_numcpt#424689 AS AL_NUMCPT_438421#425082, al_ordre#424659 AS AL_ORDRE_438391#425083, al_primai#424701 AS AL_PRIMAI_438433#425084, al_prior#424651 AS AL_PRIOR_438383#425085, al_rcp#424699 AS AL_RCP_438431#425086, al_rembours#424667 AS AL_REMBOURS_438399#425087, al_revers#424666 AS AL_REVERS_438398#425088, al_sites#424694 AS AL_SITES_438426#425089, al_spl_trans#424698 AS AL_SPL_TRANS_438430#425090, al_taux#424650 AS AL_TAUX_438382#425091, al_taux_r#424663 AS AL_TAUX_R_438395#425092, al_taux_t1r#424677 AS AL_TAUX_T1R_438409#425093, al_taux_t1#424668 AS AL_TAUX_T1_438400#425094, al_taux_t2r#424678 AS AL_TAUX_T2R_438410#425095, al_taux_t2#424669 AS AL_TAUX_T2_438401#425096, al_taux_t3r#424679 AS AL_TAUX_T3R_438411#425097, al_taux_t3#424670 AS AL_TAUX_T3_438402#425098, al_taux_t4r#424680 AS AL_TAUX_T4R_438412#425099, al_taux_t4#424671 AS AL_TAUX_T4_438403#425100, al_taux_t5r#424681 AS AL_TAUX_T5R_438413#425101, al_taux_t5#424672 AS AL_TAUX_T5_438404#425102, al_taux_t6r#424682 AS AL_TAUX_T6R_438414#425103, al_taux_t6#424673 AS AL_TAUX_T6_438405#425104, al_taux_t7r#424683 AS AL_TAUX_T7R_438415#425105, al_taux_t7#424674 AS AL_TAUX_T7_438406#425106, al_taux_t8r#424684 AS AL_TAUX_T8R_438416#425107, al_taux_t8#424675 AS AL_TAUX_T8_438407#425108, al_taux_t9r#424685 AS AL_TAUX_T9R_438417#425109, al_taux_t9#424676 AS AL_TAUX_T9_438408#425110, al_typexa#424657 AS AL_TYPEXA_438389#425111, al_type#424652 AS AL_TYPE_438384#425112, al_type_icd#424703 AS AL_TYPE_ICD_438435#425113, al_t_red#424662 AS AL_T_RED_438394#425114, al_urg#424695 AS AL_URG_438427#425115, al_valcou#424647 AS AL_VALCOU_438379#425116, null AS ORIGINE_440156#425117]
Input [59]: [al_annval#424646, al_classe#424665, al_codcha#424692, al_codsit#424655, al_coduti#424654, al_codval#424645, al_comment#424690, al_datede#424688, al_datefi#424700, al_datmaj#424653, al_envadm#424661, al_flicpt#424687, al_flsej#424686, al_fltele#424691, al_forfai#424664, al_icd#424702, al_int_spe#424697, al_int_std#424696, al_letadm#424660, al_letads#424693, al_lib30#424648, al_libmaj#424649, al_monnaie#424656, al_numbmp#424658, al_numcpt#424689, al_ordre#424659, al_primai#424701, al_prior#424651, al_rcp#424699, al_rembours#424667, al_revers#424666, al_sites#424694, al_spl_trans#424698, al_taux#424650, al_taux_r#424663, al_taux_t1r#424677, al_taux_t1#424668, al_taux_t2r#424678, al_taux_t2#424669, al_taux_t3r#424679, al_taux_t3#424670, al_taux_t4r#424680, al_taux_t4#424671, al_taux_t5r#424681, al_taux_t5#424672, al_taux_t6r#424682, al_taux_t6#424673, al_taux_t7r#424683, al_taux_t7#424674, al_taux_t8r#424684, al_taux_t8#424675, al_taux_t9r#424685, al_taux_t9#424676, al_typexa#424657, al_type#424652, al_type_icd#424703, al_t_red#424662, al_urg#424695, al_valcou#424647]

(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#425179, al_classe#425198, al_codcha#425225, al_codsit#425188, al_coduti#425187, al_codval#425178, al_comment#425223, al_datede#425221, al_datefi#425233, al_datmaj#425186, al_envadm#425194, al_flicpt#425220, al_flsej#425219, al_fltele#425224, al_forfai#425197, al_icd#425235, al_int_spe#425230, al_int_std#425229, al_letadm#425193, al_letads#425226, al_lib30#425181, al_libmaj#425182, al_monnaie#425189, al_numbmp#425191, al_numcpt#425222, al_ordre#425192, al_primai#425234, al_prior#425184, al_rcp#425232, al_rembours#425200, al_revers#425199, al_sites#425227, al_spl_trans#425231, al_taux#425183, al_taux_r#425196, al_taux_t1r#425210, al_taux_t1#425201, al_taux_t2r#425211, al_taux_t2#425202, al_taux_t3r#425212, al_taux_t3#425203, al_taux_t4r#425213, al_taux_t4#425204, al_taux_t5r#425214, al_taux_t5#425205, al_taux_t6r#425215, al_taux_t6#425206, al_taux_t7r#425216, al_taux_t7#425207, al_taux_t8r#425217, al_taux_t8#425208, al_taux_t9r#425218, al_taux_t9#425209, al_typexa#425190, al_type#425185, al_type_icd#425236, al_t_red#425195, al_urg#425228, al_valcou#425180]
PushedFilters: [*IsNotNull(al_valcou)]
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#425179 AS AL_ANNVAL_438378#425591, al_classe#425198 AS AL_CLASSE_438397#425592, al_codcha#425225 AS AL_CODCHA_438424#425593, al_codsit#425188 AS AL_CODSIT_438387#425594, al_coduti#425187 AS AL_CODUTI_438386#425595, al_codval#425178 AS AL_CODVAL_438377#425596, al_comment#425223 AS AL_COMMENT_438422#425597, al_datede#425221 AS AL_DATEDE_438420#425598, al_datefi#425233 AS AL_DATEFI_438432#425599, al_datmaj#425186 AS AL_DATMAJ_438385#425600, al_envadm#425194 AS AL_ENVADM_438393#425601, al_flicpt#425220 AS AL_FLICPT_438419#425602, al_flsej#425219 AS AL_FLSEJ_438418#425603, al_fltele#425224 AS AL_FLTELE_438423#425604, al_forfai#425197 AS AL_FORFAI_438396#425605, al_icd#425235 AS AL_ICD_438434#425606, al_int_spe#425230 AS AL_INT_SPE_438429#425607, al_int_std#425229 AS AL_INT_STD_438428#425608, al_letadm#425193 AS AL_LETADM_438392#425609, al_letads#425226 AS AL_LETADS_438425#425610, al_lib30#425181 AS AL_LIB30_438380#425611, al_libmaj#425182 AS AL_LIBMAJ_438381#425612, al_monnaie#425189 AS AL_MONNAIE_438388#425613, al_numbmp#425191 AS AL_NUMBMP_438390#425614, al_numcpt#425222 AS AL_NUMCPT_438421#425615, al_ordre#425192 AS AL_ORDRE_438391#425616, al_primai#425234 AS AL_PRIMAI_438433#425617, al_prior#425184 AS AL_PRIOR_438383#425618, al_rcp#425232 AS AL_RCP_438431#425619, al_rembours#425200 AS AL_REMBOURS_438399#425620, al_revers#425199 AS AL_REVERS_438398#425621, al_sites#425227 AS AL_SITES_438426#425622, al_spl_trans#425231 AS AL_SPL_TRANS_438430#425623, al_taux#425183 AS AL_TAUX_438382#425624, al_taux_r#425196 AS AL_TAUX_R_438395#425625, al_taux_t1r#425210 AS AL_TAUX_T1R_438409#425626, al_taux_t1#425201 AS AL_TAUX_T1_438400#425627, al_taux_t2r#425211 AS AL_TAUX_T2R_438410#425628, al_taux_t2#425202 AS AL_TAUX_T2_438401#425629, al_taux_t3r#425212 AS AL_TAUX_T3R_438411#425630, al_taux_t3#425203 AS AL_TAUX_T3_438402#425631, al_taux_t4r#425213 AS AL_TAUX_T4R_438412#425632, al_taux_t4#425204 AS AL_TAUX_T4_438403#425633, al_taux_t5r#425214 AS AL_TAUX_T5R_438413#425634, al_taux_t5#425205 AS AL_TAUX_T5_438404#425635, al_taux_t6r#425215 AS AL_TAUX_T6R_438414#425636, al_taux_t6#425206 AS AL_TAUX_T6_438405#425637, al_taux_t7r#425216 AS AL_TAUX_T7R_438415#425638, al_taux_t7#425207 AS AL_TAUX_T7_438406#425639, al_taux_t8r#425217 AS AL_TAUX_T8R_438416#425640, al_taux_t8#425208 AS AL_TAUX_T8_438407#425641, al_taux_t9r#425218 AS AL_TAUX_T9R_438417#425642, al_taux_t9#425209 AS AL_TAUX_T9_438408#425643, al_typexa#425190 AS AL_TYPEXA_438389#425644, al_type#425185 AS AL_TYPE_438384#425645, al_type_icd#425236 AS AL_TYPE_ICD_438435#425646, al_t_red#425195 AS AL_T_RED_438394#425647, al_urg#425228 AS AL_URG_438427#425648, al_valcou#425180 AS AL_VALCOU_438379#425649, null AS ORIGINE_440156#425650]
Input [59]: [al_annval#425179, al_classe#425198, al_codcha#425225, al_codsit#425188, al_coduti#425187, al_codval#425178, al_comment#425223, al_datede#425221, al_datefi#425233, al_datmaj#425186, al_envadm#425194, al_flicpt#425220, al_flsej#425219, al_fltele#425224, al_forfai#425197, al_icd#425235, al_int_spe#425230, al_int_std#425229, al_letadm#425193, al_letads#425226, al_lib30#425181, al_libmaj#425182, al_monnaie#425189, al_numbmp#425191, al_numcpt#425222, al_ordre#425192, al_primai#425234, al_prior#425184, al_rcp#425232, al_rembours#425200, al_revers#425199, al_sites#425227, al_spl_trans#425231, al_taux#425183, al_taux_r#425196, al_taux_t1r#425210, al_taux_t1#425201, al_taux_t2r#425211, al_taux_t2#425202, al_taux_t3r#425212, al_taux_t3#425203, al_taux_t4r#425213, al_taux_t4#425204, al_taux_t5r#425214, al_taux_t5#425205, al_taux_t6r#425215, al_taux_t6#425206, al_taux_t7r#425216, al_taux_t7#425207, al_taux_t8r#425217, al_taux_t8#425208, al_taux_t9r#425218, al_taux_t9#425209, al_typexa#425190, al_type#425185, al_type_icd#425236, al_t_red#425195, al_urg#425228, al_valcou#425180]

(5) Union

(6) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Keys [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]

(7) Exchange
Input [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Arguments: hashpartitioning(AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26162]

(8) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Arguments: 0

(9) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Arguments: coalesced

(10) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Keys [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Functions: []
Aggregate Attributes: []
Results [1]: [AL_VALCOU_438379#425116 AS COL_AL_VALCOU_438379#426313]

(11) HashAggregate [codegen id : 4]
Input [1]: [COL_AL_VALCOU_438379#426313]
Keys [1]: [COL_AL_VALCOU_438379#426313]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#426501L]
Results [2]: [COL_AL_VALCOU_438379#426313, count#426502L]

(12) Exchange
Input [2]: [COL_AL_VALCOU_438379#426313, count#426502L]
Arguments: hashpartitioning(COL_AL_VALCOU_438379#426313, 10), ENSURE_REQUIREMENTS, [plan_id=26203]

(13) ShuffleQueryStage
Output [2]: [COL_AL_VALCOU_438379#426313, count#426502L]
Arguments: 1

(14) AQEShuffleRead
Input [2]: [COL_AL_VALCOU_438379#426313, count#426502L]
Arguments: coalesced

(15) HashAggregate [codegen id : 5]
Input [2]: [COL_AL_VALCOU_438379#426313, count#426502L]
Keys [1]: [COL_AL_VALCOU_438379#426313]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#426492L]
Results [2]: [COL_AL_VALCOU_438379#426313 AS COL_AL_VALCOU_4383791#426431, count(1)#426492L AS COL_AL_VALCOU_4383792#426494L]

(16) TakeOrderedAndProject
Input [2]: [COL_AL_VALCOU_4383791#426431, COL_AL_VALCOU_4383792#426494L]
Arguments: 10, [COL_AL_VALCOU_4383792#426494L DESC NULLS LAST], [COL_AL_VALCOU_4383791#426431, COL_AL_VALCOU_4383792#426494L]

(17) Union

(18) HashAggregate
Input [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Keys [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]

(19) Exchange
Input [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Arguments: hashpartitioning(AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26132]

(20) HashAggregate
Input [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Keys [60]: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, AL_NUMCPT_438421#425082, AL_ORDRE_438391#425083, AL_PRIMAI_438433#425084, AL_PRIOR_438383#425085, AL_RCP_438431#425086, AL_REMBOURS_438399#425087, AL_REVERS_438398#425088, AL_SITES_438426#425089, AL_SPL_TRANS_438430#425090, AL_TAUX_438382#425091, AL_TAUX_R_438395#425092, AL_TAUX_T1R_438409#425093, AL_TAUX_T1_438400#425094, AL_TAUX_T2R_438410#425095, AL_TAUX_T2_438401#425096, AL_TAUX_T3R_438411#425097, AL_TAUX_T3_438402#425098, AL_TAUX_T4R_438412#425099, AL_TAUX_T4_438403#425100, AL_TAUX_T5R_438413#425101, AL_TAUX_T5_438404#425102, AL_TAUX_T6R_438414#425103, AL_TAUX_T6_438405#425104, AL_TAUX_T7R_438415#425105, AL_TAUX_T7_438406#425106, AL_TAUX_T8R_438416#425107, AL_TAUX_T8_438407#425108, AL_TAUX_T9R_438417#425109, AL_TAUX_T9_438408#425110, AL_TYPEXA_438389#425111, AL_TYPE_438384#425112, AL_TYPE_ICD_438435#425113, AL_T_RED_438394#425114, AL_URG_438427#425115, AL_VALCOU_438379#425116, ORIGINE_440156#425117]
Functions: []
Aggregate Attributes: []
Results [1]: [AL_VALCOU_438379#425116 AS COL_AL_VALCOU_438379#426313]

(21) HashAggregate
Input [1]: [COL_AL_VALCOU_438379#426313]
Keys [1]: [COL_AL_VALCOU_438379#426313]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#426501L]
Results [2]: [COL_AL_VALCOU_438379#426313, count#426502L]

(22) Exchange
Input [2]: [COL_AL_VALCOU_438379#426313, count#426502L]
Arguments: hashpartitioning(COL_AL_VALCOU_438379#426313, 10), ENSURE_REQUIREMENTS, [plan_id=26136]

(23) HashAggregate
Input [2]: [COL_AL_VALCOU_438379#426313, count#426502L]
Keys [1]: [COL_AL_VALCOU_438379#426313]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#426492L]
Results [2]: [COL_AL_VALCOU_438379#426313 AS COL_AL_VALCOU_4383791#426431, count(1)#426492L AS COL_AL_VALCOU_4383792#426494L]

(24) TakeOrderedAndProject
Input [2]: [COL_AL_VALCOU_4383791#426431, COL_AL_VALCOU_4383792#426494L]
Arguments: 10, [COL_AL_VALCOU_4383792#426494L DESC NULLS LAST], [COL_AL_VALCOU_4383791#426431, COL_AL_VALCOU_4383792#426494L]

(25) AdaptiveSparkPlan
Output [2]: [COL_AL_VALCOU_4383791#426431, COL_AL_VALCOU_4383792#426494L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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