Recursive CTE is possible in Virtual Graph mapping FROM block

Support
1

Hi Stardog Team,

Is it possible to use Recursive CTE in the FROM block of Virtual Graph mapping?
I was trying to access hierarchy data out of SQL source via 2 tables, using the recursive CTE and while saving the VG mapping I'm getting the following error:

Failed to update Virtual Graph "VG_name": 000012: com.complexible.stardog.virtual.vega.UncheckedSqlParseException: Encountered "with" at line 18, column 61.
Was expecting one of:
    "AS" ...
    "EXCEPT" ...
    "EXTEND" ...
    "FETCH" ...
    "FOR" ...
    "GROUP" ...
    "." ...

Here, "with" is the "with" clause of the CTE query.

If Recursive CTE is not supported, then could you please provide alternate solutions?
Thank you.

Regards,
Ashish

2

Hi Ashish,

Recursive CTE is not currently supported in the FROM clause. Your best bet for a work around would be to create a VIEW in your upstream RDBMS and map to it.

-Paul