Results of 1 - 10 of about 29 for element (0.007 sec.)
- List Functions 14569
- 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 <->
...e, ...) Alias for list_aggregate . array_aggregate(list, function_name, ...) Alias for list_aggregate . array_append(list, element) Alias for list_append . array_apply(list, lambda(x)) Alias for list_transform . array_cat(list_1, ..., list_n) Alias for...list_concat . array_concat(list_1, ..., list_n) Alias for list_concat . array_contains(list, element) Alias for list_contains . array_distinct(list) Alias for list_distinct . array_extract(list, index) Extracts the index th...er(list, lambda(x)) Alias for list_filter . array_grade_up(list[, col1][, col2]) Alias for list_grade_up . array_has(list, element) Alias for list_contains . array_has_all(list1, list2) Alias for list_has_all . array_has_any(list1, list2) Alias for list... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- JSON Processing Functions 10719
- JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if the string is stored as the JSON logical type. These functions support the same two location notations as
...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...of ARRAY , BIGINT , BOOLEAN , DOUBLE , OBJECT , UBIGINT , VARCHAR and NULL . If path is specified, return the type of the element at the given path . If path is a LIST , the result will be LIST of types. json_valid(json) Return whether json is valid JS...son(json) Parse and minify json . The JSONPointer syntax separates each field with a / . For example, to extract the first element of the array with key duck , you can do: SELECT json_extract('{"duck": [1, 2, 3]}', '/duck/0'); 1 The JSONPath syntax sepa... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
- Indexing 10719
- DuckDB uses 1-based indexing except for JSON objects , which use 0-based indexing. Examples The index origin is 1 for strings, lists, etc. SELECT list[1] AS element FROM (SELECT ['first', 'second', 'third'] AS list); ┌─────────┐ │ element │
...│ varchar │ ├─────────┤ │ first │ └─────────┘ The index origin is 0 for JSON objects. SELECT json[1] AS element FROM (SELECT '["first", "second", "third"]'::JSON AS json); ┌──────────┐ │ element │ │ json │ ├──────────┤ │ "second" │ └─... - https://man.mtool.work/duckdb/2.0/sql/dialect/indexing.html
- Lambda Functions 9919
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...unction to which it is passed. There is always a mandatory parameter that is used by the list function to pass the current element of the list. This is typically the first parameter. There is always an optional parameter used by the list function to pas...s the (1-based) index of the current element. This is always the last parameter. The expression must be a scalar expression. Additionally, it cannot contain a subquery..._filter . list_apply(list, lambda(x)) Alias for list_transform . 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 t... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- Array Type 9381
- An ARRAY column stores fixed-sized arrays. All fields in the column must have the same length and the same underlying type. Arrays are typically used to store arrays of numbers, but can contain any uniform data type, including ARRAY , LIST
..._extract and array_extract . Using the example in Defining an Array Field . The following queries for extracting the first element of an array are equivalent: SELECT id, arr[1] AS element FROM array_table; SELECT id, list_extract(arr, 1) AS element FROM...array_table; SELECT id, array_extract(arr, 1) AS element FROM array_table; id element 10 1 20 4 Using the slicing notation returns a LIST : SELECT id, arr[1:2] AS elements FROM ar...ray_table; id elements 10 [1, 2] 20 [4, 5] Functions All LIST functions work with the ARRAY type. Additionally, several ARRAY -native functions... - https://man.mtool.work/duckdb/2.0/sql/data_types/array.html
- Unnesting 9006
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-element
...lement creates a row, and each element become a column value. Unnesting a STRUCT -typed value creates a column for each member. The member key becomes the column...STRUCT , but in this case the column name is generated based on the (1-based) ordinal position of the member, prefixed by element . The dot-star ( ⟨struct⟩.* ) shorthand syntax is not available for tuples: tuples can only be unnested using the unnest()...value has the effect of duplicating the 'input' row while populating the field corresponding to the unnest() call with the element value. In other words, the original row becomes a repeating group for element unnnested from the LIST -typed value. Conseq... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- Vectors 8516
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...primary array at that index is undefined (and can be uninitialized). The validity mask is a bitmask consisting of uint64_t elements. For every 64 values in the vector, one uint64_t element exists (rounded up). The validity mask has its bit set to 1 if t...method on the struct). However , the struct vector itself does have a validity mask. The reason for this is that the child elements of a struct can be NULL , but the struct itself can also be NULL . Lists Lists are nested types that contain a single chi...db_vector vector ); void duckdb_vector_ensure_validity_writable ( duckdb_vector vector ); void duckdb_vector_assign_string_element ( duckdb_vector vector , idx_t index , const char * str ); void duckdb_vector_assign_string_element_len ( duckdb_vector ve... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Complete API 8402
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...db_vector vector ); void duckdb_vector_ensure_validity_writable ( duckdb_vector vector ); void duckdb_vector_assign_string_element ( duckdb_vector vector , idx_t index , const char * str ); void duckdb_vector_assign_string_element_len ( duckdb_vector ve...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_d...te_struct date ); Parameters date : The year, month and date stored in a duckdb_date_struct . Return Value The duckdb_date element. duckdb_is_finite_date Test a duckdb_date to see if it is a finite value. Syntax bool duckdb_is_finite_date ( duckdb_date... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Python Client API 8402
- 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
...tr , groups : str = '' , window_spec : str = '' , projected_columns : str = '' ) → DuckDBPyRelation Computes the number of elements present in a given expression. Detailed examples can be found at Relational API page . create ( table_name : str ) → None...les can be found at Relational API page . unnest ( * columns : str ) → DuckDBPyRelation Expand list columns to one row per element. Detailed examples can be found at Relational API page . unpivot ( * columns : str , name : str = 'name' , value : str = '...d at Relational API page . value_counts ( expression : str , groups : str = '' ) → DuckDBPyRelation Computes the number of elements present in a given expression, also projecting the original expression. Detailed examples can be found at Relational API... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Types 8272
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...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_d...te_struct date ); Parameters date : The year, month and date stored in a duckdb_date_struct . Return Value The duckdb_date element. duckdb_is_finite_date Test a duckdb_date to see if it is a finite value. Syntax bool duckdb_is_finite_date ( duckdb_date...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_cre... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
DuckDB 2.0 Documentation / man.mtool.work