'encountered : identifier expected cross, having,inner left, limit,order,right,where,commacausedby:exception syntax error

my query looks like

but I am getting error

select a.account_number,b.reference_acc
from hdd.master_record format1 a
join hdd.monetary b
on a.load_date = b.load_date

can anyone tell me what is the issue with this query?

sql hive impala

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source