Results of 1 - 10 of about 21 for minimum (0.012 sec.)
- Spatial Functions – DuckDB 12093
- 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
...ries and their "path" in the original geometry. ST_EndPoint Returns the end point of a LINESTRING. ST_Envelope Returns the minimum bounding rectangle of a geometry as a polygon geometry ST_Equals Returns true if the geometries are "equal" ST_Extent Retu..._M Returns the M coordinate of a point geometry ST_MMax Returns the maximum M coordinate of a geometry ST_MMin Returns the minimum M coordinate of a geometry ST_MakeEnvelope Create a rectangular polygon from min/max coordinates ST_MakeLine Create a LINE...etry ST_MaximumInscribedCircle Returns the maximum inscribed circle of the input geometry, optionally with a tolerance. ST_MinimumRotatedRectangle Returns the minimum rotated rectangle that bounds the input geometry, finding the surrounding box that has... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Aggregate Functions – DuckDB 11839
- 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
...expression evaluates to NULL are ignored. This function is affected by ordering . arg_min(arg, val) Finds the row with the minimum val and calculates the arg expression at that row. Rows where the value of the arg or val expression is NULL are ignored....om" n rows ordered by val ascending. This function is affected by ordering . arg_min_null(arg, val) Finds the row with the minimum val and calculates the arg expression at that row. Rows where the val expression evaluates to NULL are ignored. This funct...val, n) Returns a LIST containing the arg expressions for the "top" n rows ordered by val descending. min(arg) Returns the minimum value present in arg . This function is unaffected by distinctness . min(arg, n) Returns a LIST containing the arg values... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- R-Tree Indexes – DuckDB 11315
- 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
...queries significantly. How Do R-Tree Indexes Work? An R-tree is a balanced tree data structure that stores the approximate minimum bounding rectangle of each geometry (and the internal ID of the corresponding row) in the leaf nodes, and the bounding rec...tangle enclosing all of the child nodes in each internal node. The minimum bounding rectangle (MBR) of a geometry is the smallest rectangle that completely encloses the geometry. Usually when we ta...lk about the bounding rectangle of a geometry (or the bounding "box" in the context of 2D geometry), we mean the minimum bounding rectangle. Additionally, we tend to assume that bounding boxes/rectangles are axis-aligned, i.e., the rectangle i... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
- Parquet Tips – DuckDB 10537
- 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
...est.parquet' ( FORMAT parquet , PER_THREAD_OUTPUT ); Selecting a ROW_GROUP_SIZE The ROW_GROUP_SIZE parameter specifies the minimum number of rows in a Parquet row group, with a minimum value equal to DuckDB's vector size, 2,048, and a default of 122,880...files Files Tips union read thread generate series size query tips used different columns good multiple improve parameter minimum rows 関連するページ File Formats Parquet Export Parquet Import Querying Parquet Files Querying Parquet Metadata Reading an... - https://man.mtool.work/duckdb/1.3/data/parquet/tips.html
- Text Functions – DuckDB 9488
- 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
...evenshtein distance to also include transposition of adjacent characters as an allowed edit operation. In other words, the minimum number of edit operations (insertions, deletions, substitutions or transpositions) required to change one string to anothe...r. Characters of different cases (e.g., a and A ) are considered different. editdist3(s1, s2) The minimum number of single-character edits (insertions, deletions or substitutions) required to change one string to the other. Char...etween 0 and 1. For similarity < score_cutoff , 0 is returned instead. score_cutoff defaults to 0. levenshtein(s1, s2) The minimum number of single-character edits (insertions, deletions or substitutions) required to change one string to the other. Char... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Window Functions – DuckDB 9234
- 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
...t can be shared between multiple window functions: SELECT "Plant" , "Date" , min ( "MWh" ) OVER seven AS "MWh 7-day Moving Minimum" , avg ( "MWh" ) OVER seven AS "MWh 7-day Moving Average" , max ( "MWh" ) OVER seven AS "MWh 7-day Moving Maximum" FROM "G...n the same WINDOW clause by comma-separating them: SELECT "Plant" , "Date" , min ( "MWh" ) OVER seven AS "MWh 7-day Moving Minimum" , avg ( "MWh" ) OVER seven AS "MWh 7-day Moving Average" , max ( "MWh" ) OVER seven AS "MWh 7-day Moving Maximum" , min (..."MWh" ) OVER three AS "MWh 3-day Moving Minimum" , avg ( "MWh" ) OVER three AS "MWh 3-day Moving Average" , max ( "MWh" ) OVER three AS "MWh 3-day Moving Maximum" FROM "G... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- Prepared Statements – DuckDB 8964
- 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
.... For example: PREPARE query_person AS SELECT * FROM person WHERE starts_with ( name , $ name_start_letter ) AND age >= $ minimum_age ; Using the CLI client, the statement is executed as follows. EXECUTE query_person ( name_start_letter : = 'B' , minim... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/prepared_statements.html
- Environment – DuckDB 8710
- 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
...iently on both AMD64 (x86_64) and ARM64 (AArch64) CPU architectures. Memory Bestpractice Aim for 1-4 GB memory per thread. Minimum Required Memory As a rule of thumb, DuckDB requires a minimum of 125 MB of memory per thread. For example, if you use 8 th... - https://man.mtool.work/duckdb/1.3/guides/performance/environment.html
- Subqueries – DuckDB 8456
- 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
...AR ); INSERT INTO grades VALUES ( 7 , 'Math' ), ( 9 , 'Math' ), ( 8 , 'CS' ); We can run the following query to obtain the minimum grade: SELECT min ( grade ) FROM grades ; min(grade) 7 By using a scalar subquery in the WHERE clause, we can figure out f...subquery is a function that is applied to every row in the source data set. For example, suppose that we want to find the minimum grade for every course. We could do that as follows: SELECT * FROM grades grades_parent WHERE grade = ( SELECT min ( grade... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
- Relational API – DuckDB 8186
- 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
...e maximum value for a value column and returns the value of that row for an argument column arg_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 on a given colu...omputes the average on a given column median Computes the median over all values present in a given column min Returns the minimum value present in a given column mode Computes the mode over all values present in a given column n_tile Divides the partit..._spec : str = '' , projected_columns : str = '' ) -> duckdb . duckdb . DuckDBPyRelation Description Finds the row with the minimum value for a value column and returns the value of that row for an argument column Parameters arg_column : str The column n... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
DuckDB 1.3 Documentation / man.mtool.work