scala - Spark 查询 : unclosed character literal

Question

我使用 Hive SQL 使用 spark 执行此查询:

var hiveContext = new org.apache.spark.sql.hive.HiveContext(sc)

result = hiveContext.sql("select linestatus, sum(quantity) as sum_qty,count(*) as count_order from lineitem
where shipdate <= '1990-09-16' group by linestatus order by
linestatus")

但我收到此错误:

<console>:1: error: unclosed character literal
       where shipdate <= '1990-09-16' group by linestatus order by

你知道为什么吗？

Answer 1

Scala 中的多行字符串必须使用三引号括起来:

hiveContext.sql("""
    select linestatus, sum(quantity) as sum_qty,count(*) as count_order 
    from lineitem
    where shipdate <= '1990-09-16' group by linestatus order by linestatus""")