[QUESTION] Neptune DB querying

awslabs / aws-athena-query-federation

The Amazon Athena Query Federation SDK allows you to customize Amazon Athena with your own data sources and code.

Apache License 2.0

553 stars 290 forks source link

[QUESTION] Neptune DB querying #451

Closed m4t22 closed 1 year ago

m4t22 commented 3 years ago

So I managed to create glue tables for graph nodes and I am able to query all of them via Athena, my question is how to make use of graph dependencies via Athena SQL queries? Should I create tables for edges and make inner joins on them? Some guide on how Athena's SQL to gremlin queries are translated together with some examples would be a nice addition. Thanks in advance!

m4t22 commented 3 years ago

@abhishekpradeepmishra can you assist on this one?

abhishekpradeepmishra commented 3 years ago

We don't have support for edges, we are building it. Once in place you should be able to do a 3 way join between two vertices tables and an edge table to traverse a Graph Relationship