请使用“"”，例如

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

或者，如果要设置代码格式，请用途：

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

您可以在SQL代码的开始/结束处使用三引号，或在每行的结尾处使用反斜杠。

val results = sqlContext.sql ("""
    create table enta.scd_fullfilled_entitlement as
    select *
    from my_table
    """);

results = sqlContext.sql (" \
    create table enta.scd_fullfilled_entitlement as \
    select * \
    from my_table \
    ")

val query = """(SELECT
      a.AcctBranchName,
    c.CustomerNum,
    c.SourceCustomerId,
    a.SourceAccountId,
    a.AccountNum,
    c.FullName,
    c.LastName,
    c.BirthDate,
    a.Balance,
    case when [RollOverStatus] = 'Y' then 'Yes' Else 'No' end as RollOverStatus
    FROM
    v_Account AS a left join v_Customer AS c
      ON c.CustomerID = a.CustomerID AND c.Businessdate = a.Businessdate
    WHERE
    a.Category = 'Deposit' AND
    c.Businessdate= '2018-11-28'  AND
    isnull(a.Classification,'N/A') IN ('Contractual Account','Non-Term Deposit','Term Deposit')
    AND IsActive = 'Yes' ) tmp """

值得注意的是，长度不是问题，只是书写的问题。为此，您可以像Gaweda建议的那样使用“"”，或者简单地使用一个字符串变量，例如，通过使用字符串构建器构建它。例如：

val selectElements = Seq("a","b","c")
val builder = StringBuilder.newBuilder
builder.append("select ")
builder.append(selectElements.mkString(","))
builder.append(" where d<10")
val results = sqlContext.sql(builder.toString())

除了上述方式外，还可以采用以下方式：

val results = sqlContext.sql("select .... " +
" from .... " +
" where .... " +
" group by ....
");

在三重引号内编写sql，如“sql code“
df = spark.sql（”从表1中选择 *“）
Scala spark和Pyspark也是如此。