Results of 1 - 6 of about 6 for Invoke (0.001 sec.)
- CALL Statement 13069
- The CALL statement invokes the given table function and returns the results. Thanks to the FROM -first syntax and the fact that procedures in DuckDB are implemented as table functions, you can use FROM instead of CALL . Examples Invoke the
...duckdb_functions table function: CALL duckdb_functions(); Invoke the pragma_table_info table function: CALL pragma_table_info('pg_am'); Select only the functions where the name starts wit... - https://man.mtool.work/duckdb/2.0/sql/statements/call.html
- Write User Defined Functions 9413
- 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
...hat implements the VScalar trait, registered on a connection with register_scalar_function() . DuckDB calls the function's invoke() once per data chunk, passing a batch of input rows and expecting the corresponding output values written back. signature...arrow::WritableVector, }; struct AddOne; impl VScalar for AddOne { // No per-function state is needed. type State = (); fn invoke( _: &Self::State, input: &mut DataChunkHandle, output: &mut dyn WritableVector, ) -> Result<(), Box<dyn std::error::Error>... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- CSV Auto Detection 8116
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...dateformat %d/%m/%Y TimestampFormat Timestamp Format timestampformat %Y-%m-%dT%H:%M:%S.%f UserArguments Arguments used to invoke sniff_csv (none) sample_size = 1000 Prompt Prompt ready to be used to read the CSV (none) FROM read_csv('my_file.csv', aut... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Lambda Functions 8116
- 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
...ons must be defined inline as argument to the list function. You cannot return a lambda function from a macro (but you can invoke a macro in the lambda's expression). Deprecated Syntax Deprecated DuckDB 1.3 deprecated the old lambda single arrow syntax... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- Unnesting 8116
- 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-e
...as if it is a scalar function. The unnest function may not be called in other contexts where one would normally be able to invoke scalar functions, like the WHERE or ORDER BY clauses. Since DuckDB 2.0, unnest can be used in the GROUP BY clause . When a... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- Command Line Client 7933
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...sql:select current_database()} ⚫◗ " Or a simpler version without colours: .prompt "{sql:select current_database()} ⚫◗ " To invoke that file on initialization, use this command: duckdb -init prompt.sql This outputs: -- Loading resources from prompt.sql... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work