hpvd opened a new issue, #14568:
URL: https://github.com/apache/pinot/issues/14568

   Many DBs already support recursive queries for several years. This enable 
many graph / tree like queries with good performance
   without the need for a dedicated graph database.
   
   The `with recursive` clause is defined in ISO/IEC 9075-2:2023 ยง7.17 as part 
of optional feature T131
   
   A good intro what's made possible with this approach can be found here:
   
https://www.linkedin.com/pulse/you-dont-need-graph-database-modeling-graphs-trees-viktor-qvarfordt-efzof/
   
   databases with support for recursive queries
   - postgreSQL
   - mysql
   - mariaDB
   - MS SQL Server
   - sqlite
   
   https://modern-sql.com/caniuse/with_recursive_(top_level)
   
   => Is there way to make this happen for Pinot too?
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to