apache-spark - 如何使用 CTE 在 Spark SQL 中创建临时 View ？

Question

我正在尝试使用 with 语句在 Spark SQL 中创建一个临时 View :

create temporary view cars as (
    with models as (
       select 'abc' as model
    )
    select model from models
)

但是会抛出这个错误:

error in SQL statement: ParseException: 
mismatched input 'with' expecting {'(', 'SELECT', 'FROM', 'DESC', 'VALUES', 'TABLE', 'INSERT', 'DESCRIBE', 'MAP', 'MERGE', 'UPDATE', 'REDUCE'}(line 2, pos 8)

== SQL ==
create temporary view cars as (
        with models as (
--------^^^
           select 'abc' as model
        )
        select model from models
    )

Answer 1

在第一个 as 后删除括号使其工作:

create temporary view cars as 
with models as (
   select 'abc' as model
)
select model from models