exposure meter:
cid (user id)
newsid (exposure News)

Click list:
cid (user id)
newsid (Click News)

want to check whether each news article has been clicked in the following form:
cid newsid cid newsid
01 23456 01 23456
01 23457 null null

HIVE SQL:
select * from expose a LEFT OUTER JOIN click b ON (a.cid=b.cid and a.newsid=b.newsid) where a.p_date > = "2018040801" and b.p_date > = "2018040801" and

is there any error in the sentence
and what to do if I always report
No partition predicate found for Alias and OOM errors?