[discuss] Native Graph Query Language Support in Pinot
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 2d 55m
- Merged PRs (30d)
- 182
Description
I wanted to check if there's any interest in the community about adding Native Graph Query Language Support to Pinot (openCypher or GQL).
My read of the Graph space is that companies often have a very limited set of use-cases which can benefit from Graphs, and having a separate Database like Neo4J might be quite an overkill.
Users can technically use solutions like Puppy Graph to avoid maintaining another datastore, but it's not open source.
Having Graph Query Language support in Pinot would have the advantage that users can use the same tables for low-latency SQL and Time Series Monitoring/Alerting use-cases. So even if their graph use-cases fizzle out, they can still use SQL or Time Series QL with their datasets.
However, I don't think we'll be able to do super high QPS or super low latencies. My guess is that 100ms or so latencies with QPS in the order of 100 might be doable, and this might be sufficient for most use-cases.
Technical details aside, **are there any companies that use Pinot that are interested in this?**
Contributor guide
Research direction
This issue is a community discussion and names no files, tests, or implementation entry points. Start by reviewing Pinot's existing SQL and time-series query support, then determine whether there is sufficient user interest and a feasible scope for native openCypher or GQL support; done would require an agreed design and implementation plan.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Active
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100