Can't use OR in left join

[周彩钦]

Hi all,

I have problem when using left join with hive 0.7.1.
I have a query below:

select
  a.pid,
  b.pid
tab1 a
  left join
tab2 b
  on (a.pid=b.pid or substr(a.pid,1,27)=b.pid);

But hive don't support "OR" in left join.
Table a is huge, and table b has 40000 rows now(will increase).
Is there any other solution to achieve this?

Thanks very much.

--