3 ms·

I am the other post-author, and I am available too.

• padre24 3y ago
  This was a great read, thanks. Are there any plans to support recursive CTEs? What are the technical challenges there?
  • guptamanan100 3y ago
    Thank you for the compliment! We recently started adding support for CTEs in Vitess! You can check out https://github.com/vitessio/vitess/pull/14321 https://github.com/vitessio/vitess/pull/14321 if you want to see some technical details of the implementation. For now, we have added preliminary support by converting them to derived tables internally, but we believe that we need to make CTEs first-class citizens themselves of query planning, specifically because recursive CTEs are very hard to model as derived tables. Once we make that change, we can look towards supporting recursive CTEs. This however will take some time, but then, all good things do!
    • padre24 3y ago
      Awesome news! We work with hierarchical data so it was a non starter for us.
      • derekperkins 3y ago
        If you don't need recursive CTEs on sharded databases, they'll work today. We're actively using them
      • guptamanan100 3y ago
        Oh, I see, that's unfortunate! Hopefully, we can remedy that though as soon as possible.