Search Result: hops - DuckDB 2.0 全文検索

Graph Queries 9414: DuckDB supports graph queries via the DuckPGQ community extension , which implements the SQL/PGQ syntax from the SQL:2023 standard. Warning DuckPGQ is a community extension and is still under active development. It may not be available for ... lice Bob 2020-01-01 Bob Charlie 2021-06-15 Path Finding Find paths of variable length using quantifiers like {1,5} (1 to 5 hops) or + (one or more): FROM GRAPH_TABLE (social_network MATCH p = ANY SHORTEST (a:Person)-[k:Knows]->{1,3}(b:Person) WHERE a ... .name = 'Alice' AND b.name = 'Charlie' COLUMNS (a.name AS start_person, b.name AS end_person, path_length(p) AS hops) ); start_person end_person hops Alice Charlie 2 Graph Algorithms DuckPGQ includes built-in graph algorithms: Function Des ...; https://man.mtool.work/duckdb/2.0/guides/sql_features/graph_queries.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work