Column 'page_time' in field list is ambiguous.

Viewed 28

Doris版本:doris-2.1.11-rc01
有两张主键表:table_1和table_2
table_1字段:news_id、page_time、title
table_2字段:news_id、page_time、content
两个表的id、page_time都是相同的

select
pip.news_id
from table_1 pip
J0IN table_2 nc ON pip.news_id = nc.news_id
where pip.page_time >= '2025-09-25 22:04:00
AND pip.page_time <= '2025-12-26 22:04:00'
AND nc.page_time >= '2025-09-25 22:04:00'
AND nc.page_time <= '2025-12-26 22:04:00'
AND(
NOT MATCH_PHRASE (pip.titLe,'鱤')
OR NOT MATCH_PHRASE (nc.content,'')
)
LIMIT 10;

执行上述sql,提示:
errCode = 2, detailMessage = Column 'page_time' in field list is ambiguous.

3 Answers

where 这一行中,单引号没有闭合,不确定是复制问题还是什么

如下:
where pip.page_time >= '2025-09-25 22:04:00

同时不排除是解析问题,可以看下优化器这里:show variables like "%planner%";看看新老优化器

老师,sql语句中引号是复制影响的,原sql中有闭合。
image.png
看了优化器:
image.png

2026-02-05 17:47:38 同求,版本 2.1.8