hdh-spark-job - Details for Query 1153

Submitted Time: 2026/10/23 11:41:53
Duration: 0.5 s
Succeeded Jobs: 1158 1159 1160

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: 9 ms"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 5 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: 1 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: 124 ms"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 117 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: 106 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)) 7 ms (3 ms, 4 ms, 4 ms (stage 1592.0: task 1420)) 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 1592.0: task 1419)) 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 1592.0: task 1419))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n292 ms (146 ms, 146 ms, 146 ms (stage 1592.0: task 1419))"; 12 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 198 ms (99 ms, 99 ms, 99 ms (stage 1592.0: task 1419)) peak memory total (min, med, max (stageId: taskId)) 129.0 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 1592.0: task 1419)) 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 1592.0: task 1419))"]; } 13 [labelType="html" label=" Union "]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 109 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: 109 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=100, orderBy=[COL_AL_VALCOU_4383792#428355L DESC NULLS LAST], output=[COL_AL_VALCOU_4383791#428292,COL_AL_VALCOU_4383792#428355L])

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_AL_VALCOU_438379#428174, 10), ENSURE_REQUIREMENTS, [plan_id=26336]

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

HashAggregate(keys=[AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26295]

WholeStageCodegen (3)

Union

Project [al_annval#426507 AS AL_ANNVAL_438378#426919, al_classe#426526 AS AL_CLASSE_438397#426920, al_codcha#426553 AS AL_CODCHA_438424#426921, al_codsit#426516 AS AL_CODSIT_438387#426922, al_coduti#426515 AS AL_CODUTI_438386#426923, al_codval#426506 AS AL_CODVAL_438377#426924, al_comment#426551 AS AL_COMMENT_438422#426925, al_datede#426549 AS AL_DATEDE_438420#426926, al_datefi#426561 AS AL_DATEFI_438432#426927, al_datmaj#426514 AS AL_DATMAJ_438385#426928, al_envadm#426522 AS AL_ENVADM_438393#426929, al_flicpt#426548 AS AL_FLICPT_438419#426930, al_flsej#426547 AS AL_FLSEJ_438418#426931, al_fltele#426552 AS AL_FLTELE_438423#426932, al_forfai#426525 AS AL_FORFAI_438396#426933, al_icd#426563 AS AL_ICD_438434#426934, al_int_spe#426558 AS AL_INT_SPE_438429#426935, al_int_std#426557 AS AL_INT_STD_438428#426936, al_letadm#426521 AS AL_LETADM_438392#426937, al_letads#426554 AS AL_LETADS_438425#426938, al_lib30#426509 AS AL_LIB30_438380#426939, al_libmaj#426510 AS AL_LIBMAJ_438381#426940, al_monnaie#426517 AS AL_MONNAIE_438388#426941, al_numbmp#426519 AS AL_NUMBMP_438390#426942, ... 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#426507,al_classe#426526,al_codcha#426553,al_codsit#426516,al_coduti#426515,al_codval#426506,al_comment#426551,al_datede#426549,al_datefi#426561,al_datmaj#426514,al_envadm#426522,al_flicpt#426548,al_flsej#426547,al_fltele#426552,al_forfai#426525,al_icd#426563,al_int_spe#426558,al_int_std#426557,al_letadm#426521,al_letads#426554,al_lib30#426509,al_libmaj#426510,al_monnaie#426517,al_numbmp#426519,... 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#427040 AS AL_ANNVAL_438378#427452, al_classe#427059 AS AL_CLASSE_438397#427453, al_codcha#427086 AS AL_CODCHA_438424#427454, al_codsit#427049 AS AL_CODSIT_438387#427455, al_coduti#427048 AS AL_CODUTI_438386#427456, al_codval#427039 AS AL_CODVAL_438377#427457, al_comment#427084 AS AL_COMMENT_438422#427458, al_datede#427082 AS AL_DATEDE_438420#427459, al_datefi#427094 AS AL_DATEFI_438432#427460, al_datmaj#427047 AS AL_DATMAJ_438385#427461, al_envadm#427055 AS AL_ENVADM_438393#427462, al_flicpt#427081 AS AL_FLICPT_438419#427463, al_flsej#427080 AS AL_FLSEJ_438418#427464, al_fltele#427085 AS AL_FLTELE_438423#427465, al_forfai#427058 AS AL_FORFAI_438396#427466, al_icd#427096 AS AL_ICD_438434#427467, al_int_spe#427091 AS AL_INT_SPE_438429#427468, al_int_std#427090 AS AL_INT_STD_438428#427469, al_letadm#427054 AS AL_LETADM_438392#427470, al_letads#427087 AS AL_LETADS_438425#427471, al_lib30#427042 AS AL_LIB30_438380#427472, al_libmaj#427043 AS AL_LIBMAJ_438381#427473, al_monnaie#427050 AS AL_MONNAIE_438388#427474, al_numbmp#427052 AS AL_NUMBMP_438390#427475, ... 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#427040,al_classe#427059,al_codcha#427086,al_codsit#427049,al_coduti#427048,al_codval#427039,al_comment#427084,al_datede#427082,al_datefi#427094,al_datmaj#427047,al_envadm#427055,al_flicpt#427081,al_flsej#427080,al_fltele#427085,al_forfai#427058,al_icd#427096,al_int_spe#427091,al_int_std#427090,al_letadm#427054,al_letads#427087,al_lib30#427042,al_libmaj#427043,al_monnaie#427050,al_numbmp#427052,... 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#426507, al_classe#426526, al_codcha#426553, al_codsit#426516, al_coduti#426515, al_codval#426506, al_comment#426551, al_datede#426549, al_datefi#426561, al_datmaj#426514, al_envadm#426522, al_flicpt#426548, al_flsej#426547, al_fltele#426552, al_forfai#426525, al_icd#426563, al_int_spe#426558, al_int_std#426557, al_letadm#426521, al_letads#426554, al_lib30#426509, al_libmaj#426510, al_monnaie#426517, al_numbmp#426519, al_numcpt#426550, al_ordre#426520, al_primai#426562, al_prior#426512, al_rcp#426560, al_rembours#426528, al_revers#426527, al_sites#426555, al_spl_trans#426559, al_taux#426511, al_taux_r#426524, al_taux_t1r#426538, al_taux_t1#426529, al_taux_t2r#426539, al_taux_t2#426530, al_taux_t3r#426540, al_taux_t3#426531, al_taux_t4r#426541, al_taux_t4#426532, al_taux_t5r#426542, al_taux_t5#426533, al_taux_t6r#426543, al_taux_t6#426534, al_taux_t7r#426544, al_taux_t7#426535, al_taux_t8r#426545, al_taux_t8#426536, al_taux_t9r#426546, al_taux_t9#426537, al_typexa#426518, al_type#426513, al_type_icd#426564, al_t_red#426523, al_urg#426556, al_valcou#426508]
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#426507 AS AL_ANNVAL_438378#426919, al_classe#426526 AS AL_CLASSE_438397#426920, al_codcha#426553 AS AL_CODCHA_438424#426921, al_codsit#426516 AS AL_CODSIT_438387#426922, al_coduti#426515 AS AL_CODUTI_438386#426923, al_codval#426506 AS AL_CODVAL_438377#426924, al_comment#426551 AS AL_COMMENT_438422#426925, al_datede#426549 AS AL_DATEDE_438420#426926, al_datefi#426561 AS AL_DATEFI_438432#426927, al_datmaj#426514 AS AL_DATMAJ_438385#426928, al_envadm#426522 AS AL_ENVADM_438393#426929, al_flicpt#426548 AS AL_FLICPT_438419#426930, al_flsej#426547 AS AL_FLSEJ_438418#426931, al_fltele#426552 AS AL_FLTELE_438423#426932, al_forfai#426525 AS AL_FORFAI_438396#426933, al_icd#426563 AS AL_ICD_438434#426934, al_int_spe#426558 AS AL_INT_SPE_438429#426935, al_int_std#426557 AS AL_INT_STD_438428#426936, al_letadm#426521 AS AL_LETADM_438392#426937, al_letads#426554 AS AL_LETADS_438425#426938, al_lib30#426509 AS AL_LIB30_438380#426939, al_libmaj#426510 AS AL_LIBMAJ_438381#426940, al_monnaie#426517 AS AL_MONNAIE_438388#426941, al_numbmp#426519 AS AL_NUMBMP_438390#426942, al_numcpt#426550 AS AL_NUMCPT_438421#426943, al_ordre#426520 AS AL_ORDRE_438391#426944, al_primai#426562 AS AL_PRIMAI_438433#426945, al_prior#426512 AS AL_PRIOR_438383#426946, al_rcp#426560 AS AL_RCP_438431#426947, al_rembours#426528 AS AL_REMBOURS_438399#426948, al_revers#426527 AS AL_REVERS_438398#426949, al_sites#426555 AS AL_SITES_438426#426950, al_spl_trans#426559 AS AL_SPL_TRANS_438430#426951, al_taux#426511 AS AL_TAUX_438382#426952, al_taux_r#426524 AS AL_TAUX_R_438395#426953, al_taux_t1r#426538 AS AL_TAUX_T1R_438409#426954, al_taux_t1#426529 AS AL_TAUX_T1_438400#426955, al_taux_t2r#426539 AS AL_TAUX_T2R_438410#426956, al_taux_t2#426530 AS AL_TAUX_T2_438401#426957, al_taux_t3r#426540 AS AL_TAUX_T3R_438411#426958, al_taux_t3#426531 AS AL_TAUX_T3_438402#426959, al_taux_t4r#426541 AS AL_TAUX_T4R_438412#426960, al_taux_t4#426532 AS AL_TAUX_T4_438403#426961, al_taux_t5r#426542 AS AL_TAUX_T5R_438413#426962, al_taux_t5#426533 AS AL_TAUX_T5_438404#426963, al_taux_t6r#426543 AS AL_TAUX_T6R_438414#426964, al_taux_t6#426534 AS AL_TAUX_T6_438405#426965, al_taux_t7r#426544 AS AL_TAUX_T7R_438415#426966, al_taux_t7#426535 AS AL_TAUX_T7_438406#426967, al_taux_t8r#426545 AS AL_TAUX_T8R_438416#426968, al_taux_t8#426536 AS AL_TAUX_T8_438407#426969, al_taux_t9r#426546 AS AL_TAUX_T9R_438417#426970, al_taux_t9#426537 AS AL_TAUX_T9_438408#426971, al_typexa#426518 AS AL_TYPEXA_438389#426972, al_type#426513 AS AL_TYPE_438384#426973, al_type_icd#426564 AS AL_TYPE_ICD_438435#426974, al_t_red#426523 AS AL_T_RED_438394#426975, al_urg#426556 AS AL_URG_438427#426976, al_valcou#426508 AS AL_VALCOU_438379#426977, null AS ORIGINE_440156#426978]
Input [59]: [al_annval#426507, al_classe#426526, al_codcha#426553, al_codsit#426516, al_coduti#426515, al_codval#426506, al_comment#426551, al_datede#426549, al_datefi#426561, al_datmaj#426514, al_envadm#426522, al_flicpt#426548, al_flsej#426547, al_fltele#426552, al_forfai#426525, al_icd#426563, al_int_spe#426558, al_int_std#426557, al_letadm#426521, al_letads#426554, al_lib30#426509, al_libmaj#426510, al_monnaie#426517, al_numbmp#426519, al_numcpt#426550, al_ordre#426520, al_primai#426562, al_prior#426512, al_rcp#426560, al_rembours#426528, al_revers#426527, al_sites#426555, al_spl_trans#426559, al_taux#426511, al_taux_r#426524, al_taux_t1r#426538, al_taux_t1#426529, al_taux_t2r#426539, al_taux_t2#426530, al_taux_t3r#426540, al_taux_t3#426531, al_taux_t4r#426541, al_taux_t4#426532, al_taux_t5r#426542, al_taux_t5#426533, al_taux_t6r#426543, al_taux_t6#426534, al_taux_t7r#426544, al_taux_t7#426535, al_taux_t8r#426545, al_taux_t8#426536, al_taux_t9r#426546, al_taux_t9#426537, al_typexa#426518, al_type#426513, al_type_icd#426564, al_t_red#426523, al_urg#426556, al_valcou#426508]

(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#427040, al_classe#427059, al_codcha#427086, al_codsit#427049, al_coduti#427048, al_codval#427039, al_comment#427084, al_datede#427082, al_datefi#427094, al_datmaj#427047, al_envadm#427055, al_flicpt#427081, al_flsej#427080, al_fltele#427085, al_forfai#427058, al_icd#427096, al_int_spe#427091, al_int_std#427090, al_letadm#427054, al_letads#427087, al_lib30#427042, al_libmaj#427043, al_monnaie#427050, al_numbmp#427052, al_numcpt#427083, al_ordre#427053, al_primai#427095, al_prior#427045, al_rcp#427093, al_rembours#427061, al_revers#427060, al_sites#427088, al_spl_trans#427092, al_taux#427044, al_taux_r#427057, al_taux_t1r#427071, al_taux_t1#427062, al_taux_t2r#427072, al_taux_t2#427063, al_taux_t3r#427073, al_taux_t3#427064, al_taux_t4r#427074, al_taux_t4#427065, al_taux_t5r#427075, al_taux_t5#427066, al_taux_t6r#427076, al_taux_t6#427067, al_taux_t7r#427077, al_taux_t7#427068, al_taux_t8r#427078, al_taux_t8#427069, al_taux_t9r#427079, al_taux_t9#427070, al_typexa#427051, al_type#427046, al_type_icd#427097, al_t_red#427056, al_urg#427089, al_valcou#427041]
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#427040 AS AL_ANNVAL_438378#427452, al_classe#427059 AS AL_CLASSE_438397#427453, al_codcha#427086 AS AL_CODCHA_438424#427454, al_codsit#427049 AS AL_CODSIT_438387#427455, al_coduti#427048 AS AL_CODUTI_438386#427456, al_codval#427039 AS AL_CODVAL_438377#427457, al_comment#427084 AS AL_COMMENT_438422#427458, al_datede#427082 AS AL_DATEDE_438420#427459, al_datefi#427094 AS AL_DATEFI_438432#427460, al_datmaj#427047 AS AL_DATMAJ_438385#427461, al_envadm#427055 AS AL_ENVADM_438393#427462, al_flicpt#427081 AS AL_FLICPT_438419#427463, al_flsej#427080 AS AL_FLSEJ_438418#427464, al_fltele#427085 AS AL_FLTELE_438423#427465, al_forfai#427058 AS AL_FORFAI_438396#427466, al_icd#427096 AS AL_ICD_438434#427467, al_int_spe#427091 AS AL_INT_SPE_438429#427468, al_int_std#427090 AS AL_INT_STD_438428#427469, al_letadm#427054 AS AL_LETADM_438392#427470, al_letads#427087 AS AL_LETADS_438425#427471, al_lib30#427042 AS AL_LIB30_438380#427472, al_libmaj#427043 AS AL_LIBMAJ_438381#427473, al_monnaie#427050 AS AL_MONNAIE_438388#427474, al_numbmp#427052 AS AL_NUMBMP_438390#427475, al_numcpt#427083 AS AL_NUMCPT_438421#427476, al_ordre#427053 AS AL_ORDRE_438391#427477, al_primai#427095 AS AL_PRIMAI_438433#427478, al_prior#427045 AS AL_PRIOR_438383#427479, al_rcp#427093 AS AL_RCP_438431#427480, al_rembours#427061 AS AL_REMBOURS_438399#427481, al_revers#427060 AS AL_REVERS_438398#427482, al_sites#427088 AS AL_SITES_438426#427483, al_spl_trans#427092 AS AL_SPL_TRANS_438430#427484, al_taux#427044 AS AL_TAUX_438382#427485, al_taux_r#427057 AS AL_TAUX_R_438395#427486, al_taux_t1r#427071 AS AL_TAUX_T1R_438409#427487, al_taux_t1#427062 AS AL_TAUX_T1_438400#427488, al_taux_t2r#427072 AS AL_TAUX_T2R_438410#427489, al_taux_t2#427063 AS AL_TAUX_T2_438401#427490, al_taux_t3r#427073 AS AL_TAUX_T3R_438411#427491, al_taux_t3#427064 AS AL_TAUX_T3_438402#427492, al_taux_t4r#427074 AS AL_TAUX_T4R_438412#427493, al_taux_t4#427065 AS AL_TAUX_T4_438403#427494, al_taux_t5r#427075 AS AL_TAUX_T5R_438413#427495, al_taux_t5#427066 AS AL_TAUX_T5_438404#427496, al_taux_t6r#427076 AS AL_TAUX_T6R_438414#427497, al_taux_t6#427067 AS AL_TAUX_T6_438405#427498, al_taux_t7r#427077 AS AL_TAUX_T7R_438415#427499, al_taux_t7#427068 AS AL_TAUX_T7_438406#427500, al_taux_t8r#427078 AS AL_TAUX_T8R_438416#427501, al_taux_t8#427069 AS AL_TAUX_T8_438407#427502, al_taux_t9r#427079 AS AL_TAUX_T9R_438417#427503, al_taux_t9#427070 AS AL_TAUX_T9_438408#427504, al_typexa#427051 AS AL_TYPEXA_438389#427505, al_type#427046 AS AL_TYPE_438384#427506, al_type_icd#427097 AS AL_TYPE_ICD_438435#427507, al_t_red#427056 AS AL_T_RED_438394#427508, al_urg#427089 AS AL_URG_438427#427509, al_valcou#427041 AS AL_VALCOU_438379#427510, null AS ORIGINE_440156#427511]
Input [59]: [al_annval#427040, al_classe#427059, al_codcha#427086, al_codsit#427049, al_coduti#427048, al_codval#427039, al_comment#427084, al_datede#427082, al_datefi#427094, al_datmaj#427047, al_envadm#427055, al_flicpt#427081, al_flsej#427080, al_fltele#427085, al_forfai#427058, al_icd#427096, al_int_spe#427091, al_int_std#427090, al_letadm#427054, al_letads#427087, al_lib30#427042, al_libmaj#427043, al_monnaie#427050, al_numbmp#427052, al_numcpt#427083, al_ordre#427053, al_primai#427095, al_prior#427045, al_rcp#427093, al_rembours#427061, al_revers#427060, al_sites#427088, al_spl_trans#427092, al_taux#427044, al_taux_r#427057, al_taux_t1r#427071, al_taux_t1#427062, al_taux_t2r#427072, al_taux_t2#427063, al_taux_t3r#427073, al_taux_t3#427064, al_taux_t4r#427074, al_taux_t4#427065, al_taux_t5r#427075, al_taux_t5#427066, al_taux_t6r#427076, al_taux_t6#427067, al_taux_t7r#427077, al_taux_t7#427068, al_taux_t8r#427078, al_taux_t8#427069, al_taux_t9r#427079, al_taux_t9#427070, al_typexa#427051, al_type#427046, al_type_icd#427097, al_t_red#427056, al_urg#427089, al_valcou#427041]

(5) Union

(6) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Keys [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]

(7) Exchange
Input [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Arguments: hashpartitioning(AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26295]

(8) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Arguments: 0

(9) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Arguments: coalesced

(10) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Keys [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Functions: []
Aggregate Attributes: []
Results [1]: [AL_VALCOU_438379#426977 AS COL_AL_VALCOU_438379#428174]

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

(12) Exchange
Input [2]: [COL_AL_VALCOU_438379#428174, count#428363L]
Arguments: hashpartitioning(COL_AL_VALCOU_438379#428174, 10), ENSURE_REQUIREMENTS, [plan_id=26336]

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

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

(15) HashAggregate [codegen id : 5]
Input [2]: [COL_AL_VALCOU_438379#428174, count#428363L]
Keys [1]: [COL_AL_VALCOU_438379#428174]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#428353L]
Results [2]: [COL_AL_VALCOU_438379#428174 AS COL_AL_VALCOU_4383791#428292, count(1)#428353L AS COL_AL_VALCOU_4383792#428355L]

(16) TakeOrderedAndProject
Input [2]: [COL_AL_VALCOU_4383791#428292, COL_AL_VALCOU_4383792#428355L]
Arguments: 100, [COL_AL_VALCOU_4383792#428355L DESC NULLS LAST], [COL_AL_VALCOU_4383791#428292, COL_AL_VALCOU_4383792#428355L]

(17) Union

(18) HashAggregate
Input [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Keys [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]

(19) Exchange
Input [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Arguments: hashpartitioning(AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26265]

(20) HashAggregate
Input [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Keys [60]: [AL_ANNVAL_438378#426919, AL_CLASSE_438397#426920, AL_CODCHA_438424#426921, AL_CODSIT_438387#426922, AL_CODUTI_438386#426923, AL_CODVAL_438377#426924, AL_COMMENT_438422#426925, AL_DATEDE_438420#426926, AL_DATEFI_438432#426927, AL_DATMAJ_438385#426928, AL_ENVADM_438393#426929, AL_FLICPT_438419#426930, AL_FLSEJ_438418#426931, AL_FLTELE_438423#426932, AL_FORFAI_438396#426933, AL_ICD_438434#426934, AL_INT_SPE_438429#426935, AL_INT_STD_438428#426936, AL_LETADM_438392#426937, AL_LETADS_438425#426938, AL_LIB30_438380#426939, AL_LIBMAJ_438381#426940, AL_MONNAIE_438388#426941, AL_NUMBMP_438390#426942, AL_NUMCPT_438421#426943, AL_ORDRE_438391#426944, AL_PRIMAI_438433#426945, AL_PRIOR_438383#426946, AL_RCP_438431#426947, AL_REMBOURS_438399#426948, AL_REVERS_438398#426949, AL_SITES_438426#426950, AL_SPL_TRANS_438430#426951, AL_TAUX_438382#426952, AL_TAUX_R_438395#426953, AL_TAUX_T1R_438409#426954, AL_TAUX_T1_438400#426955, AL_TAUX_T2R_438410#426956, AL_TAUX_T2_438401#426957, AL_TAUX_T3R_438411#426958, AL_TAUX_T3_438402#426959, AL_TAUX_T4R_438412#426960, AL_TAUX_T4_438403#426961, AL_TAUX_T5R_438413#426962, AL_TAUX_T5_438404#426963, AL_TAUX_T6R_438414#426964, AL_TAUX_T6_438405#426965, AL_TAUX_T7R_438415#426966, AL_TAUX_T7_438406#426967, AL_TAUX_T8R_438416#426968, AL_TAUX_T8_438407#426969, AL_TAUX_T9R_438417#426970, AL_TAUX_T9_438408#426971, AL_TYPEXA_438389#426972, AL_TYPE_438384#426973, AL_TYPE_ICD_438435#426974, AL_T_RED_438394#426975, AL_URG_438427#426976, AL_VALCOU_438379#426977, ORIGINE_440156#426978]
Functions: []
Aggregate Attributes: []
Results [1]: [AL_VALCOU_438379#426977 AS COL_AL_VALCOU_438379#428174]

(21) HashAggregate
Input [1]: [COL_AL_VALCOU_438379#428174]
Keys [1]: [COL_AL_VALCOU_438379#428174]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#428362L]
Results [2]: [COL_AL_VALCOU_438379#428174, count#428363L]

(22) Exchange
Input [2]: [COL_AL_VALCOU_438379#428174, count#428363L]
Arguments: hashpartitioning(COL_AL_VALCOU_438379#428174, 10), ENSURE_REQUIREMENTS, [plan_id=26269]

(23) HashAggregate
Input [2]: [COL_AL_VALCOU_438379#428174, count#428363L]
Keys [1]: [COL_AL_VALCOU_438379#428174]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#428353L]
Results [2]: [COL_AL_VALCOU_438379#428174 AS COL_AL_VALCOU_4383791#428292, count(1)#428353L AS COL_AL_VALCOU_4383792#428355L]

(24) TakeOrderedAndProject
Input [2]: [COL_AL_VALCOU_4383791#428292, COL_AL_VALCOU_4383792#428355L]
Arguments: 100, [COL_AL_VALCOU_4383792#428355L DESC NULLS LAST], [COL_AL_VALCOU_4383791#428292, COL_AL_VALCOU_4383792#428355L]

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

SQL / DataFrame Properties

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