Hive left outer connection problem

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?

Hive java

Mar.01,2021

Previous: How do I end the entire routing function in the mongodb callback?

Next: Ubuntu installation composer, error: tls_process_server_certificate.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-42a6eb4-6022.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-42a6eb4-6022.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?