danielcraig23
danielcraig23
PostsComments
ATApache TinkerPop
Created by danielcraig23 on 1/28/2025 in #questions
How can I use a subquery to translate airport code DAL into icao airport code KDAL, w air-routes?
Thank you, I'll try this!!
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/28/2025 in #questions
How can I use a subquery to translate airport code DAL into icao airport code KDAL, w air-routes?
For background, I need this to be fast with around 850 aircraft and multiple thousands of airports
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/28/2025 in #questions
How can I use a subquery to translate airport code DAL into icao airport code KDAL, w air-routes?
I'm using Neptune, will this query be efficient on Neptune?
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/28/2025 in #questions
How can I use a subquery to translate airport code DAL into icao airport code KDAL, w air-routes?
I have this query, which uses double .V(), is this best practices? 
gremlin> g.V().hasLabel("aircraft").as("ac").V().hasLabel("airport").as("ap").where("ac", P.eq("ap")).by("aircraftLocation").by("code").select("ac", "ap").by("tailNumber").by("icao")
==>[ac:N12345,ap:KDAL]
gremlin> g.V().hasLabel("aircraft").as("ac").V().hasLabel("airport").as("ap").where("ac", P.eq("ap")).by("aircraftLocation").by("code").select("ac", "ap").by("tailNumber").by("icao")
==>[ac:N12345,ap:KDAL]
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/28/2025 in #questions
How can I use a subquery to translate airport code DAL into icao airport code KDAL, w air-routes?
^ this is a SQL pseudocode for what I'm trying to do
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/28/2025 in #questions
How can I use a subquery to translate airport code DAL into icao airport code KDAL, w air-routes?
SELECT ac.tailNumber, ap.icao FROM aircrafts ac CROSS JOIN airports ap WHERE ac.tailLocation = ap.code
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/28/2025 in #questions
How can I use a subquery to translate airport code DAL into icao airport code KDAL, w air-routes?
So I need to do a cross join on the aircrafts and the airports, and then pick a property from the right "table"
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/28/2025 in #questions
How can I use a subquery to translate airport code DAL into icao airport code KDAL, w air-routes?
I intend to use the station properties named code and icao to do this translation: 
gremlin> g.V().hasLabel("airport").elementMap("code", "icao").limit(1)
==>[id:1,label:airport,code:ATL,icao:KATL]
gremlin> g.V().hasLabel("airport").elementMap("code", "icao").limit(1)
==>[id:1,label:airport,code:ATL,icao:KATL]
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/21/2025 in #questions
Trying to load air-routes.graphml yields no such file or directory
Thanks! when I did an absolute file path, not using ~/Downloads/ but using /Users/x/Downloads instead, it worked!
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/21/2025 in #questions
Trying to load air-routes.graphml yields no such file or directory
I'll try the completing the data load using the steps that you show
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/21/2025 in #questions
Trying to load air-routes.graphml yields no such file or directory
I get the same result when I use the absolute path ~/air-routes.graphml
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/21/2025 in #questions
Trying to load air-routes.graphml yields no such file or directory
~ % gremlin

         \,,,/
         (o o)
-----oOOo-(3)-oOOo-----
plugin activated: tinkerpop.server
plugin activated: tinkerpop.utilities
plugin activated: tinkerpop.tinkergraph
gremlin> conf = new BaseConfiguration()
==>org.apache.commons.configuration2.BaseConfiguration@1f52eb6f
gremlin> conf.setProperty("gremlin.tinkergraph.vertexIdManager","LONG")
==>null
gremlin> conf.setProperty("gremlin.tinkergraph.edgeIdManager","LONG")
==>null
gremlin> conf.setProperty("gremlin.tinkergraph.vertexPropertyIdManager","LONG")
==>null
gremlin> graph = TinkerGraph.open(conf)
==>tinkergraph[vertices:0 edges:0]
gremlin> graph.io(graphml()).readGraph('~/air-routes.graphml')
~/air-routes.graphml (No such file or directory)
Type ':help' or ':h' for help.
Display stack trace? [yN]
gremlin> :exit
~ % head ~/air-routes.graphml
<?xml version='1.0' ?>
<!-- ******************************************************************************* -->
<!-- Sample file containing selected air routes between selected airports.           -->
<!-- Intended for learning purposes only and not for travel planning!                -->
<!--                                                                                 -->
<!-- Author: Kelvin R. Lawrence.                                                     -->
<!-- Graph version : 0.77 , 2017-Oct-06                                              -->
<!--                                                                                 -->
<!-- Please send details of errors in the graph or suggestions to:                   -->
<!-- e-mail: [email protected] , twitter: @gfxman                                     -->
~ % gremlin

         \,,,/
         (o o)
-----oOOo-(3)-oOOo-----
plugin activated: tinkerpop.server
plugin activated: tinkerpop.utilities
plugin activated: tinkerpop.tinkergraph
gremlin> conf = new BaseConfiguration()
==>org.apache.commons.configuration2.BaseConfiguration@1f52eb6f
gremlin> conf.setProperty("gremlin.tinkergraph.vertexIdManager","LONG")
==>null
gremlin> conf.setProperty("gremlin.tinkergraph.edgeIdManager","LONG")
==>null
gremlin> conf.setProperty("gremlin.tinkergraph.vertexPropertyIdManager","LONG")
==>null
gremlin> graph = TinkerGraph.open(conf)
==>tinkergraph[vertices:0 edges:0]
gremlin> graph.io(graphml()).readGraph('~/air-routes.graphml')
~/air-routes.graphml (No such file or directory)
Type ':help' or ':h' for help.
Display stack trace? [yN]
gremlin> :exit
~ % head ~/air-routes.graphml
<?xml version='1.0' ?>
<!-- ******************************************************************************* -->
<!-- Sample file containing selected air routes between selected airports.           -->
<!-- Intended for learning purposes only and not for travel planning!                -->
<!--                                                                                 -->
<!-- Author: Kelvin R. Lawrence.                                                     -->
<!-- Graph version : 0.77 , 2017-Oct-06                                              -->
<!--                                                                                 -->
<!-- Please send details of errors in the graph or suggestions to:                   -->
<!-- e-mail: [email protected] , twitter: @gfxman                                     -->
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/21/2025 in #questions
Trying to load air-routes.graphml yields no such file or directory
I wanted to use the air routes database to write up a question that I need to ask, but I can't seem to follow the instructions found in Practical Gremlin and at https://github.com/krlawrence/graph/blob/master/sample-data/load-air-routes-graph.groovy#L13 to load the air-routes database
12 replies
ATApache TinkerPop
Created by danielcraig23 on 1/21/2025 in #questions
Trying to load air-routes.graphml yields no such file or directory
~ % gremlin

         \,,,/
         (o o)
-----oOOo-(3)-oOOo-----
plugin activated: tinkerpop.server
plugin activated: tinkerpop.utilities
plugin activated: tinkerpop.tinkergraph
gremlin> conf = new BaseConfiguration()
==>org.apache.commons.configuration2.BaseConfiguration@1f52eb6f
gremlin> conf.setProperty("gremlin.tinkergraph.vertexIdManager","LONG")
==>null
gremlin> conf.setProperty("gremlin.tinkergraph.edgeIdManager","LONG")
==>null
gremlin> conf.setProperty("gremlin.tinkergraph.vertexPropertyIdManager","LONG")
==>null
gremlin> graph = TinkerGraph.open(conf)
==>tinkergraph[vertices:0 edges:0]
gremlin> 
graph.io(graphml()).readGraph('air-routes.graphml')
air-routes.graphml (No such file or directory)
Type ':help' or ':h' for help.
Display stack trace? [yN]
~ % gremlin

         \,,,/
         (o o)
-----oOOo-(3)-oOOo-----
plugin activated: tinkerpop.server
plugin activated: tinkerpop.utilities
plugin activated: tinkerpop.tinkergraph
gremlin> conf = new BaseConfiguration()
==>org.apache.commons.configuration2.BaseConfiguration@1f52eb6f
gremlin> conf.setProperty("gremlin.tinkergraph.vertexIdManager","LONG")
==>null
gremlin> conf.setProperty("gremlin.tinkergraph.edgeIdManager","LONG")
==>null
gremlin> conf.setProperty("gremlin.tinkergraph.vertexPropertyIdManager","LONG")
==>null
gremlin> graph = TinkerGraph.open(conf)
==>tinkergraph[vertices:0 edges:0]
gremlin> 
graph.io(graphml()).readGraph('air-routes.graphml')
air-routes.graphml (No such file or directory)
Type ':help' or ':h' for help.
Display stack trace? [yN]
12 replies
ATApache TinkerPop
Created by beef_pork_chicken on 12/21/2024 in #questions
TypeScript incomplete declaration of Traverser
I'm able to cast it like this: const castResult : Map<string, string> = result as Map<string, string>
5 replies
ATApache TinkerPop
Created by beef_pork_chicken on 12/21/2024 in #questions
TypeScript incomplete declaration of Traverser
I have the same issue: how do I get() anything from a Traverser?
5 replies
ATApache TinkerPop
Created by danielcraig23 on 5/9/2024 in #questions
Is the insertion order guaranteed with this example code?
Ok thank you!!
13 replies
ATApache TinkerPop
Created by danielcraig23 on 5/9/2024 in #questions
Is the insertion order guaranteed with this example code?
for 3.6.2 is this also the case?
13 replies
ATApache TinkerPop
Created by danielcraig23 on 5/9/2024 in #questions
Is the insertion order guaranteed with this example code?
@Valentyn Kahamlyk does gtx....iterate() have a strategy for maintaining the order of these writes?
13 replies
ATApache TinkerPop
Created by danielcraig23 on 5/9/2024 in #questions
Using mergeE to create an edge with an id that depends on a lookup
Thank you @spmallette !
8 replies