Degree hops in AWS Neptune RDF Format

Question

I have loaded data in aws neptune in rdf format and Now I am querying data with neptune notebook using %%sparql magic command ..In this I want to run degree hops *3..10 like this how can I achieve this in sparql in aws neptune.

Accepted Answer

SPARQL has a feature called Property Paths that allows you to define the number of hops taken across a given predicate ("edge").  https://www.w3.org/TR/sparql11-property-paths/

One thing to note, however, is that SPARQL does not natively support the return of paths.  A Property Path query will only return the results found at the end of path.  You would need to execute these queries for each level and UNION the results in order to fetch all "connected components" within a certain number of hops.

**Updated: Sep 7th 9:23am US/Eastern**

If you wanted to do something like the following from openCypher:
```
MATCH p= (investor1: Investor {name: 'XYZ'}) - [ : HAS_EMAIL | HAS_PHONE | HAS_PRIMARY_CONTACT | HQ_ FAX*.. 10]-(Investor2:Investor)
WHERE investor1<>investor2
RETURN p
```

It would look something like this in SPARQL with the following sample dataset:
```
INSERT DATA {
      "XYZ" .
       .
       .
       .
       .
      "ABC" .
       .
       .
       .
       .
      "DEF" .
       .
       .
       .
       .
      "GHI" .
       .
       .
       .
       .
      "JKL" .
       .
       .
       .
       .
      "MNO" .
       .
       .
       .
       .

}
```

```
SELECT DISTINCT ?investor1 ?investor2 ?investor3  WHERE {
    {
        ?investor1  "XYZ" .
        ?investor1  ?email1 .
        ?investor1  ?phone1 .
        ?investor1  ?pcontact1 .
        ?investor1  ?hqfax1 .
        { SELECT ?investor2 WHERE {
        ?investor2  ?email1 . 
        ?investor2  ?phone1 . 
        ?investor2  ?pcontact1 . 
        ?investor2  ?hqfax1 . } }
        FILTER ( ?investor1 != ?investor2 )
    } UNION {
        ?investor1  "XYZ" .
        ?investor1  ?email1 .
        ?investor1  ?phone1 .
        ?investor1  ?pcontact1 .
        ?investor1  ?hqfax1 .
        { SELECT ?investor2 WHERE {
        ?investor2  ?email1 . 
        ?investor2  ?phone1 . 
        ?investor2  ?pcontact1 . 
        ?investor2  ?hqfax1 . } }
        FILTER ( ?investor1 != ?investor2 ) .
        ?investor2  ?email2 . 
        ?investor2  ?phone2 . 
        ?investor2  ?pcontact2 . 
        ?investor2  ?hqfax2 .
        { SELECT ?investor3 WHERE {
        ?investor3  ?email2 . 
        ?investor3  ?phone2 . 
        ?investor3  ?pcontact2 . 
        ?investor3  ?hqfax2 . } }
        FILTER ( ?investor2 != ?investor3 && ?investor3 != ?investor1 )
    }
   # And you would need to continue the above pattern of doing unions with increasing hops to generate the paths
}
```

Degree hops in AWS Neptune RDF Format

Relevant content