Hive Join只支持等值连接，并不支持不等连接。

因为Hive语句最终会转换为MapReduce程序执行，但是MapReduce程序很难实现不等判断。

select lead.* from dealer_leads lead
left join dealer_info info
on lead.dealer_id=info.dealerid;

连接谓语中不支持or

--on 后面表达式不支持or
select lead.* from dealer_leads lead
left join dealer_info info
on lead.dealer_id=info.dealerid or lead.leads_id=0;