[GitHub] [superset] brian-bh commented on issue #21715: with recursive CTE works on SQL Lab, but not on making chart with it

[GitBox <gi...@apache.org>]

brian-bh commented on issue #21715:
URL: https://github.com/apache/superset/issues/21715#issuecomment-1274069787

   @mayurnewase thanks for your reply.
   I tried as you say so (modified VALUES to SELECT because it gives me an error that there's no function name VALUES);
   and voila, it gives me same error that I reported in SQLLab.
   and the error is not only in redshift but also in postgresql, and I think that's natural in psycopg2.
   but the thing is, you said that this query
   `WITH RECURSIVE t(n) AS ( VALUES (1) UNION ALL SELECT n+1 FROM t WHERE n < 2 ) SELECT sum(n) FROM t;`
   succeed in making charts, but I get the same error as I reported.
   ![image](https://user-images.githubusercontent.com/46946734/194996519-1c511654-c772-4cfa-b0ff-d09a94c5094b.png)
   
   So, I think in making Charts, the whole query becomes subquery that named virtual_table, and that's the problem.
   In this case, there's no option to make charts from queries that has recursive CTE and so?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org