scala - How to escape column names with hyphen in Spark SQL

Question

I have imported a json file in Spark and convertd it into a table as

myDF.registerTempTable("myDF")

I then want to run SQL queries on this resulting table

val newTable = sqlContext.sql("select column-1 from myDF")

However this gives me an error because of the hypen in the name of the column column-1. How do I resolve this is Spark SQL?

Answer 1

Backticks (`) appear to work, so

val newTable = sqlContext.sql("select `column-1` from myDF")

should do the trick, at least in Spark v1.3.x.