I am using property file to pass sql query in spark scala, my property file like this.
spark.query=select '$env' from table_name limit 5
In spark code
val env="dev"
val query=sparkContext.getConf.get("spark.query");
println(query);
spark.sql(s"""$query""");
But here it's not talking value for dev my output is like below:
select $env
from table_name =>$env
value not populating.