Results of 1 - 10 of about 21 for Computes (0.006 sec.)
- Numeric Functions 14105
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...ions. Name Description @(x) Absolute value. Parentheses are optional if x is a column name. abs(x) Absolute value. acos(x) Computes the inverse cosine of x . acosh(x) Computes the inverse hyperbolic cosine of x . add(x, y) Alias for x + y . asin(x) Compu...tes the inverse sine of x . asinh(x) Computes the inverse hyperbolic sine of x . atan(x) Computes the inverse tangent of x . atanh(x) Computes the inverse hyperbolic ta...ngent of x . atan2(y, x) Computes the inverse tangent of (y, x) . binom(n, k) Computes the binomial coefficient of n and k , i.e., the number of ways to cho... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Relational API 11112
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
..._min Finds the row with the minimum value for a value column and returns the value of that row for an argument column. avg Computes the average of a given expression. bit_and Computes the bitwise AND of all bits present in a given expression. bit_or Comp...utes the bitwise OR of all bits present in a given expression. bit_xor Computes the bitwise XOR of all bits present in a given expression. bitstring_agg Computes a bitstring with bits set for each disti...nct value in a given expression. bool_and Computes the logical AND of all values present in a given expression. bool_or Computes the logical OR of all values present in a gi... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Array Functions 11112
- All LIST functions work with the ARRAY data type . Additionally, several ARRAY -native functions are also supported. Array-Native Functions Function Description array_cosine_distance(array1, array2) Computes the cosine distance between two
.... The arrays can have any size as long as the size is the same for both arguments. array_cosine_similarity(array1, array2) Computes the cosine similarity between two arrays of the same size. The array elements cannot be NULL . The arrays can have any siz...e as long as the size is the same for both arguments. array_cross_product(array, array) Computes the cross product of two arrays of size 3. The array elements cannot be NULL . array_distance(array1, array2) Computes the...for both arguments. array_dot_product(array1, array2) Alias for array_inner_product . array_inner_product(array1, array2) Computes the inner product between two arrays of the same size. The array elements cannot be NULL . The arrays can have any size as... - https://man.mtool.work/duckdb/2.0/sql/functions/array.html
- Python Client API 10266
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
.... avg ( expression : str , groups : str = '' , window_spec : str = '' , projected_columns : str = '' ) → DuckDBPyRelation Computes the average of a given expression. Detailed examples can be found at Relational API page . bit_and ( expression : str , gr...oups : str = '' , window_spec : str = '' , projected_columns : str = '' ) → DuckDBPyRelation Computes the bitwise AND of all bits present in a given expression. Detailed examples can be found at Relational API page . bit_or...( expression : str , groups : str = '' , window_spec : str = '' , projected_columns : str = '' ) → DuckDBPyRelation Computes the bitwise OR of all bits present in a given expression. Detailed examples can be found at Relational API page . bit_xor... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Spatial Functions 8236
- 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
...ert Encodes the X and Y values as the hilbert curve index for a curve covering the given bounding box. ST_InterpolatePoint Computes the closest point on a LINESTRING to a given POINT and returns the interpolated M value of that point. ST_Intersection Ret...ageUnion_Agg Unions a set of geometries while maintaining coverage ST_Envelope_Agg Alias for ST_Extent_Agg . ST_Extent_Agg Computes the minimal-bounding-box polygon containing the set of input geometries ST_Intersection_Agg Computes the intersection of a...set of geometries ST_MemUnion_Agg Computes the union of a set of input geometries. ST_Union_Agg Computes the union of a set of input geometries Macro Functions Funct... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- List Functions 8152
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...erator || . list_contains(list, element) Returns true if the list contains the element. list_cosine_distance(list1, list2) Computes the cosine distance between two same-sized lists. list_cosine_similarity(list1, list2) Computes the cosine similarity betw...te function histogram to the list . list_indexof(list, element) Alias for list_position . list_inner_product(list1, list2) Computes the inner product between two same-sized lists. list_intersect(list1, list2) Returns a list of all the elements that exist...list_negative_dot_product(list1, list2) Alias for list_negative_inner_product . list_negative_inner_product(list1, list2) Computes the negative inner product between two same-sized lists. list_pack(arg, ...) Alias for list_value . list_position(list, el... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- inet Extension 7898
- The inet extension defines the INET data type for storing IPv4 and IPv6 Internet addresses. It supports the CIDR notation for subnet masks (e.g., 198.51.100.0/22 , 2001:db8:3c4d::/48 ). Installing and Loading The inet extension will be tran
...192.168.0.0/16 192.168.0.0 127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3c4d:15::1a2f:1a2b netmask Function Computes the network mask for the address's network. CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.168.1.5/24'), ('127...192.168.1.5/24 192.168.1.0/24 127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3c4d:15::/96 broadcast Function Computes the broadcast address for the address's network. CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.168.1.5/24'),... - https://man.mtool.work/duckdb/2.0/core_extensions/inet.html
- Join Operations 7712
- How to Force a Join Order DuckDB has a cost-based query optimizer, which uses statistics in the base tables (stored in a DuckDB database or Parquet files) to estimate the cardinality of operations. Turn off the Join Order Optimizer To turn
...bles: DROP TABLE IF EXISTS t1; DROP TABLE IF EXISTS t2; Configuring the Join Order Optimizer DuckDB's join order optimizer computes the optimal join order exactly using a dynamic programming algorithm. As the number of tables in a join grows, exact enume... - https://man.mtool.work/duckdb/2.0/guides/performance/join_operations.html
- query and query_table Functions 7712
- The query_table and query functions enable powerful and more dynamic SQL. The query_table function returns the table whose name is specified by its string argument; the query function returns the table obtained by executing the query specif
...e COLUMNS expression , we can write very generic SQL-only macros. For example, below is a custom version of SUMMARIZE that computes the min and max of every column in a table: CREATE OR REPLACE MACRO my_summarize(table_name) AS TABLE SELECT unnest([*COLU... - https://man.mtool.work/duckdb/2.0/guides/sql_features/query_and_query_table_func...
- Window Functions 7712
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...T NULL) ) ignore nulls and do not accept RESPECT NULLS . For example, sum(column) OVER (ORDER BY time) AS cumulativeColumn computes a cumulative sum where rows with a NULL value of column have the same value of cumulativeColumn as the row that precedes t...illustrate various pieces of window function evaluation. The simplest window function is row_number() . This function just computes the 1-based row number within the partition using the query: SELECT "Plant", "Date", row_number() OVER (PARTITION BY "Plan...egate function: SELECT points, sum(points) OVER ( ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS we FROM results; This query computes the sum of each point and the points on either side of it: Notice that at the edge of the partition, there are only two va... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
DuckDB 2.0 Documentation / man.mtool.work