digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 3 ms";
2 [labelType="html" label="<b>Scan JDBCRelation((select * from (SELECT \"zd_numcot\", \"zd_numdem\", \"zd_numdos\", \"zd_numpco\", \"zd_primai\", \"zd_annval\", \"zd_monnaie\", \"zd_cod_acte\", \"zd_ver_ccam\", \"zd_codsit\", \"zd_coduti\", \"zd_datmaj\", \"zd_cod_aa\", \"zd_modificateur\", \"zd_codper\", \"zd_codser\", \"zd_numsal\", \"zd_flassprev\", \"zd_assnonprev\", \"zd_numord\", \"zd_priuni\", \"zd_coefmino\", \"zd_mino\", \"zd_majo\", \"zd_basrmb\", \"zd_factur\", \"zd_typexo\", \"zd_taucai\", \"zd_parcai\", \"zd_taumut\", \"zd_parmut\", \"zd_ligrgr\", \"zd_regrou_cod\", \"zd_cod_aap\", \"zd_qualdp\", \"zd_flrmbexc\", \"zd_flsuppcharge\", \"zd_donncompl\", \"zd_dents\", \"zd_depmnt\", \"zd_flid\", \"zd_mttid\", \"zd_tauid\", \"zd_amoid\", \"zd_tauid_amc\", \"zd_amcid\", \"zd_nbrik\", \"zd_mttik\", \"zd_tauik\", \"zd_amoik\", \"zd_nbrikm\", \"zd_mttikm\", \"zd_tauikm\", \"zd_amoikm\", \"zd_nbriks\", \"zd_mttiks\", \"zd_tauiks\", \"zd_amoiks\", \"zd_forc\", \"zd_formamc\", \"zd_codtit\", \"zd_flald\", \"zd_a_fact\", \"zd_x_exo_tm\", \"zd_modiffact\", \"zd_assnonprev_c\", \"zd_qualdp_c\", \"zd_coduam\", \"zd_mtdep\", \"zd_mtpenhps\", \"zd_flpav\", \"zd_mttori\", \"zd_acr\", \"zd_codapp\", \"zd_codper2\", \"zd_codind\", \"zd_codres\", \"zd_codextdoc\", \"zd_numexa\", \"zd_codextpmsi\" FROM \"xplore2\".\"h_ccamdet\") as x limit 200) as x) [numPartitions=1] </b><br><br>number of output rows: 200"];
}
2->0;
}
3
CollectLimit 500
Scan JDBCRelation((select * from (SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore2"."h_ccamdet") as x limit 200) as x) [numPartitions=1] [zd_numcot#418458,zd_numdem#418459,zd_numdos#418460,zd_numpco#418461,zd_primai#418462,zd_annval#418463,zd_monnaie#418464,zd_cod_acte#418465,zd_ver_ccam#418466,zd_codsit#418467,zd_coduti#418468,zd_datmaj#418469,zd_cod_aa#418470,zd_modificateur#418471,zd_codper#418472,zd_codser#418473,zd_numsal#418474,zd_flassprev#418475,zd_assnonprev#418476,zd_numord#418477,zd_priuni#418478,zd_coefmino#418479,zd_mino#418480,zd_majo#418481,... 56 more fields] PushedFilters: [], ReadSchema: struct<zd_numcot:string,zd_numdem:string,zd_numdos:string,zd_numpco:string,zd_primai:string,zd_an...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (2)
+- * Scan JDBCRelation((select * from (SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore2"."h_ccamdet") as x limit 200) as x) [numPartitions=1] (1)
(1) Scan JDBCRelation((select * from (SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore2"."h_ccamdet") as x limit 200) as x) [numPartitions=1] [codegen id : 1]
Output [80]: [zd_numcot#418458, zd_numdem#418459, zd_numdos#418460, zd_numpco#418461, zd_primai#418462, zd_annval#418463, zd_monnaie#418464, zd_cod_acte#418465, zd_ver_ccam#418466, zd_codsit#418467, zd_coduti#418468, zd_datmaj#418469, zd_cod_aa#418470, zd_modificateur#418471, zd_codper#418472, zd_codser#418473, zd_numsal#418474, zd_flassprev#418475, zd_assnonprev#418476, zd_numord#418477, zd_priuni#418478, zd_coefmino#418479, zd_mino#418480, zd_majo#418481, zd_basrmb#418482, zd_factur#418483, zd_typexo#418484, zd_taucai#418485, zd_parcai#418486, zd_taumut#418487, zd_parmut#418488, zd_ligrgr#418489, zd_regrou_cod#418490, zd_cod_aap#418491, zd_qualdp#418492, zd_flrmbexc#418493, zd_flsuppcharge#418494, zd_donncompl#418495, zd_dents#418496, zd_depmnt#418497, zd_flid#418498, zd_mttid#418499, zd_tauid#418500, zd_amoid#418501, zd_tauid_amc#418502, zd_amcid#418503, zd_nbrik#418504, zd_mttik#418505, zd_tauik#418506, zd_amoik#418507, zd_nbrikm#418508, zd_mttikm#418509, zd_tauikm#418510, zd_amoikm#418511, zd_nbriks#418512, zd_mttiks#418513, zd_tauiks#418514, zd_amoiks#418515, zd_forc#418516, zd_formamc#418517, zd_codtit#418518, zd_flald#418519, zd_a_fact#418520, zd_x_exo_tm#418521, zd_modiffact#418522, zd_assnonprev_c#418523, zd_qualdp_c#418524, zd_coduam#418525, zd_mtdep#418526, zd_mtpenhps#418527, zd_flpav#418528, zd_mttori#418529, zd_acr#418530, zd_codapp#418531, zd_codper2#418532, zd_codind#418533, zd_codres#418534, zd_codextdoc#418535, zd_numexa#418536, zd_codextpmsi#418537]
ReadSchema: struct<zd_numcot:string,zd_numdem:string,zd_numdos:string,zd_numpco:string,zd_primai:string,zd_annval:string,zd_monnaie:string,zd_cod_acte:string,zd_ver_ccam:string,zd_codsit:string,zd_coduti:string,zd_datmaj:string,zd_cod_aa:string,zd_modificateur:string,zd_codper:string,zd_codser:string,zd_numsal:string,zd_flassprev:string,zd_assnonprev:string,zd_numord:string,zd_priuni:string,zd_coefmino:string,zd_mino:string,zd_majo:string,zd_basrmb:string,zd_factur:string,zd_typexo:string,zd_taucai:string,zd_parcai:string,zd_taumut:string,zd_parmut:string,zd_ligrgr:string,zd_regrou_cod:string,zd_cod_aap:string,zd_qualdp:string,zd_flrmbexc:string,zd_flsuppcharge:string,zd_donncompl:string,zd_dents:string,zd_depmnt:string,zd_flid:string,zd_mttid:string,zd_tauid:string,zd_amoid:string,zd_tauid_amc:string,zd_amcid:string,zd_nbrik:string,zd_mttik:string,zd_tauik:string,zd_amoik:string,zd_nbrikm:string,zd_mttikm:string,zd_tauikm:string,zd_amoikm:string,zd_nbriks:string,zd_mttiks:string,zd_tauiks:string,zd_amoiks:string,zd_forc:string,zd_formamc:string,zd_codtit:string,zd_flald:string,zd_a_fact:string,zd_x_exo_tm:string,zd_modiffact:string,zd_assnonprev_c:string,zd_qualdp_c:string,zd_coduam:string,zd_mtdep:string,zd_mtpenhps:string,zd_flpav:string,zd_mttori:string,zd_acr:string,zd_codapp:string,zd_codper2:string,zd_codind:string,zd_codres:string,zd_codextdoc:string,zd_numexa:string,zd_codextpmsi:string>
(2) CollectLimit
Input [80]: [zd_numcot#418458, zd_numdem#418459, zd_numdos#418460, zd_numpco#418461, zd_primai#418462, zd_annval#418463, zd_monnaie#418464, zd_cod_acte#418465, zd_ver_ccam#418466, zd_codsit#418467, zd_coduti#418468, zd_datmaj#418469, zd_cod_aa#418470, zd_modificateur#418471, zd_codper#418472, zd_codser#418473, zd_numsal#418474, zd_flassprev#418475, zd_assnonprev#418476, zd_numord#418477, zd_priuni#418478, zd_coefmino#418479, zd_mino#418480, zd_majo#418481, zd_basrmb#418482, zd_factur#418483, zd_typexo#418484, zd_taucai#418485, zd_parcai#418486, zd_taumut#418487, zd_parmut#418488, zd_ligrgr#418489, zd_regrou_cod#418490, zd_cod_aap#418491, zd_qualdp#418492, zd_flrmbexc#418493, zd_flsuppcharge#418494, zd_donncompl#418495, zd_dents#418496, zd_depmnt#418497, zd_flid#418498, zd_mttid#418499, zd_tauid#418500, zd_amoid#418501, zd_tauid_amc#418502, zd_amcid#418503, zd_nbrik#418504, zd_mttik#418505, zd_tauik#418506, zd_amoik#418507, zd_nbrikm#418508, zd_mttikm#418509, zd_tauikm#418510, zd_amoikm#418511, zd_nbriks#418512, zd_mttiks#418513, zd_tauiks#418514, zd_amoiks#418515, zd_forc#418516, zd_formamc#418517, zd_codtit#418518, zd_flald#418519, zd_a_fact#418520, zd_x_exo_tm#418521, zd_modiffact#418522, zd_assnonprev_c#418523, zd_qualdp_c#418524, zd_coduam#418525, zd_mtdep#418526, zd_mtpenhps#418527, zd_flpav#418528, zd_mttori#418529, zd_acr#418530, zd_codapp#418531, zd_codper2#418532, zd_codind#418533, zd_codres#418534, zd_codextdoc#418535, zd_numexa#418536, zd_codextpmsi#418537]
Arguments: 500