How To convert the below sql server query to spark_sql. especially the isnull Replace N/A. please Help

Nagesh_Rudraiah
New Contributor

How To convert the below query to spark sql. especially the isnull REplace

SELECT 

ID,

ISNULL(NAME,"N/A") AS NAME,

COMPANY

FROM TEST