Results of 1 - 10 of about 11 for reduce (0.003 sec.)
- Lambda Functions – DuckDB 14349
- 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
...on's return type to BOOL . The return type of list_filter is the same as the input list's. See list_filter examples . list_reduce(list, lambda(x, y)[, initial_value]) Reduces all elements of the input list into a single scalar value by executing the la...nction on a running result and the next list element. The lambda function has an optional initial_value argument. See list_reduce examples or details. list_transform(list, lambda(x)) Description Returns a list that is the result of applying the lambda..._filter examples . Example list_filter ([ 4 , 5 , 6 ], lambda x : x > 4 ) Result [5, 6] Aliases array_filter , filter list_reduce(list, lambda(x, y)[, initial_value]) Description Reduces all elements of the input list into a single scalar value by exec... - https://man.mtool.work/duckdb/1.3/sql/functions/lambda.html
- Out of Memory Errors – DuckDB 9139
- 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
..., UID:1000 pgtables:1814612kB oom_score_adj:0 Troubleshooting Out of Memory Errors To prevent out of memory errors, try to reduce memory usage. To this end, please consult the “How to Tune Workloads” site . In short: Reduce the number of threads using...a large amount of data, try setting the preserve_insertion_order option to false : SET preserve_insertion_order = false . Reduce the memory limit below the default 80% (see the Limits page ). This can be helpful because some DuckDB operations circumve... - https://man.mtool.work/duckdb/1.3/guides/troubleshooting/oom_errors.html
- SQLSmith Extension – DuckDB 8819
- 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
...INSTALL sqlsmith ; LOAD sqlsmith ; Functions The sqlsmith extension registers the following functions: sqlsmith fuzzyduck reduce_sql_statement fuzz_all_functions 関連キーワード sqlsmith extension functions Documentation Core Extensions Copy Markdown S...QLSmith Extension used testing Installing Loading Functions registers following fuzzyduck reduce statement fuzz 関連するページ ICU Extension Nested Functions Advanced Installation Methods Troubleshooting of Extensions I... - https://man.mtool.work/duckdb/1.3/core_extensions/sqlsmith.html
- List Functions – DuckDB 8819
- 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
...ns the element. If the element is not found, it returns NULL . list_prepend(element, list) Prepends element to list . list_reduce(list, lambda) Returns a single value that is the result of applying the lambda function to each element of the input list....nds element to list . Example list_prepend(3, [4, 5, 6]) Result [3, 4, 5, 6] Aliases array_prepend , array_push_front list_reduce(list, lambda) Description Returns a single value that is the result of applying the lambda function to each element of the...input list. See the Lambda Functions page for more details. Example list_reduce([4, 5, 6], (acc, x) -> acc + x) Result 15 Aliases array_reduce , reduce list_resize(list, size[, value]) Description Resiz... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Tuning Workloads – DuckDB 8410
- 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
...download the data it actually needs. Apply filters on remote parquet files when possible. DuckDB can use these filters to reduce the amount of data that is scanned. Either sort or partition data by columns that are regularly used for filters: this inc...the same database connection many times. Disconnecting and reconnecting on every query will incur some overhead, which can reduce performance when running many small queries. DuckDB also caches some data and metadata in memory, and that cache is lost w... - https://man.mtool.work/duckdb/1.3/guides/performance/how_to_tune_workloads.html
- UNPIVOT Statement – DuckDB 8321
- 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
...tatement has additional flexibility: more than 2 destination columns are supported. This can be useful when the goal is to reduce the extent to which a dataset is pivoted, but not completely stack all pivoted columns. To demonstrate this, the query bel...tatement has additional flexibility: more than 2 destination columns are supported. This can be useful when the goal is to reduce the extent to which a dataset is pivoted, but not completely stack all pivoted columns. To demonstrate this, the query bel... - https://man.mtool.work/duckdb/1.3/sql/statements/unpivot.html
- Text Types – DuckDB 8090
- 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
...NG , and TEXT types is not required and has no effect on the system. Specifying the length will not improve performance or reduce storage space of the strings in the database. These variants variant is supported for compatibility reasons with other sys... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- Schema – DuckDB 8001
- 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
...orrect types for CSV inputs. If you run in a memory-constrained environment, using smaller data types (e.g., TINYINT ) can reduce the amount of memory and disk space required to complete a query. DuckDB's bitpacking compression means small values store... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- Interval Type – DuckDB 8001
- 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
...riod , adds them back together, and confirms that the result is always equal to the original period . SELECT period = list_reduce ( [ INTERVAL ( datepart ( part , period ) || part ) FOR part IN [ 'year' , 'month' , 'day' , 'hour' , 'minute' , 'microsec... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- Samples – DuckDB 8001
- 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
...what the data looks like and what is in the data. Samples allow you to get approximate answers to queries faster, as they reduce the amount of data that needs to pass through the query engine. DuckDB supports three different types of sampling methods:... - https://man.mtool.work/duckdb/1.3/sql/samples.html
DuckDB 1.3 Documentation / man.mtool.work