title: Hive - Efficient join of two tables
body: <p>I am joining two large tables in Hive (one is over 1 billion rows, one is about 100 million rows) like so:</p>
  
  <pre><code>create table joinedTable as select t1.id, ... from t1 join t2 ON (t1.id = t2.id);
  </code></pre>
  
  <p>I have bucketed the two tables in the same way, clustering by id into 100 buckets for each, but the query is still taking a long time. </p>
  
  <p>Any suggestions on how to speed this up? </p>