Re: [SparkSQL] Full Join Return Null Value For Funtion-Based Column

Sorry, I know the reason. closed 发件人: 刘 欢 日期: 2021年1月18日 星期一 下午1:39 收件人: "user@spark.apache.org" 主题: [SparkSQL] Full Join Return Null Value For Funtion-Based Column Hi All: Here I got two tables: Table A name num tom 2 jerry 3 jerry 4 null null Table B name sc

[SparkSQL] Full Join Return Null Value For Funtion-Based Column

Hi All: Here I got two tables: Table A name num tom 2 jerry 3 jerry 4 null null Table B name score tom 12 jerry 10 jerry 8 null null When i use spark.sql() to get result from A and B with sql : select a.name as aName, a.date, b.name as bName from ( selec