Results of 1 - 10 of about 23 for elements (0.006 sec.)
- List Functions – DuckDB 14092
- 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
...xamples ). len(list) Return the length of the list. list_aggregate(list, name) Executes the aggregate function name on the elements of list . See the List Aggregates section for more details. list_any_value(list) Returns the first non-null value in the l...ct(list, index) Extract the index th (1-based) value from the list. list_filter(list, lambda) Constructs a list from those elements of the input list for which the lambda function returns true. See the Lambda Functions page for more details. list_grade_u...espond to the position in the original list instead of the actual values. list_has_all(list, sub-list) Returns true if all elements of sub-list exist in list. list_has_any(list1, list2) Returns true if any elements exist is both lists. list_intersect(lis... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Array Functions – DuckDB 11662
- 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
...ning the argument values. array_cross_product(array1, array2) Compute the cross product of two arrays of size 3. The array elements can not be NULL . array_cosine_similarity(array1, array2) Compute the cosine similarity between two arrays of the same siz...e. The array 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(a...rray1, array2) Compute the cosine distance between two arrays of the same size. The array elements can not be NULL . The arrays can have any size as long as the size is the same for both arguments. This is equivalent to 1... - https://man.mtool.work/duckdb/1.3/sql/functions/array.html
- Lambda Functions – DuckDB 10875
- 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
...eturn type of the lambda function. See list_transform examples . list_filter(list, lambda(x)) Constructs a list from those elements of the input list for which the lambda function returns true . DuckDB must be able to cast the lambda function's return ty...r 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 lambda function on a running result and the next list elemen...s array_transform , apply , list_apply , array_apply list_filter(list, lambda(x)) Description Constructs a list from those elements of the input list for which the lambda function returns true . DuckDB must be able to cast the lambda function's return ty... - https://man.mtool.work/duckdb/1.3/sql/functions/lambda.html
- Aggregate Functions – DuckDB 9551
- 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
...computation of the aggregate. This is typically used in combination with the count aggregate to get the number of distinct elements; but it can be used together with any aggregate function in the system. There are some aggregates that are insensitive to...unts. histogram(arg, boundaries) Returns a MAP of key-value pairs representing the provided upper boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype. A boundary at the largest value of the...datatype is automatically added when elements larger than all provided boundaries appear, see is_histogram_other_bin . Boundaries may be provided, e.g., via equi_width_... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- Samples – DuckDB 9098
- 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
...ed. The sampling methods are described in detail below. Samples require a sample size , which is an indication of how many elements will be sampled from the total population. Samples can either be given as a percentage ( 10% or 10 PERCENT ) or as a fixed...ing technique that selects a random sample by keeping a reservoir of size equal to the sample size, and randomly replacing elements as more elements come in. Reservoir sampling allows us to specify exactly how many elements we want in the resulting sampl...e (by selecting the size of the reservoir). As a result, reservoir sampling always outputs the same amount of elements, unlike system and bernoulli sampling. Reservoir sampling is only recommended for small sample sizes, and is not recommend... - https://man.mtool.work/duckdb/1.3/sql/samples.html
- marimo Notebooks – DuckDB 8562
- 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
...hon values into the query with {} (shown later). In particular, this means your SQL queries can depend on the values of UI elements or other Python values, all part of marimo's dataflow graph. Warning Heads up! If you have user-generated content going in...id , random () AS random_value , FROM range ({ digits.value }) AS t ( i ); SELECT * FROM random_data ; Interacting with UI elements, like a slider, makes your data more tangible. DuckDB-Powered OLAP Analytics in marimo marimo provides several features th...on between Python and SQL Reactive execution that automatically updates dependent cells when queries change Interactive UI elements that can be used to parameterize SQL queries Ability to export notebooks as standalone applications or Python scripts, or... - https://man.mtool.work/duckdb/1.3/guides/python/marimo.html
- Types – DuckDB 8428
- 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
...ate : The date object, as obtained from a DUCKDB_TYPE_DATE column. Return Value The duckdb_date_struct with the decomposed elements. duckdb_to_date Re-compose a duckdb_date from year, month and date ( duckdb_date_struct ). Syntax duckdb_date duckdb_to_da...ime : The time object, as obtained from a DUCKDB_TYPE_TIME column. Return Value The duckdb_time_struct with the decomposed elements. duckdb_create_time_tz Create a duckdb_time_tz object from micros and a timezone offset. Syntax duckdb_time_tz duckdb_crea...e ts object, as obtained from a DUCKDB_TYPE_TIMESTAMP column. Return Value The duckdb_timestamp_struct with the decomposed elements. duckdb_to_timestamp Re-compose a duckdb_timestamp from a duckdb_timestamp_struct. Syntax duckdb_timestamp duckdb_to_times... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Complete API – DuckDB 8043
- 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
...ate : The date object, as obtained from a DUCKDB_TYPE_DATE column. Return Value The duckdb_date_struct with the decomposed elements. duckdb_to_date Re-compose a duckdb_date from year, month and date ( duckdb_date_struct ). Syntax duckdb_date duckdb_to_da...ime : The time object, as obtained from a DUCKDB_TYPE_TIME column. Return Value The duckdb_time_struct with the decomposed elements. duckdb_create_time_tz Create a duckdb_time_tz object from micros and a timezone offset. Syntax duckdb_time_tz duckdb_crea...e ts object, as obtained from a DUCKDB_TYPE_TIMESTAMP column. Return Value The duckdb_timestamp_struct with the decomposed elements. duckdb_to_timestamp Re-compose a duckdb_timestamp from a duckdb_timestamp_struct. Syntax duckdb_timestamp duckdb_to_times... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Values – DuckDB 7842
- 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 union Return Value The union value, or nullptr, if the parameters are invalid. duckdb_get_map_size Returns the number of elements in a MAP value. Syntax idx_t duckdb_get_map_size ( duckdb_value value ); Parameters value : The MAP value. Return Value Th...e number of elements in the map. duckdb_get_map_key Returns the MAP key at index as a duckdb_value. Syntax duckdb_value duckdb_get_map_key ( du...d with duckdb_destroy_value . Syntax duckdb_value duckdb_create_null_value ( ); duckdb_get_list_size Returns the number of elements in a LIST value. Syntax idx_t duckdb_get_list_size ( duckdb_value value ); Parameters value : The LIST value. Return Value... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- JSON Processing Functions – DuckDB 7842
- 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
...ocations within JSON: JSON Pointer and JSONPath. Function Description json_array_length(json[, path]) Return the number of elements in the JSON array json , or 0 if it is not a JSON array. If path is specified, return the number of elements in the JSON a...T json_extract ( '{"duck": [1, 2, 3]}' , '/duck/0' ); 1 The JSONPath syntax separates fields with a . , and accesses array elements with [i] , and always starts with $ . Using the same example, we can do the following: SELECT json_extract ( '{"duck": [1,... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
DuckDB 1.3 Documentation / man.mtool.work