AWS Builder Center: Learn, Build and Connect with builders in the AWS community

AWS Builder Center is the official home for builders on AWS. Share and read what others are working on, follow people who inspire you, explore training and workshops, and find tools to support what you're building.

Redshift error when using recursive CTE

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;

주제: 분석
태그: 아마존 레드시프트
언어: English

Ash-data

질문됨 2년 전578회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

수락된 답변

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;

전문가

MilindOke

답변함 2년 전

전문가

Jordan Sandri

검토됨 일 년 전

Ash-data
2년 전
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.

Redshift error when using recursive CTE

답변 추가

관련 콘텐츠