title: How to join on multiple columns in Pyspark?
body: <p>I am using Spark 1.3 and would like to join on multiple columns using python interface (SparkSQL)</p>
  
  <p>The following works:</p>
  
  <p>I first register them as temp tables.</p>
  
  <pre><code>numeric.registerTempTable("numeric")
  Ref.registerTempTable("Ref")
  
  test  = numeric.join(Ref, numeric.ID == Ref.ID, joinType='inner')
  </code></pre>
  
  <p>I would now like to join them based on multiple columns.</p>
  
  <p>I get <code>SyntaxError</code>: invalid syntax with this:</p>
  
  <pre><code>test  = numeric.join(Ref,
     numeric.ID == Ref.ID AND numeric.TYPE == Ref.TYPE AND
     numeric.STATUS == Ref.STATUS ,  joinType='inner')
  </code></pre>