Spark SQL equivalent for Oracle functions

Question

I am trying to find the spark SQL for the following oracle function

IIF(ISNULL(TYPE_CODE),'UNASSIGNED',TYPE_CODE)

itIsNaz · Answer 1 · 2021-03-26T19:53:59.590

0

In scala :

import  org.apache.spark.sql.{functions => f} 
val new_df = df_name.withColumn("col_name",f.when(f.col("other_col_name").isNull(),TYPE_CODE)

edited Mar 26 '21 at 19:53

answered Mar 26 '21 at 19:42

itIsNaz

I want it in spark sql – Raghu13 Mar 28 '21 at 18:56
Use this : https://stackoverflow.com/questions/25157451/spark-sql-case-when-then – itIsNaz Mar 28 '21 at 19:01

1 Answers1