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

[Nagesh_Rudraiah]

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

SELECT 

ID,

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

COMPANY

FROM TEST