hdh-spark-job - Details for Query 1160

Submitted Time: 2026/10/23 11:53:25
Duration: 0.4 s
Succeeded Jobs: 1164 1165 1166

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 113 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 113 ms peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 105 ms peak memory: 64.5 MiB number of output rows: 9,180 number of sort fallback tasks: 0 avg hash probes per key: 1.3"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1957.4 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 18,360 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 7 ms (3 ms, 3 ms, 3 ms (stage 1602.0: task 1427)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 18,360 local bytes read: 1860.5 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 14.5 MiB (7.3 MiB, 7.3 MiB, 7.3 MiB (stage 1602.0: task 1427)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 1860.5 KiB (930.3 KiB, 930.3 KiB, 930.3 KiB (stage 1602.0: task 1427))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n250 ms (124 ms, 126 ms, 126 ms (stage 1602.0: task 1428))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 148 ms (73 ms, 75 ms, 75 ms (stage 1602.0: task 1427)) peak memory total (min, med, max (stageId: taskId)) 129.0 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 1602.0: task 1427)) number of output rows: 18,360 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1.4, 1.4, 1.4 (stage 1602.0: task 1427))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 87 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Scan JDBCRelation((SELECT \"al_codval\", \"al_annval\", \"al_valcou\", \"al_lib30\", \"al_libmaj\", \"al_taux\", \"al_prior\", \"al_type\", \"al_datmaj\", \"al_coduti\", \"al_codsit\", \"al_monnaie\", \"al_typexa\", \"al_numbmp\", \"al_ordre\", \"al_letadm\", \"al_envadm\", \"al_t_red\", \"al_taux_r\", \"al_forfai\", \"al_classe\", \"al_revers\", \"al_rembours\", \"al_taux_t1\", \"al_taux_t2\", \"al_taux_t3\", \"al_taux_t4\", \"al_taux_t5\", \"al_taux_t6\", \"al_taux_t7\", \"al_taux_t8\", \"al_taux_t9\", \"al_taux_t1r\", \"al_taux_t2r\", \"al_taux_t3r\", \"al_taux_t4r\", \"al_taux_t5r\", \"al_taux_t6r\", \"al_taux_t7r\", \"al_taux_t8r\", \"al_taux_t9r\", \"al_flsej\", \"al_flicpt\", \"al_datede\", \"al_numcpt\", \"al_comment\", \"al_fltele\", \"al_codcha\", \"al_letads\", \"al_sites\", \"al_urg\", \"al_int_std\", \"al_int_spe\", \"al_spl_trans\", \"al_rcp\", \"al_datefi\", \"al_primai\", \"al_icd\", \"al_type_icd\" FROM \"xplore\".\"h_valeu\") as x) [numPartitions=1] number of output rows: 9,180"]; } subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 88 ms"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="Scan JDBCRelation((SELECT \"al_codval\", \"al_annval\", \"al_valcou\", \"al_lib30\", \"al_libmaj\", \"al_taux\", \"al_prior\", \"al_type\", \"al_datmaj\", \"al_coduti\", \"al_codsit\", \"al_monnaie\", \"al_typexa\", \"al_numbmp\", \"al_ordre\", \"al_letadm\", \"al_envadm\", \"al_t_red\", \"al_taux_r\", \"al_forfai\", \"al_classe\", \"al_revers\", \"al_rembours\", \"al_taux_t1\", \"al_taux_t2\", \"al_taux_t3\", \"al_taux_t4\", \"al_taux_t5\", \"al_taux_t6\", \"al_taux_t7\", \"al_taux_t8\", \"al_taux_t9\", \"al_taux_t1r\", \"al_taux_t2r\", \"al_taux_t3r\", \"al_taux_t4r\", \"al_taux_t5r\", \"al_taux_t6r\", \"al_taux_t7r\", \"al_taux_t8r\", \"al_taux_t9r\", \"al_flsej\", \"al_flicpt\", \"al_datede\", \"al_numcpt\", \"al_comment\", \"al_fltele\", \"al_codcha\", \"al_letads\", \"al_sites\", \"al_urg\", \"al_int_std\", \"al_int_spe\", \"al_spl_trans\", \"al_rcp\", \"al_datefi\", \"al_primai\", \"al_icd\", \"al_type_icd\" FROM \"xplore2\".\"h_valeu\") as x) [numPartitions=1] number of output rows: 9,180"]; } 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 10->8; 11->10; 13->11; 14->13; 16->11; 17->16; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (5)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=26543]

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

HashAggregate(keys=[AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, ... 36 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26507]

WholeStageCodegen (3)

Union

Project [al_annval#434146 AS AL_ANNVAL_438378#434558, al_classe#434165 AS AL_CLASSE_438397#434559, al_codcha#434192 AS AL_CODCHA_438424#434560, al_codsit#434155 AS AL_CODSIT_438387#434561, al_coduti#434154 AS AL_CODUTI_438386#434562, al_codval#434145 AS AL_CODVAL_438377#434563, al_comment#434190 AS AL_COMMENT_438422#434564, al_datede#434188 AS AL_DATEDE_438420#434565, al_datefi#434200 AS AL_DATEFI_438432#434566, al_datmaj#434153 AS AL_DATMAJ_438385#434567, al_envadm#434161 AS AL_ENVADM_438393#434568, al_flicpt#434187 AS AL_FLICPT_438419#434569, al_flsej#434186 AS AL_FLSEJ_438418#434570, al_fltele#434191 AS AL_FLTELE_438423#434571, al_forfai#434164 AS AL_FORFAI_438396#434572, al_icd#434202 AS AL_ICD_438434#434573, al_int_spe#434197 AS AL_INT_SPE_438429#434574, al_int_std#434196 AS AL_INT_STD_438428#434575, al_letadm#434160 AS AL_LETADM_438392#434576, al_letads#434193 AS AL_LETADS_438425#434577, al_lib30#434148 AS AL_LIB30_438380#434578, al_libmaj#434149 AS AL_LIBMAJ_438381#434579, al_monnaie#434156 AS AL_MONNAIE_438388#434580, al_numbmp#434158 AS AL_NUMBMP_438390#434581, ... 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#434146,al_classe#434165,al_codcha#434192,al_codsit#434155,al_coduti#434154,al_codval#434145,al_comment#434190,al_datede#434188,al_datefi#434200,al_datmaj#434153,al_envadm#434161,al_flicpt#434187,al_flsej#434186,al_fltele#434191,al_forfai#434164,al_icd#434202,al_int_spe#434197,al_int_std#434196,al_letadm#434160,al_letads#434193,al_lib30#434148,al_libmaj#434149,al_monnaie#434156,al_numbmp#434158,... 35 more fields] PushedFilters: [], ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_co...

WholeStageCodegen (1)

Project [al_annval#434679 AS AL_ANNVAL_438378#435091, al_classe#434698 AS AL_CLASSE_438397#435092, al_codcha#434725 AS AL_CODCHA_438424#435093, al_codsit#434688 AS AL_CODSIT_438387#435094, al_coduti#434687 AS AL_CODUTI_438386#435095, al_codval#434678 AS AL_CODVAL_438377#435096, al_comment#434723 AS AL_COMMENT_438422#435097, al_datede#434721 AS AL_DATEDE_438420#435098, al_datefi#434733 AS AL_DATEFI_438432#435099, al_datmaj#434686 AS AL_DATMAJ_438385#435100, al_envadm#434694 AS AL_ENVADM_438393#435101, al_flicpt#434720 AS AL_FLICPT_438419#435102, al_flsej#434719 AS AL_FLSEJ_438418#435103, al_fltele#434724 AS AL_FLTELE_438423#435104, al_forfai#434697 AS AL_FORFAI_438396#435105, al_icd#434735 AS AL_ICD_438434#435106, al_int_spe#434730 AS AL_INT_SPE_438429#435107, al_int_std#434729 AS AL_INT_STD_438428#435108, al_letadm#434693 AS AL_LETADM_438392#435109, al_letads#434726 AS AL_LETADS_438425#435110, al_lib30#434681 AS AL_LIB30_438380#435111, al_libmaj#434682 AS AL_LIBMAJ_438381#435112, al_monnaie#434689 AS AL_MONNAIE_438388#435113, al_numbmp#434691 AS AL_NUMBMP_438390#435114, ... 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#434679,al_classe#434698,al_codcha#434725,al_codsit#434688,al_coduti#434687,al_codval#434678,al_comment#434723,al_datede#434721,al_datefi#434733,al_datmaj#434686,al_envadm#434694,al_flicpt#434720,al_flsej#434719,al_fltele#434724,al_forfai#434697,al_icd#434735,al_int_spe#434730,al_int_std#434729,al_letadm#434693,al_letads#434726,al_lib30#434681,al_libmaj#434682,al_monnaie#434689,al_numbmp#434691,... 35 more fields] PushedFilters: [], ReadSchema: struct<al_annval:string,al_classe:string,al_codcha:string,al_codsit:string,al_coduti:string,al_co...

WholeStageCodegen (2)

Details

== Physical Plan ==
AdaptiveSparkPlan (22)
+- == Final Plan ==
   * HashAggregate (14)
   +- ShuffleQueryStage (13), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (12)
         +- * HashAggregate (11)
            +- * HashAggregate (10)
               +- AQEShuffleRead (9)
                  +- ShuffleQueryStage (8), Statistics(sizeInBytes=14.5 MiB, rowCount=1.84E+4)
                     +- Exchange (7)
                        +- * HashAggregate (6)
                           +- Union (5)
                              :- * Project (2)
                              :  +- * Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  (1)
                              +- * Project (4)
                                 +- * Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  (3)
+- == Initial Plan ==
   HashAggregate (21)
   +- Exchange (20)
      +- HashAggregate (19)
         +- HashAggregate (18)
            +- Exchange (17)
               +- HashAggregate (16)
                  +- Union (15)
                     :- Project (2)
                     :  +- Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  (1)
                     +- Project (4)
                        +- Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1]  (3)


(1) Scan JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1]  [codegen id : 1]
Output [59]: [al_annval#434146, al_classe#434165, al_codcha#434192, al_codsit#434155, al_coduti#434154, al_codval#434145, al_comment#434190, al_datede#434188, al_datefi#434200, al_datmaj#434153, al_envadm#434161, al_flicpt#434187, al_flsej#434186, al_fltele#434191, al_forfai#434164, al_icd#434202, al_int_spe#434197, al_int_std#434196, al_letadm#434160, al_letads#434193, al_lib30#434148, al_libmaj#434149, al_monnaie#434156, al_numbmp#434158, al_numcpt#434189, al_ordre#434159, al_primai#434201, al_prior#434151, al_rcp#434199, al_rembours#434167, al_revers#434166, al_sites#434194, al_spl_trans#434198, al_taux#434150, al_taux_r#434163, al_taux_t1r#434177, al_taux_t1#434168, al_taux_t2r#434178, al_taux_t2#434169, al_taux_t3r#434179, al_taux_t3#434170, al_taux_t4r#434180, al_taux_t4#434171, al_taux_t5r#434181, al_taux_t5#434172, al_taux_t6r#434182, al_taux_t6#434173, al_taux_t7r#434183, al_taux_t7#434174, al_taux_t8r#434184, al_taux_t8#434175, al_taux_t9r#434185, al_taux_t9#434176, al_typexa#434157, al_type#434152, al_type_icd#434203, al_t_red#434162, al_urg#434195, al_valcou#434147]
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#434146 AS AL_ANNVAL_438378#434558, al_classe#434165 AS AL_CLASSE_438397#434559, al_codcha#434192 AS AL_CODCHA_438424#434560, al_codsit#434155 AS AL_CODSIT_438387#434561, al_coduti#434154 AS AL_CODUTI_438386#434562, al_codval#434145 AS AL_CODVAL_438377#434563, al_comment#434190 AS AL_COMMENT_438422#434564, al_datede#434188 AS AL_DATEDE_438420#434565, al_datefi#434200 AS AL_DATEFI_438432#434566, al_datmaj#434153 AS AL_DATMAJ_438385#434567, al_envadm#434161 AS AL_ENVADM_438393#434568, al_flicpt#434187 AS AL_FLICPT_438419#434569, al_flsej#434186 AS AL_FLSEJ_438418#434570, al_fltele#434191 AS AL_FLTELE_438423#434571, al_forfai#434164 AS AL_FORFAI_438396#434572, al_icd#434202 AS AL_ICD_438434#434573, al_int_spe#434197 AS AL_INT_SPE_438429#434574, al_int_std#434196 AS AL_INT_STD_438428#434575, al_letadm#434160 AS AL_LETADM_438392#434576, al_letads#434193 AS AL_LETADS_438425#434577, al_lib30#434148 AS AL_LIB30_438380#434578, al_libmaj#434149 AS AL_LIBMAJ_438381#434579, al_monnaie#434156 AS AL_MONNAIE_438388#434580, al_numbmp#434158 AS AL_NUMBMP_438390#434581, al_numcpt#434189 AS AL_NUMCPT_438421#434582, al_ordre#434159 AS AL_ORDRE_438391#434583, al_primai#434201 AS AL_PRIMAI_438433#434584, al_prior#434151 AS AL_PRIOR_438383#434585, al_rcp#434199 AS AL_RCP_438431#434586, al_rembours#434167 AS AL_REMBOURS_438399#434587, al_revers#434166 AS AL_REVERS_438398#434588, al_sites#434194 AS AL_SITES_438426#434589, al_spl_trans#434198 AS AL_SPL_TRANS_438430#434590, al_taux#434150 AS AL_TAUX_438382#434591, al_taux_r#434163 AS AL_TAUX_R_438395#434592, al_taux_t1r#434177 AS AL_TAUX_T1R_438409#434593, al_taux_t1#434168 AS AL_TAUX_T1_438400#434594, al_taux_t2r#434178 AS AL_TAUX_T2R_438410#434595, al_taux_t2#434169 AS AL_TAUX_T2_438401#434596, al_taux_t3r#434179 AS AL_TAUX_T3R_438411#434597, al_taux_t3#434170 AS AL_TAUX_T3_438402#434598, al_taux_t4r#434180 AS AL_TAUX_T4R_438412#434599, al_taux_t4#434171 AS AL_TAUX_T4_438403#434600, al_taux_t5r#434181 AS AL_TAUX_T5R_438413#434601, al_taux_t5#434172 AS AL_TAUX_T5_438404#434602, al_taux_t6r#434182 AS AL_TAUX_T6R_438414#434603, al_taux_t6#434173 AS AL_TAUX_T6_438405#434604, al_taux_t7r#434183 AS AL_TAUX_T7R_438415#434605, al_taux_t7#434174 AS AL_TAUX_T7_438406#434606, al_taux_t8r#434184 AS AL_TAUX_T8R_438416#434607, al_taux_t8#434175 AS AL_TAUX_T8_438407#434608, al_taux_t9r#434185 AS AL_TAUX_T9R_438417#434609, al_taux_t9#434176 AS AL_TAUX_T9_438408#434610, al_typexa#434157 AS AL_TYPEXA_438389#434611, al_type#434152 AS AL_TYPE_438384#434612, al_type_icd#434203 AS AL_TYPE_ICD_438435#434613, al_t_red#434162 AS AL_T_RED_438394#434614, al_urg#434195 AS AL_URG_438427#434615, al_valcou#434147 AS AL_VALCOU_438379#434616, null AS ORIGINE_440156#434617]
Input [59]: [al_annval#434146, al_classe#434165, al_codcha#434192, al_codsit#434155, al_coduti#434154, al_codval#434145, al_comment#434190, al_datede#434188, al_datefi#434200, al_datmaj#434153, al_envadm#434161, al_flicpt#434187, al_flsej#434186, al_fltele#434191, al_forfai#434164, al_icd#434202, al_int_spe#434197, al_int_std#434196, al_letadm#434160, al_letads#434193, al_lib30#434148, al_libmaj#434149, al_monnaie#434156, al_numbmp#434158, al_numcpt#434189, al_ordre#434159, al_primai#434201, al_prior#434151, al_rcp#434199, al_rembours#434167, al_revers#434166, al_sites#434194, al_spl_trans#434198, al_taux#434150, al_taux_r#434163, al_taux_t1r#434177, al_taux_t1#434168, al_taux_t2r#434178, al_taux_t2#434169, al_taux_t3r#434179, al_taux_t3#434170, al_taux_t4r#434180, al_taux_t4#434171, al_taux_t5r#434181, al_taux_t5#434172, al_taux_t6r#434182, al_taux_t6#434173, al_taux_t7r#434183, al_taux_t7#434174, al_taux_t8r#434184, al_taux_t8#434175, al_taux_t9r#434185, al_taux_t9#434176, al_typexa#434157, al_type#434152, al_type_icd#434203, al_t_red#434162, al_urg#434195, al_valcou#434147]

(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#434679, al_classe#434698, al_codcha#434725, al_codsit#434688, al_coduti#434687, al_codval#434678, al_comment#434723, al_datede#434721, al_datefi#434733, al_datmaj#434686, al_envadm#434694, al_flicpt#434720, al_flsej#434719, al_fltele#434724, al_forfai#434697, al_icd#434735, al_int_spe#434730, al_int_std#434729, al_letadm#434693, al_letads#434726, al_lib30#434681, al_libmaj#434682, al_monnaie#434689, al_numbmp#434691, al_numcpt#434722, al_ordre#434692, al_primai#434734, al_prior#434684, al_rcp#434732, al_rembours#434700, al_revers#434699, al_sites#434727, al_spl_trans#434731, al_taux#434683, al_taux_r#434696, al_taux_t1r#434710, al_taux_t1#434701, al_taux_t2r#434711, al_taux_t2#434702, al_taux_t3r#434712, al_taux_t3#434703, al_taux_t4r#434713, al_taux_t4#434704, al_taux_t5r#434714, al_taux_t5#434705, al_taux_t6r#434715, al_taux_t6#434706, al_taux_t7r#434716, al_taux_t7#434707, al_taux_t8r#434717, al_taux_t8#434708, al_taux_t9r#434718, al_taux_t9#434709, al_typexa#434690, al_type#434685, al_type_icd#434736, al_t_red#434695, al_urg#434728, al_valcou#434680]
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#434679 AS AL_ANNVAL_438378#435091, al_classe#434698 AS AL_CLASSE_438397#435092, al_codcha#434725 AS AL_CODCHA_438424#435093, al_codsit#434688 AS AL_CODSIT_438387#435094, al_coduti#434687 AS AL_CODUTI_438386#435095, al_codval#434678 AS AL_CODVAL_438377#435096, al_comment#434723 AS AL_COMMENT_438422#435097, al_datede#434721 AS AL_DATEDE_438420#435098, al_datefi#434733 AS AL_DATEFI_438432#435099, al_datmaj#434686 AS AL_DATMAJ_438385#435100, al_envadm#434694 AS AL_ENVADM_438393#435101, al_flicpt#434720 AS AL_FLICPT_438419#435102, al_flsej#434719 AS AL_FLSEJ_438418#435103, al_fltele#434724 AS AL_FLTELE_438423#435104, al_forfai#434697 AS AL_FORFAI_438396#435105, al_icd#434735 AS AL_ICD_438434#435106, al_int_spe#434730 AS AL_INT_SPE_438429#435107, al_int_std#434729 AS AL_INT_STD_438428#435108, al_letadm#434693 AS AL_LETADM_438392#435109, al_letads#434726 AS AL_LETADS_438425#435110, al_lib30#434681 AS AL_LIB30_438380#435111, al_libmaj#434682 AS AL_LIBMAJ_438381#435112, al_monnaie#434689 AS AL_MONNAIE_438388#435113, al_numbmp#434691 AS AL_NUMBMP_438390#435114, al_numcpt#434722 AS AL_NUMCPT_438421#435115, al_ordre#434692 AS AL_ORDRE_438391#435116, al_primai#434734 AS AL_PRIMAI_438433#435117, al_prior#434684 AS AL_PRIOR_438383#435118, al_rcp#434732 AS AL_RCP_438431#435119, al_rembours#434700 AS AL_REMBOURS_438399#435120, al_revers#434699 AS AL_REVERS_438398#435121, al_sites#434727 AS AL_SITES_438426#435122, al_spl_trans#434731 AS AL_SPL_TRANS_438430#435123, al_taux#434683 AS AL_TAUX_438382#435124, al_taux_r#434696 AS AL_TAUX_R_438395#435125, al_taux_t1r#434710 AS AL_TAUX_T1R_438409#435126, al_taux_t1#434701 AS AL_TAUX_T1_438400#435127, al_taux_t2r#434711 AS AL_TAUX_T2R_438410#435128, al_taux_t2#434702 AS AL_TAUX_T2_438401#435129, al_taux_t3r#434712 AS AL_TAUX_T3R_438411#435130, al_taux_t3#434703 AS AL_TAUX_T3_438402#435131, al_taux_t4r#434713 AS AL_TAUX_T4R_438412#435132, al_taux_t4#434704 AS AL_TAUX_T4_438403#435133, al_taux_t5r#434714 AS AL_TAUX_T5R_438413#435134, al_taux_t5#434705 AS AL_TAUX_T5_438404#435135, al_taux_t6r#434715 AS AL_TAUX_T6R_438414#435136, al_taux_t6#434706 AS AL_TAUX_T6_438405#435137, al_taux_t7r#434716 AS AL_TAUX_T7R_438415#435138, al_taux_t7#434707 AS AL_TAUX_T7_438406#435139, al_taux_t8r#434717 AS AL_TAUX_T8R_438416#435140, al_taux_t8#434708 AS AL_TAUX_T8_438407#435141, al_taux_t9r#434718 AS AL_TAUX_T9R_438417#435142, al_taux_t9#434709 AS AL_TAUX_T9_438408#435143, al_typexa#434690 AS AL_TYPEXA_438389#435144, al_type#434685 AS AL_TYPE_438384#435145, al_type_icd#434736 AS AL_TYPE_ICD_438435#435146, al_t_red#434695 AS AL_T_RED_438394#435147, al_urg#434728 AS AL_URG_438427#435148, al_valcou#434680 AS AL_VALCOU_438379#435149, null AS ORIGINE_440156#435150]
Input [59]: [al_annval#434679, al_classe#434698, al_codcha#434725, al_codsit#434688, al_coduti#434687, al_codval#434678, al_comment#434723, al_datede#434721, al_datefi#434733, al_datmaj#434686, al_envadm#434694, al_flicpt#434720, al_flsej#434719, al_fltele#434724, al_forfai#434697, al_icd#434735, al_int_spe#434730, al_int_std#434729, al_letadm#434693, al_letads#434726, al_lib30#434681, al_libmaj#434682, al_monnaie#434689, al_numbmp#434691, al_numcpt#434722, al_ordre#434692, al_primai#434734, al_prior#434684, al_rcp#434732, al_rembours#434700, al_revers#434699, al_sites#434727, al_spl_trans#434731, al_taux#434683, al_taux_r#434696, al_taux_t1r#434710, al_taux_t1#434701, al_taux_t2r#434711, al_taux_t2#434702, al_taux_t3r#434712, al_taux_t3#434703, al_taux_t4r#434713, al_taux_t4#434704, al_taux_t5r#434714, al_taux_t5#434705, al_taux_t6r#434715, al_taux_t6#434706, al_taux_t7r#434716, al_taux_t7#434707, al_taux_t8r#434717, al_taux_t8#434708, al_taux_t9r#434718, al_taux_t9#434709, al_typexa#434690, al_type#434685, al_type_icd#434736, al_t_red#434695, al_urg#434728, al_valcou#434680]

(5) Union

(6) HashAggregate [codegen id : 3]
Input [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Keys [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]

(7) Exchange
Input [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Arguments: hashpartitioning(AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26507]

(8) ShuffleQueryStage
Output [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Arguments: 0

(9) AQEShuffleRead
Input [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Arguments: coalesced

(10) HashAggregate [codegen id : 4]
Input [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Keys [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(14) HashAggregate [codegen id : 5]
Input [1]: [count#436175L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#436171L]
Results [1]: [count(1)#436171L AS count#436172L]

(15) Union

(16) HashAggregate
Input [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Keys [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Functions: []
Aggregate Attributes: []
Results [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]

(17) Exchange
Input [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Arguments: hashpartitioning(AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, ... 37 more fields), ENSURE_REQUIREMENTS, [plan_id=26479]

(18) HashAggregate
Input [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Keys [60]: [AL_ANNVAL_438378#434558, AL_CLASSE_438397#434559, AL_CODCHA_438424#434560, AL_CODSIT_438387#434561, AL_CODUTI_438386#434562, AL_CODVAL_438377#434563, AL_COMMENT_438422#434564, AL_DATEDE_438420#434565, AL_DATEFI_438432#434566, AL_DATMAJ_438385#434567, AL_ENVADM_438393#434568, AL_FLICPT_438419#434569, AL_FLSEJ_438418#434570, AL_FLTELE_438423#434571, AL_FORFAI_438396#434572, AL_ICD_438434#434573, AL_INT_SPE_438429#434574, AL_INT_STD_438428#434575, AL_LETADM_438392#434576, AL_LETADS_438425#434577, AL_LIB30_438380#434578, AL_LIBMAJ_438381#434579, AL_MONNAIE_438388#434580, AL_NUMBMP_438390#434581, AL_NUMCPT_438421#434582, AL_ORDRE_438391#434583, AL_PRIMAI_438433#434584, AL_PRIOR_438383#434585, AL_RCP_438431#434586, AL_REMBOURS_438399#434587, AL_REVERS_438398#434588, AL_SITES_438426#434589, AL_SPL_TRANS_438430#434590, AL_TAUX_438382#434591, AL_TAUX_R_438395#434592, AL_TAUX_T1R_438409#434593, AL_TAUX_T1_438400#434594, AL_TAUX_T2R_438410#434595, AL_TAUX_T2_438401#434596, AL_TAUX_T3R_438411#434597, AL_TAUX_T3_438402#434598, AL_TAUX_T4R_438412#434599, AL_TAUX_T4_438403#434600, AL_TAUX_T5R_438413#434601, AL_TAUX_T5_438404#434602, AL_TAUX_T6R_438414#434603, AL_TAUX_T6_438405#434604, AL_TAUX_T7R_438415#434605, AL_TAUX_T7_438406#434606, AL_TAUX_T8R_438416#434607, AL_TAUX_T8_438407#434608, AL_TAUX_T9R_438417#434609, AL_TAUX_T9_438408#434610, AL_TYPEXA_438389#434611, AL_TYPE_438384#434612, AL_TYPE_ICD_438435#434613, AL_T_RED_438394#434614, AL_URG_438427#434615, AL_VALCOU_438379#434616, ORIGINE_440156#434617]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(21) HashAggregate
Input [1]: [count#436175L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#436171L]
Results [1]: [count(1)#436171L AS count#436172L]

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

SQL / DataFrame Properties

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