Results of 1 - 4 of about 4 for vertex (0.002 sec.)
- Graph Queries 11077
- 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
...(3, 'Charlie'); INSERT INTO Knows VALUES (1, 2, '2020-01-01'), (2, 3, '2021-06-15'); CREATE PROPERTY GRAPH social_network VERTEX TABLES ( Person ) EDGE TABLES ( Knows SOURCE KEY (person1_id) REFERENCES Person (id) DESTINATION KEY (person2_id) REFERENC...son hops Alice Charlie 2 Graph Algorithms DuckPGQ includes built-in graph algorithms: Function Description pagerank(graph, vertex_label, edge_label) Computes PageRank centrality scores local_clustering_coefficient(graph, vertex_label, edge_label) Measu...res how connected a node's neighbors are weakly_connected_component(graph, vertex_label, edge_label) Identifies connected components Example: FROM pagerank('social_network', 'Person', 'Knows'); Use Case:... - https://man.mtool.work/duckdb/2.0/guides/sql_features/graph_queries.html
- Geometry Data Type 11077
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...used to model shapes in two dimensions (e.g. X / Y or longitude / latitude ), but it also supports shapes with additional vertex dimensions such as Z for elevation or M for "measure", or both. The vertex dimensions of a GEOMETRY value must be consiste...nt across all vertices. For example, if one vertex has X , Y , and Z coordinates, then all other vertices in that geometry must also have X , Y , and Z coordinates. This mea...ns of geometries, such as MULTIPOINT or GEOMETRYCOLLECTION , where all geometries within the collection must have the same vertex dimensions. Functions that operate on GEOMETRY values typically ignore any additional dimensions beyond the X and Y unless... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Spatial Functions 7452
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...a POINT_2D from a WKB encoded blob ST_Point3D Creates a POINT_3D ST_Point4D Creates a POINT_4D ST_PointN Returns the n'th vertex from the input geometry as a point geometry ST_PointOnSurface Returns a point guaranteed to lie on the surface of the geom...interpolating between M values For a POINT and MULTIPOINT, the point is returned if the measure matches the M value of the vertex, otherwise an empty geometry is returned For a POLYGON, only the exterior ring is considered, and treated as a LINESTRING...and end_measure range For LINESTRING or MULTILINESTRING, if a line segment would cross either the upper or lower bound, a vertex is added by interpolating the coordinates at the "intersection" For a POINT and MULTIPOINT, the point is added to the coll... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Vector Similarity Search Extension 7323
- The vss extension is an experimental extension for DuckDB that adds indexing support to accelerate vector similarity search queries using DuckDB's new fixed-size ARRAY type. See the announcement blog post and the “What's New in the Vector S
...index, but will also increase the time it takes to perform a search. M 16 The maximum number of neighbors to keep for each vertex in the graph. A higher value will result in a more accurate index, but will also increase the time it takes to build the i...ndex. M0 2 * M The base connectivity, or the number of neighbors to keep for each vertex in the zero-th level of the graph. A higher value will result in a more accurate index, but will also increase the time it... - https://man.mtool.work/duckdb/2.0/core_extensions/vss.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work