Ir para o conteúdo
Ao usar o AWS re:Post, você concorda com os AWS re:Post Termos de uso
AWS re:Postre:Post
sobre o re:Post

Redshift error when using recursive CTE

0

I'm trying to run this query on redshift, but I have an **ERROR: Assert **

with recursive tbl(col1, col2) as (
    select 1 as col1, 'str_' as col2
    union all
    select (col1 + 1) as col1, 'str' as col2
    from tbl
    where col1 < 5
)
select * from tbl;
Tópicos
Estatísticas
Tags
Amazon Redshift
Idioma
English

feita há 2 anos575 visualizações

1 Resposta
0
Resposta aceita

I tried something similar and it seems to work. So what is it they you are trying to get to here?

with recursive tbl(col1, col2) as (
    select 1 as col1, 10 as col2
    union all
    select col1+1 as col1, col2
    from tbl 
    where col1 < 5
)
select * from tbl;
AWS
ESPECIALISTA

respondido há 2 anos

ESPECIALISTA

avaliado há um ano

  • Ash-data
    há 2 anos

    Nicely done thanks ! So I had this error in my query (thanks for the solution !), but another problem (the major one) comes from dbt. It doesn't seem to support Recursive CTE : Runtime Error Database Error in sql_operation inline_query (from remote system.sql) Recursive CTE in subquery are not supported. I submitted a ticket with that to dbt labs.

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Conteúdo relevante