peter-toth commented on a change in pull request #23531: [SPARK-24497][SQL] Support recursive SQL query URL: https://github.com/apache/spark/pull/23531#discussion_r248569468
########## File path: sql/core/src/test/resources/sql-tests/inputs/recursion.sql ########## @@ -0,0 +1,291 @@ +-- List of configuration the test suite is run against: Review comment: Thank you @gatorsmile @mgaido91 @viirya for the feedback. What I will try to add in this PR is maybe a bit limited compared to what other DBs offer, but I hope it will be a still useful new feature of Spark SQL. And maybe we can extend it in follow up tickets. I found this nice presentation: https://www.percona.com/live/plam16/sites/default/files/slides/CTEs_in_MariaDB_10.2.pdf where you can find some slides about linear (SQL standard) and non-linear recursion which allows much more but not compatible with the standard. I will try to look into the `with.sql` tests of postgres, provide some more tests and find the features still missing and then we can decide which ones are must have in this PR if that works for you. cc @mgaido91 @viirya ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
