I tried the same with insert query like below
val a = 1207 val b = "amit" val c = 20 sqlContext.sql(s"""insert into table employee select t.* from (select $a, $b, $c) t""")
But, I got the following error
Exception in thread "main" org.apache.spark....