Results of 1 - 7 of about 7 for Distance (0.005 sec.)
- Spatial Functions – DuckDB 12686
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...adian. ST_Boundary Returns the "boundary" of a geometry ST_Buffer Returns a buffer around the input geometry at the target distance ST_BuildArea Creates a polygonal geometry by attemtping to "fill in" the input geometry. ST_Centroid Returns the centroid...1 "covers" geom2 ST_Crosses Returns true if geom1 "crosses" geom2 ST_DWithin Returns if two geometries are within a target distance of each-other ST_DWithin_GEOS Returns if two geometries are within a target distance of each-other ST_DWithin_Spheroid Ret...urns if two POINT_2D's are within a target distance in meters, using an ellipsoidal model of the earths surface ST_Difference Returns the "difference" between two geometries... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Vector Similarity Search Extension – DuckDB 10196
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...NSW ( vec ); The index will then be used to accelerate queries that use an ORDER BY clause evaluating one of the supported distance metric functions against the indexed columns and a constant vector, followed by a LIMIT clause. For example: SELECT * FROM...my_vector_table ORDER BY array_distance ( vec , [ 1 , 2 , 3 ]:: FLOAT [ 3 ]) LIMIT 3 ; Additionally, the overloaded min_by(col, arg, n) can also be accelerated wi...th the HNSW index if the arg argument is a matching distance metric function. This can be used to do quick one-shot nearest neighbor searches. For example, to get the top 3 rows with... - https://man.mtool.work/duckdb/1.3/core_extensions/vss.html
- Array Functions – DuckDB 9742
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...y elements can not be NULL . The arrays can have any size as long as the size is the same for both arguments. array_cosine_distance(array1, array2) Compute the cosine distance between two arrays of the same size. The array elements can not be NULL . The...e any size as long as the size is the same for both arguments. This is equivalent to 1.0 - array_cosine_similarity . array_distance(array1, array2) Compute the distance between two arrays of the same size. The array elements can not be NULL . The arrays..._value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT)) Result 0.9925833 array_cosine_distance(array1, array2) Description Compute the cosine distance between two arrays of the same size. The array elements can not be... - https://man.mtool.work/duckdb/1.3/sql/functions/array.html
- List Functions – DuckDB 8706
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...st contains the element. list_cosine_similarity(list1, list2) Compute the cosine similarity between two lists. list_cosine_distance(list1, list2) Compute the cosine distance between two lists. Equivalent to 1.0 - list_cosine_similarity . list_distance(li...st1, list2) Calculates the Euclidean distance between two points with coordinates given in two inputs lists of equal length. list_distinct(list) Removes all duplicates...e similarity between two lists. Example list_cosine_similarity([1, 2, 3], [1, 2, 5]) Result 0.9759000729485332 list_cosine_distance(list1, list2) Description Compute the cosine distance between two lists. Equivalent to 1.0 - list_cosine_similarity Exampl... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Jupyter Notebooks – DuckDB 7470
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...quet" , "yellow_tripdata_2021-01.parquet" , ) % sqlplot boxplot -- table yellow_tripdata_2021 - 01. parquet -- column trip_distance Install and Load DuckDB httpfs Extension DuckDB's httpfs extension allows Parquet and CSV files to be queried remotely ove...ps --no-execute SELECT * FROM 'https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2021-01.parquet' WHERE trip_distance < 6.3 To create a histogram, call %sqlplot histogram and pass the name of the table, the column to plot, and the number of...defined previously and therefore only plots a subset of the data. % sqlplot histogram -- table short_trips -- column trip_distance -- bins 10 -- with short_trips Summary You now have the ability to alternate between SQL and Pandas in a simple and highly... - https://man.mtool.work/duckdb/1.3/guides/python/jupyter.html
- Text Functions – DuckDB 7415
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...y of two strings using various similarity measures . Name Description damerau_levenshtein(s1, s2) Extension of Levenshtein distance to also include transposition of adjacent characters as an allowed edit operation. In other words, the minimum number of e...string to the other. Characters of different cases (e.g., a and A ) are considered different. hamming(s1, s2) The Hamming distance between to strings, i.e., the number of positions with different characters for two strings of equal length. Strings must...ring to the other. Characters of different cases (e.g., a and A ) are considered different. mismatches(s1, s2) The Hamming distance between to strings, i.e., the number of positions with different characters for two strings of equal length. Strings must... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Window Functions – DuckDB 7361
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...use a frame . Frames are specified as a number of rows on either side ( preceding or following ) of the current row . The distance can be specified as a number of rows , as a range of values using the partition's ordering value and a distance, or as a n...rted if that is desired. Framing Framing specifies a set of rows relative to each row where the function is evaluated. The distance from the current row is given as an expression either PRECEDING or FOLLOWING the current row in the order specified by the...ORDER BY clause in the OVER specification. This distance can either be specified as an integral number of ROWS or GROUPS , or as a RANGE delta expression. It is invalid for a fram... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work