scala - How to execute multi line sql in spark sql

Question

How can I execute lengthy, multiline Hive Queries in Spark SQL? Like query below:

val sqlContext = new HiveContext (sc)
val result = sqlContext.sql ("
 select ...
 from ...
");

Answer 1

Use """ instead, so for example

val results = sqlContext.sql ("""
     select ....
     from ....
""");

or, if you want to format code, use:

val results = sqlContext.sql ("""
     |select ....
     |from ....
""".stripMargin);