title: Hive Join on String returns no matching
body: <p>I am trying to run a simple join on string values but getting no matching rows. However all the values are the same in both the tables</p>
  
  <pre><code>select l2.word,d.polarity from l2 join  dictionary d on (l2.word=d.word);
  
  L2 table :
  realtimesession_id      bigint                  None                
  word                    string                  None   
  
  Dictionary table :
  realtimesession_id      bigint                  None                
  word                    string                  None   
  </code></pre>
  
  <p>I tried setting set <code>hive.auto.convert.join=true;</code>
  but still no records matching. Please someone help.</p>