此时
select
*
from
A
left join
B
on
A.paper_id=B.paper_id
会报错:
FAILED: SemanticException [Error 10036]: Duplicate column name: paper_id
解决:
select
A.paper_id as paper_id1
B.paper_id as paper_id2
others....
或者
两个表中的一个paper_id必要写,保证字段属性唯一即可