search

aliyun / alibabacloud-odps-maxframe-client

Apache License 2.0
4 stars 2 forks source link

Codegen: Result temp table inserted twice #27

Open ericpai opened 3 months ago

ericpai commented 3 months ago

Error ODPS-0130071:[200,24] Semantic analysis exception - the same output cannot be present multiple times: INSERT OVERWRITE TABLE idata_analysis_dev.tmp_mf_20240625090310477gl0ujbfmmy3_ed7a3d1b842a9a40aa10b154e326a8f9_0

Table tmp_mf_20240625090310477gl0ujbfmmy3_ed7a3d1b842a9a40aa10b154e326a8f9_0 is inserted twice.

INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_e4d020639c2c05ed5deb35e4d9dce180_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_13;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_e9b16e0ee9bb6862d1ce94e4f006b74a_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_38;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_d93b951fe6d61d03815bc261e5dace81_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_22;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_d0d067db6bd8cf32b76ee9ba5955429c_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_29;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_ed7a3d1b842a9a40aa10b154e326a8f9_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_34;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_d706a26568a8e017569a96142bc2b0f1_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_28;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_e43b4fe80b42ccd9d1a1741b76b64aa2_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_24;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_fc025ecbb683d5f5c16422efaf8c26b7_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_3;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_f63a3e53c31f61b669cd306f1968cf40_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_16;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_df2fd5a34d6ac95de7303a416269fbaf_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_18;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_ef7abf35927b8aefbef3290c9b615185_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_39;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_d208e46846e50cb7559b1530136baf38_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_21;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_eaff9d36bcc3adc698695584034e96a0_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_11;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_dcba532fe11a63da7ba1f4b0173cb747_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_6;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_ebef2ad6e9245e4327354953a22ac4b8_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_5;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_d56e017fcec539656471af2ca1d1d256_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_19;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_ed7a3d1b842a9a40aa10b154e326a8f9_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_34;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_ea4dff2c577f0439a25764564261aa08_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_32;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_dcc779e964c470e73f16388efb4d5fd3_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_36;
INSERT OVERWRITE TABLE tmp_mf_20240625090310477gl0ujbfmmy3_f10b615757818d2405265baca3fc4667_0 SELECT * FROM @var_3db04272_3012_4308_a3dc_badc08216463_30;