apache / apache/pinot

[discuss] Native Graph Query Language Support in Pinot

Open
#17,935 4 comments 1 reaction 0 assignees View on GitHub
stale
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.