Results of 1 - 10 of about 11 for slice (0.005 sec.)
- List Functions 13443
- 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 <->
...everse_sort(list[, col1]) Alias for list_reverse_sort . array_select(value_list, index_list) Alias for list_select . array_slice(list, begin, end) Alias for list_slice . array_slice(list, begin, end, step) Alias for list_slice . array_sort(list[, col1...t) Applies aggregate function sem to the list . list_skewness(list) Applies aggregate function skewness to the list . list_slice(list, begin, end) Extracts a sublist or substring using slice conventions . Negative values are accepted. list_slice(list,...begin, end, step) list_slice with added step feature. list_sort(list[, col1][, col2]) Sorts the elements of the list. See the Sorting Lists section for... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Write User Defined Functions 11149
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...ng defines add_one(BIGINT) -> BIGINT , adapted from the crate's vscalar example . It reads the single BIGINT argument as a slice of i64 and writes each result into the output vector: use duckdb::{ Connection, Result, core::{DataChunkHandle, LogicalTyp...Result<(), Box<dyn std::error::Error>> { let len = input.len(); let src = input.flat_vector(0); let src = unsafe { src.as_slice_with_len::<i64>(len) }; let mut out = output.flat_vector(); let dst = unsafe { out.as_mut_slice_with_len::<i64>(len) }; fo...State holds any per-function state shared across calls; use () when none is needed. The example reads its input as a typed slice for brevity and assumes non-null input; a production function should also check each value's validity. This feature requir... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Text Functions 9371
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...string using slice conventions similar to Python. Missing begin or end arguments are interpreted as the beginning or end of the list respecti...ist1, list2, ...) . array_extract(string, index) Extracts a single character from a string using a (1-based) index . array_slice(list, begin, end) Extracts a sublist or substring using slice conventions . Negative values are accepted. ascii(string) Re...Example | 'DuckDB'[4] | | Result | k | | Alias | array_extract | string[begin:end] | Description | Extracts a string using slice conventions similar to Python. Missing begin or end arguments are interpreted as the beginning or end of the list respecti... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Vectors 8659
- 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
...( duckdb_vector vector , idx_t index ); duckdb_vector duckdb_array_vector_get_child ( duckdb_vector vector ); void duckdb_slice_vector ( duckdb_vector vector , duckdb_selection_vector sel , idx_t len ); void duckdb_vector_copy_sel ( duckdb_vector src...uckdb_array_vector_get_child ( duckdb_vector vector ); Parameters vector : The vector Return Value The child vector duckdb_slice_vector Slice a vector with a selection vector. The length of the selection vector must be less than or equal to the length...of the vector. Turns the vector into a dictionary vector. Syntax void duckdb_slice_vector ( duckdb_vector vector , duckdb_selection_vector sel , idx_t len ); Parameters vector : The vector to slice. sel :... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Run Queries 8659
- Overview A Connection runs SQL through two families of methods: The execute_* methods ( execute() and execute_batch() ) send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. The query_* meth
...ch as INSERT or UPDATE . It takes the SQL and a list of parameters, and returns the number of affected rows. Pass an empty slice [] when there are no parameters: conn.execute( "CREATE TABLE person (id INTEGER, name TEXT, data BLOB)", [], )?; let rows_...nal ( ? ) and numbered ( ?1 , ?2 ) placeholders. The params! macro packs a heterogeneous list of values into the parameter slice: use duckdb::params; conn.execute( "INSERT INTO person (id, name, data) VALUES (?, ?, ?)", params![1, "Steven", None::<Vec..., and any value read out of a row implements FromSql . The crate provides both for the standard Rust numeric, string, byte-slice, and boolean types. Option<T> maps to and from SQL NULL , so None binds as NULL and a NULL result reads back as None . War... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
- List Type 8304
- A LIST column encodes lists of values. Fields in the column can have values with different lengths, but they must all have the same underlying type. LIST s are typically used to store arrays of numbers, but can contain any uniform data type
...ions are provided as aliases for compatibility with systems that refer to lists as arrays. For example, the function array_slice . Example Result SELECT ['a', 'b', 'c'][3] 'c' SELECT ['a', 'b', 'c'][-1] 'c' SELECT ['a', 'b', 'c'][2 + 1] 'c' SELECT lis...T ['a', 'b', 'c'][1:2] ['a', 'b'] SELECT ['a', 'b', 'c'][:2] ['a', 'b'] SELECT ['a', 'b', 'c'][-2:] ['b', 'c'] SELECT list_slice(['a', 'b', 'c'], 2, 3) ['b', 'c'] Comparison and Ordering The LIST type can be compared using all the comparison operators... - https://man.mtool.work/duckdb/2.0/sql/data_types/list.html
- Run Queries 7948
- Overview Because the Go client implements database/sql , queries run through the standard methods: Exec and ExecContext send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. Query , QueryCon
....Fatal(err) } When the column set is not known ahead of time, rows.Columns() returns the column names, and scanning into a slice of any reads each column into a driver.Value . Remember that a scanned value can be nil for a SQL NULL . Reading Nested an...e Go type parameter to match the SQL shape, then read the decoded value with Get() : // A JSON (or LIST) value read into a slice. var arr duckdb.Composite[[]any] row := db.QueryRow(`SELECT json_array('foo', 'bar')`) if err := row.Scan(&arr); err != ni... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- Profile and Monitor 7592
- Overview The Go client can observe query execution: it can retrieve per-operator profiling metrics after a query runs, and register a log storage that receives DuckDB's log messages. Both are described below. Profiling Profiling information
...rofilingInfo , a tree that mirrors DuckDB's query plan. Each node has a Metrics map of metric name to value and a Children slice of child nodes. Metrics are grouped and named in lowercase: the root's children are the root plan operator, whose metrics... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- Complete API 7503
- 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
...( duckdb_vector vector , idx_t index ); duckdb_vector duckdb_array_vector_get_child ( duckdb_vector vector ); void duckdb_slice_vector ( duckdb_vector vector , duckdb_selection_vector sel , idx_t len ); void duckdb_vector_copy_sel ( duckdb_vector src...uckdb_array_vector_get_child ( duckdb_vector vector ); Parameters vector : The vector Return Value The child vector duckdb_slice_vector Slice a vector with a selection vector. The length of the selection vector must be less than or equal to the length...of the vector. Turns the vector into a dictionary vector. Syntax void duckdb_slice_vector ( duckdb_vector vector , duckdb_selection_vector sel , idx_t len ); Parameters vector : The vector to slice. sel :... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Data Chunks 7503
- Data chunks represent a horizontal slice of a table. They hold a number of vectors , that can each hold up to the VECTOR_SIZE rows. The vector size can be obtained through the duckdb_vector_size function and is configurable, but is usually
... - https://man.mtool.work/duckdb/2.0/clients/c/data_chunk.html
DuckDB 2.0 Documentation / man.mtool.work