hive不支持非等值连接 join操作。如:
select * from tonyjointest b join rtb_requests a on (true) where b.domain = substr(a.domain,length(a.domain)-length(b.domain)+1);
select * from tonyjointest b join rtb_requests a on b.domain like a.domian%);
但可以转化成这样:
select * from tonyjointest b join rtb_requests a on (true) where b.domain = substr(a.domain,length(a.domain)-length(b.domain)+1);