select
    *
from
    table1 as A
join
    table as B
on
    A.item_id = B.item_id
where
    A.id in (1139426, 1139436)
    and A.date >= '2018-12-01'

2019-02-21 19:23:41 ERROR ApplicationMaster:91 - User class threw exception: org.apache.spark.sql.AnalysisException: Found duplicate column(s) when inserting into hdfs://apollo-phx-nn-ha/user/lsu1/result.parquet: `item_id`;
......

* ---> A.*