how to add athe column in spark in scala code example

Example: how to add a column to a dataframe in scala spark permanent

val df2 = df.select(col("EmpId"),col("Salary"),lit("1").as("lit_value1"))
df2.show()