Spark SQL passing a variable

Question

I have following Spark sql and I want to pass variable to it. How to do that? I tried following way.

 sqlContext.sql("SELECT count from mytable WHERE id=$id")

Answer 1

You can pass a string into sql statement like below

id = "1"
query = "SELECT count from mytable WHERE id='{}'".format(id)
sqlContext.sql(query)

Answer 2

You are almost there just missed s :)

sqlContext.sql(s"SELECT count from mytable WHERE id=$id")