How to create temporary view in Spark SQL using a CTE?

Question

I'm attempting to create a temp view in Spark SQL using a with the statement:

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

But this error is thrown:

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
    )

matkurek · Accepted Answer · 2020-05-07 09:19:33Z

9

Removing brackets after first as makes it work:

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

answered May 7, 2020 at 9:19

matkurek

8099 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create temporary view in Spark SQL using a CTE?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related