title: remove duplicated columns in Spark using SQL expression
body: <p>I think this question similar to some other questions, but it is not asked.</p>
  
  <p>In Spark, how can we run SQL query with duplicate column removed?</p>
  
  <p>For example, a SQL query running on spark</p>
  
  <pre><code>select a.* from a
  left outer join
     select b.* from b
  on a.id = b.id  
  </code></pre>
  
  <p>how can I remove the duplicated column b.id in this case?</p>
  
  <p>I know we can use additional steps in Spark, such as providing alas or rename columns, but is there a faster way to remove the duplicated columns simply by writing SQL querys?</p>