You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "hpvd (via GitHub)" <gi...@apache.org> on 2024/11/29 08:58:34 UTC
[I] Support for recursive queries [pinot]
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: commits-unsubscribe@pinot.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] Support for recursive queries (for graph / tree use-cases) [pinot]
Posted by "hpvd (via GitHub)" <gi...@apache.org>.
hpvd commented on issue #14568:
URL: https://github.com/apache/pinot/issues/14568#issuecomment-2513829320
on the long run, one could also look into integrating approaches like RelGo (kind of Calcite extension) to make even "Property Graph Queries" (PGQ) possible in highly efficient manner (which is now part of ISO SQL:2023)
for RelGo including benchmarks see:
Towards a Converged Relational-Graph Optimization Framework https://arxiv.org/html/2408.13480v1
--
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: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] Support for recursive queries (graph / tree like) [pinot]
Posted by "hpvd (via GitHub)" <gi...@apache.org>.
hpvd commented on issue #14568:
URL: https://github.com/apache/pinot/issues/14568#issuecomment-2508913075
is this realistic from a performance point of view?
imho for several usecases: YES!
When looking into fair comparisons / benchmarks of relational and graph databases
where each one is optimized by using indexes, you are able to even find performance benefits for relational databases in several graph like uses-cases because they take much more advantage from indexes than graph DBs do.
Example: Performance of Graph and Relational Databases in Complex Queries https://www.mdpi.com/2076-3417/12/13/6490
And Pinot already proofed being pretty strong on benefitting from indexes...
--
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: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] Support for recursive queries (graph / tree like) [pinot]
Posted by "hpvd (via GitHub)" <gi...@apache.org>.
hpvd commented on issue #14568:
URL: https://github.com/apache/pinot/issues/14568#issuecomment-2508910564
Motivation:
for using pinot for typical Graph-Usecases like
- deep personalisation
- social networks
- fraud detection
-> make it possible to build systems without having to use an additional database type
--
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: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] Support for recursive queries (for graph / tree use-cases) [pinot]
Posted by "hpvd (via GitHub)" <gi...@apache.org>.
hpvd commented on issue #14568:
URL: https://github.com/apache/pinot/issues/14568#issuecomment-2513782692
from strategic USP POV: being able to efficiently use Pinot for production graph use-cases, may give a new unique solution hardly to match in this combination by "real" graph DBs:
- low-latency (P95/99)
- high throughput
- data freshness at scale (real time ingest)
- pure size
would be also a great extension to anomaly detection (third eye)...
--
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: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] Support for recursive queries (for graph / tree use-cases) [pinot]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #14568:
URL: https://github.com/apache/pinot/issues/14568#issuecomment-4644637905
This issue has been closed because it has been inactive for 180 days. If you believe this issue is still relevant, please feel free to reopen it or create a new issue. Thank you!
--
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: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] Support for recursive queries (for graph / tree use-cases) [pinot]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #14568: Support for recursive queries (for graph / tree use-cases)
URL: https://github.com/apache/pinot/issues/14568
--
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: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] Support for recursive queries (for graph / tree use-cases) [pinot]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #14568:
URL: https://github.com/apache/pinot/issues/14568#issuecomment-4410801521
This issue has been automatically marked as stale because it has not had any activity in the last 150 days. It will be closed in 30 days if no further activity occurs. If this issue is still relevant, please leave a comment to keep it open. Thank you for your contributions!
--
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: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org