|
Die klassischen Dateitypen können ab Januar 2021 nicht mehr verwendet werden. Sie können Ihre klassischen Dateien übertragen oder eine PDF herunterladen. Weitere Informationen

recursive CTE to convert parent child to tree

Beantwortet
Demo anfordern

I have hiearchial data coming from my source system.I need to create a tree or flattened structure to be able to aggregate within Wdata. I can convert a parent-child hierarchy into a tree using CTE's but recursive functionality is not working in Wdata. i get the following error

Recursive WITH queries are not supported

is there any alternate solution?

0

Kommentare

3 Kommentare

Datum Stimmen
  • Regan Edwards

    Hi Ganesh and welcome to Community!

    First, let's try using "WITH RECURSIVE" instead of just "WITH". Presto does not support "WITH" directly.

    Please let me know if you are still experiencing trouble! 

    0
  • Ganesh Karri

    Hi Regan,

    I tried with recursive but it displays an error than with recursive is not supported. 

    simple cte:

    WITH recursive "Numbers" AS
    (
    SELECT 1 AS "n"
    UNION ALL
    SELECT "n" + 1
    FROM "Numbers"
    WHERE "n"+1 <= 10
    )
    SELECT *
    FROM
    "Numbers"

    I am getting the following error.

    [Query failed (#20210602_225140_03779_m6jsc): line 1:1: Recursive WITH queries are not supported]

     

    Thanks,

    Ganesh

    0
  • Regan Edwards

    Ganesh, thank you for the feedback. This sounds like this may be a bug that we are experiencing. I would recommend reaching out to support and get their intake on the issue. I have included their contact information below.

    Phone: 800-706-6526
    Email: Support@workiva.com

    0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.