create table as select internal表1 left join internal表2报Column in field list is ambiguous问题,建表失败,查询正常

Viewed 51

Doris版本信息:2.1.3
Version: doris-2.1.3-rc09-2dc65ce356
复现语句:
create table test
as
select a1.prod_inst_id
,a1.p_mon_id
,c1_yd+c1_kd+c1_gw+c1_itv+c1_sw_sz+c1_sw_hz+c1_zw_pt+c1_zw_yw+c1_bp_yzj+c1_bp_db+c1_bp_ydn+c1_bp_yaq+c1_bp_aqwg+c1_bp_lxzx+c1_bp_tyyy+c1_bp_tykj+c1_bp_spzx+c1_bp_wfzx+c1_bp_zqyp+c1_bp_qmjk tcf
,c2_addfk+c2_addgh+c2_yyb+c2_llb+c2_dxb+c2_fun_lx+c2_fun_cl+c2_fun_qt+c2_lzmh+c2_wxb+c2_tsb+c2_xyb+c2_fttr+c2_qxb+c2_zjb+c2_bp_aicl+c2_bp_gjdx+c2_bp_ldmp+c2_bp_jzdx+c2_bp_swcl+c2_bp_szxc+c2_bp_tyyy+c2_bp_ydngz+c2_bp_ydnzq+c2_bp_gryp+c2_hb_txzl+c2_hb_yyx+c2_hb_hygj+c2_hb_sjbz+c2_hb_ysh+c2_hb_fsr+c2_hb_spdd+c2_hb_tylw+c2_hb_tyyh+c2_hb_zhsq+c2_hb_qt kxb
,c3_gwyy+c3_ydyy+c3_ydsj+c3_gjth+c3_dcx+c3_itv+c3_zz_qycl+c3_zz_cldz+c3_zz_hb_sx+c3_zz_hb_ayy+c3_zz_hb_ayx+c3_zz_hb_ismp+c3_zz_hb_bst+c3_zz_hb_mp+c3_zz_hb_bh+c3_zz_hb_114+c3_zz_sqpt+c3_zz_qt qdf
,c4_lh+c4_hy+c4_xy+c4_qt bdf
,c5_tf tf
,c6_zs zs
,c1_yd+c1_kd+c1_gw+c1_itv+c1_sw_sz+c1_sw_hz+c1_zw_pt+c1_zw_yw+c1_bp_yzj+c1_bp_db+c1_bp_ydn+c1_bp_yaq+c1_bp_aqwg+c1_bp_lxzx+c1_bp_tyyy+c1_bp_tykj+c1_bp_spzx+c1_bp_wfzx+c1_bp_zqyp+c1_bp_qmjk
+c2_addfk+c2_addgh+c2_yyb+c2_llb+c2_dxb+c2_fun_lx+c2_fun_cl+c2_fun_qt+c2_lzmh+c2_wxb+c2_tsb+c2_xyb+c2_fttr+c2_qxb+c2_zjb+c2_bp_aicl+c2_bp_gjdx+c2_bp_ldmp+c2_bp_jzdx+c2_bp_swcl+c2_bp_szxc+c2_bp_tyyy+c2_bp_ydngz+c2_bp_ydnzq+c2_bp_gryp+c2_hb_txzl+c2_hb_yyx+c2_hb_hygj+c2_hb_sjbz+c2_hb_ysh+c2_hb_fsr+c2_hb_spdd+c2_hb_tylw+c2_hb_tyyh+c2_hb_zhsq+c2_hb_qt
+c3_gwyy+c3_ydyy+c3_ydsj+c3_gjth+c3_dcx+c3_itv+c3_zz_qycl+c3_zz_cldz+c3_zz_hb_sx+c3_zz_hb_ayy+c3_zz_hb_ayx+c3_zz_hb_ismp+c3_zz_hb_bst+c3_zz_hb_mp+c3_zz_hb_bh+c3_zz_hb_114+c3_zz_sqpt+c3_zz_qt
+c4_lh+c4_hy+c4_xy+c4_qt
+c5_tf
+c6_zs amount
,c1_tc_fq1+c1_tc_fq2 fq
,a1.lan_id
,a2.order_finish_date
from INT3LAB.LAB_PRD_CORE_PLAT_BUSI_DTL_M a1
left join INT3BAS.WID_PRD_PROD_INST_M a2
on a1.prod_inst_id=a2.prod_inst_id
and a1.p_mon_id=a2.p_mon_id where a.p_mon_id=202408;
370df7cc091189acaa2f2b039a38a61.png
报错内容:ERROR 1052 (23000): errCode = 2, detailMessage = Column 'P_MON_ID' in field list is ambiguous

查询正常:
1725884671468.png

疑点1:left join查询两张hive catalog表去创建这个test的internal表正常。
image.png
疑点2:之前遇到过一次一模一样的问题,当时没处理,现在重新试着重跑了下,运行正常。

请大佬们看一下,感激不尽!

1 Answers

这个需要开启新优化器,开启后正常