title: Apache Spark Join Datasets with tables having same column names (with different data)
body: <p>I want to join multiple datasets that have some columns with same name while having different data. This is possible to rename dataset columns while conversion to dataframe. But is it possible to use rename or setting prefix to column names while using datasets. </p>
  
  <pre><code>Dataset&lt;Row&gt; uct = spark.read().jdbc(jdbcUrl, "uct", connectionProperties);
  Dataset&lt;Row&gt; si = spark.read().jdbc(jdbcUrl, "si", connectionProperties).filter("status = 'ACTIVE'");
  Dataset&lt;Row&gt; uc = uct.join(si, uct.col("service_id").equalTo(si.col("id")))
  </code></pre>
  
  <p><em>uc</em> will have columns with same name <em>'code'</em> then it will be difficult to get value of code from either <em>uct.code</em> or <em>si.code</em></p>