hdh-spark-job - Details for Query 1217

Submitted Time: 2026/10/23 13:10:02
Duration: 0.2 s
Succeeded Jobs: 1214 1215

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 49 ms"; 6 [labelType="html" label="Sort sort time: 3 ms peak memory: 66.0 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 2.6 MiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 47,008 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 7 ms (3 ms, 3 ms, 3 ms (stage 1709.0: task 1501)) 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: 47,008 local bytes read: 2.4 MiB 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)) 7.0 MiB (3.5 MiB, 3.5 MiB, 3.5 MiB (stage 1709.0: task 1502)) 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)) 2.4 MiB (1223.1 KiB, 1223.2 KiB, 1223.2 KiB (stage 1709.0: task 1501))"]; 9 [labelType="html" label=" Union "]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 39 ms"; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label="Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore\".\"h_patien\") as x) [numPartitions=1] number of output rows: 23,504"]; } subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 42 ms"; 14 [labelType="html" label=" Project "]; 15 [labelType="html" label="Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore2\".\"h_patien\") as x) [numPartitions=1] number of output rows: 23,504"]; } 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 9->8; 11->9; 12->11; 14->9; 15->14; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653), 0, 10, LEFT))) AS COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#507737]

WholeStageCodegen (4)

Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653], [1], [1 DESC NULLS LAST]

Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (3)

AQEShuffleRead coalesced

Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=29418]

Union

Project [at_numdos#503781 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, at_stapat#503782 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, at_prefix#503783 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, at_nompat#503784 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, at_pnopat#503785 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, at_njfpat#503786 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, at_datnai#503787 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, at_datnaiss#503788 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, at_sexe#503789 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]

Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] [at_numdos#503781,at_stapat#503782,at_prefix#503783,at_nompat#503784,at_pnopat#503785,at_njfpat#503786,at_datnai#503787,at_datnaiss#503788,at_sexe#503789] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...

WholeStageCodegen (1)

Project [at_numdos#505008 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507886, at_stapat#505009 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507887, at_prefix#505010 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507888, at_nompat#505011 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#507889, at_pnopat#505012 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507890, at_njfpat#505013 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507891, at_datnai#505014 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#507892, at_datnaiss#505015 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507893, at_sexe#505016 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507894]

Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] [at_numdos#505008,at_stapat#505009,at_prefix#505010,at_nompat#505011,at_pnopat#505012,at_njfpat#505013,at_datnai#505014,at_datnaiss#505015,at_sexe#505016] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...

WholeStageCodegen (2)

Details

== Physical Plan ==
AdaptiveSparkPlan (19)
+- == Final Plan ==
   CollectLimit (12)
   +- * Project (11)
      +- Window (10)
         +- * Sort (9)
            +- AQEShuffleRead (8)
               +- ShuffleQueryStage (7), Statistics(sizeInBytes=7.0 MiB, rowCount=4.70E+4)
                  +- Exchange (6)
                     +- Union (5)
                        :- * Project (2)
                        :  +- * Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1]  (1)
                        +- * Project (4)
                           +- * Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1]  (3)
+- == Initial Plan ==
   CollectLimit (18)
   +- Project (17)
      +- Window (16)
         +- Sort (15)
            +- Exchange (14)
               +- Union (13)
                  :- Project (2)
                  :  +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1]  (1)
                  +- Project (4)
                     +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1]  (3)


(1) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1]  [codegen id : 1]
Output [9]: [at_numdos#503781, at_stapat#503782, at_prefix#503783, at_nompat#503784, at_pnopat#503785, at_njfpat#503786, at_datnai#503787, at_datnaiss#503788, at_sexe#503789]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string>

(2) Project [codegen id : 1]
Output [9]: [at_numdos#503781 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, at_stapat#503782 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, at_prefix#503783 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, at_nompat#503784 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, at_pnopat#503785 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, at_njfpat#503786 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, at_datnai#503787 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, at_datnaiss#503788 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, at_sexe#503789 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]
Input [9]: [at_numdos#503781, at_stapat#503782, at_prefix#503783, at_nompat#503784, at_pnopat#503785, at_njfpat#503786, at_datnai#503787, at_datnaiss#503788, at_sexe#503789]

(3) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1]  [codegen id : 2]
Output [9]: [at_numdos#505008, at_stapat#505009, at_prefix#505010, at_nompat#505011, at_pnopat#505012, at_njfpat#505013, at_datnai#505014, at_datnaiss#505015, at_sexe#505016]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string>

(4) Project [codegen id : 2]
Output [9]: [at_numdos#505008 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507886, at_stapat#505009 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507887, at_prefix#505010 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507888, at_nompat#505011 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#507889, at_pnopat#505012 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507890, at_njfpat#505013 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507891, at_datnai#505014 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#507892, at_datnaiss#505015 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507893, at_sexe#505016 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507894]
Input [9]: [at_numdos#505008, at_stapat#505009, at_prefix#505010, at_nompat#505011, at_pnopat#505012, at_njfpat#505013, at_datnai#505014, at_datnaiss#505015, at_sexe#505016]

(5) Union

(6) Exchange
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=29418]

(7) ShuffleQueryStage
Output [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]
Arguments: 0

(8) AQEShuffleRead
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]
Arguments: coalesced

(9) Sort [codegen id : 3]
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(10) Window
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653], [1], [1 DESC NULLS LAST]

(11) Project [codegen id : 4]
Output [11]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653), 0, 10, LEFT))) AS COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#507737]
Input [10]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653]

(12) CollectLimit
Input [11]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653, COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#507737]
Arguments: 1500

(13) Union

(14) Exchange
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=29402]

(15) Sort
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(16) Window
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653], [1], [1 DESC NULLS LAST]

(17) Project
Output [11]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653), 0, 10, LEFT))) AS COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#507737]
Input [10]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653]

(18) CollectLimit
Input [11]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653, COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#507737]
Arguments: 1500

(19) AdaptiveSparkPlan
Output [11]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#507623, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#507624, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#507625, COL_1903FED0_88C4_4416_9E39_453E598975A3#507626, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#507627, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#507628, COL_B39F2F25_9917_471C_9C72_927B15008A79#507629, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#507630, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#507631, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#507653, COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#507737]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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