title: AnalysisException: u"Except can only be performed on tables with the compatible column types
body: <p>I am removing the actual column names as i am not supposed to share those
  But her is the glimpse of the error </p>
  
  <pre><code>AnalysisException: u"Except can only be performed on tables with the compatible column types. 
  string &lt;&gt; boolean at the 28th column of the second table;
  ;\n'Except false\n:- Filter (cast(inactive_date#111 as string) = '3001-01-01')\n:  
  +- Project [... 33 more fields]\n:+- Project [ ... 33 more fields]\n:+- SubqueryAlias \n:+-Relation[... 33 more fields] parquet\n
  +- Project [... 33 more fields]\n +- Join Inner, (Key#275 = entry#26)\n:- Filter (cast(inactive_date#283 as string) = '3001-01-01')\n:  
  +- Project [... 33 more fields]\n:  
  +- Project [... 33 more fields]\n : +- SubqueryAlias  +- Relation[,... 33 more fields] parquet\n      
  +- Deduplicate [entry#26]\n +- Project [entry#26]\n+- Project [... 13 more fields]\n              
  +- Project [... 13 more fields]\n  +- SubqueryAlias +- Relation[] parquet\n"
  </code></pre>
  
  <p>My code looks like this </p>
  
  <pre><code>#old dataframe   (consider it as History )
  #daily dataframe ( Consider it as daily  )
  
  #Filtering the Active records based on condition
  
  Active_old_filtered_records= old_history_dataframe.filter(old_history_dataframe["inactive_date"] == '3001-01-01')
  Inactive_old_filtered_records= old_history_dataframe.filter(old_history_dataframe["inactive_date"] != '3001-01-01')
  
  #Joining active old records with the matching active records in daily dataframe based on KeyColumnA 
  
  left = Active_old_filtered_records
  right = Active_new_daily_dataframe.select("keyColumnA").distinct()
  
  Matching_Active_daily_old_dataframe = left.join(right, ["keyColumnA"])
  Non_matching_active_daily_old_dateframe = Active_old_filtered_records.**subtract**(Matching_Active_daily_old_dataframe)
  </code></pre>
  
  <p>Note: Here the <strong>daily dataframe</strong> and old dataframe have exactly same schema but i am getting analysis exception. can someone help in this regard 
  Thank you.</p>