title: How can I solve this hive sql problem? (Like join in Hive)
body: <p>I know Hive only provide equi join. For example, below sql statement.
  select *
  from A join B
  on A.c1 = B.c2
  where 1=1;</p>
  <p>But I want to execute Like join Query in Hive. For example, below sql statement.
  select *
  from A join B
  on A.c1 like B.c2
  where 1=1;</p>
  <p>Please let me know if you know the solution in Hive.</p>