Loading Graphs with Unsupported Key Types

7.7 Loading Graphs with Unsupported Key Types

Starting from Graph Server and Client Release 25.2 onwards, you can load a SQL property graph (or a subgraph) containing unsupported key types for vertices or edges, into the graph server (PGX) memory.

When loading an entire SQL property graph or a subgraph into memory, the supported key types for the graph elements are as follows:

For vertices, keys need to be one of these (PGX) types: INTEGER, LONG, or STRING.
For edges, keys can only be numeric and the only supported type is LONG.

However, if the graph contains unsupported key types or composite keys for a vertex or an edge, the full graph or subgraph can still be loaded using the readGraphByName API. In such cases, the graph server (PGX) will automatically generate unique keys to serve as identifiers for edge or vertex tables. See Loading SQL Property Graphs with Composite Keys for more information.