Results of 1 - 10 of about 94 for parameter (0.002 sec.)
- DuckLake 12538
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...──────────────┴───────────────────┘ ducklake_snapshots Returns the snapshots stored in the DuckLake catalog name catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a table with the follow...ble_info The ducklake_table_info function returns information on the tables stored in the DuckLake catalog named catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a table with the follow...ion has two variants, depending on whether start_snapshot and end_snapshot have types BIGINT or TIMESTAMP WITH TIME ZONE . Parameter name Parameter type Named parameter Description catalog VARCHAR no schema_name VARCHAR no table_name VARCHAR no start_snap... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- CREATE MACRO Statement 12301
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...by passing values to its parameters; this causes its expression to be evaluated, yielding a value. Depending on the macro type, the value may be scalar, or a...CRO . The simplified syntax for creating a macro is: CREATE [OR REPLACE] [TEMPORARY] MACRO [IF NOT EXISTS] ⟨identifier⟩( [⟨parameters⟩] ) AS [TABLE] ⟨expression⟩; The identifier consists of the macro's name, which can be any valid SQL identifier. A macro...LACE or the IF NOT EXISTS clause may be present, but not both. The macro name is followed by parentheses. If the macro has parameters , then they must be declared within the parentheses. The AS keyword appears after the right parenthesis but before the ex... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Table Functions 11034
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...uckdb_table_function_set_name ( duckdb_table_function table_function , const char * name ); void duckdb_table_function_add_parameter ( duckdb_table_function table_function , duckdb_logical_type type ); void duckdb_table_function_add_named_parameter ( duck...kdb_bind_add_result_column ( duckdb_bind_info info , const char * name , duckdb_logical_type type ); idx_t duckdb_bind_get_parameter_count ( duckdb_bind_info info ); duckdb_value duckdb_bind_get_parameter ( duckdb_bind_info info , idx_t index ); duckdb_va...lue duckdb_bind_get_named_parameter ( duckdb_bind_info info , const char * name ); void duckdb_bind_set_bind_data ( duckdb_bind_info info , void * bind_data ,... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Prepared Statements 10493
- A prepared statement is a parameterized query. The query is prepared with question marks ( ? ) or dollar symbols ( $1 ) indicating the parameters of the query. Values can then be bound to these parameters, after which the prepared statement
...can be executed using those parameters. A single query can be prepared once and executed many times. Prepared statements are useful to: Easily supply parameters...e avoiding string concatenation/SQL injection attacks. Speeding up queries that will be executed many times with different parameters. DuckDB supports prepared statements in the C API with the duckdb_prepare method. The duckdb_bind family of functions is..."INSERT INTO integers VALUES ($1, $2)", &stmt) == DuckDBError) { // handle error } duckdb_bind_int32(stmt, 1, 42); // the parameter index starts counting at 1! duckdb_bind_int32(stmt, 2, 43); // NULL as second parameter means no result set is requested d... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
- Replacement Scans 10400
- The replacement scan API can be used to register a callback that is called when a table is read that does not exist in the catalog. For example, when a query such as SELECT * FROM my_table is executed and my_table does not exist, the replac
...ement scan callback will be called with my_table as parameter. The replacement scan can then insert a table function with a specific parameter to replace the read of the table. API Ref...can_set_function_name ( duckdb_replacement_scan_info info , const char * function_name ); void duckdb_replacement_scan_add_parameter ( duckdb_replacement_scan_info info , duckdb_value parameter ); void duckdb_replacement_scan_set_error ( duckdb_replacemen..._database db , duckdb_replacement_callback_t replacement , void * extra_data , duckdb_delete_callback_t delete_callback ); Parameters db : The database object to add the replacement scan to replacement : The replacement scan callback extra_data : Extra da... - https://man.mtool.work/duckdb/2.0/clients/c/replacement_scans.html
- Iceberg Options 9516
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...wn to the system, you'll need to use the ATTACH statement. The options provided to the ATTACH are divided into categories: Parameter Type Default Description URI VARCHAR NULL URL of the REST Catalog endpoint. In DuckDB 2.0, URI is the canonical option nam...ction will not be cleaned up on ROLLBACK or retries of the COMMIT . PURGE_REQUESTED BOOLEAN false Sends the PurgeRequested parameter when dropping a table. ENCODE_ENTIRE_PREFIX BOOLEAN false URL-encode the entire path prefix when communicating with the ca...d in the catalog's response. Useful when the embedded metadata omits properties such as schema.name-mapping.default . Some parameters enable others, see the list of associated additional parameters below this table. Parameter Type Default Accepted options... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Loading JSON 7958
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
...filename can also be a list of files or a glob pattern. read_ndjson_objects(filename) Alias for read_json_objects with the parameter format set to newline_delimited . read_json_objects_auto(filename) Alias for read_json_objects with the parameter format s...et to auto . Parameters These functions have the following parameters: Name Description Type Default allow_empty If the file pattern or file list...r auto-detection. BIGINT 32 maximum_object_size The maximum size of a JSON object (in bytes). UINTEGER 16777216 The format parameter specifies how to read the JSON from a file. With unstructured , the top-level JSON is read, e.g., for birds.json : { "duck... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
- Map Functions 7958
- Name Description cardinality(map) Return the size of the map (or the number of entries in the map). element_at(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the ke
...y provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_concat(maps...) Returns a map created from merging th...a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_extract_value(map, key) Returns the value for a given...key or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_from_entries(STRUCT(k, v)[]) Returns a map created fr... - https://man.mtool.work/duckdb/2.0/sql/functions/map.html
- Python Function API 7866
- You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth
...eption: 'numpy' is required for this operation, but it wasn't installed . The signature is create_function(name, function, parameters=None, return_type=None, *, type=..., null_handling=..., exception_handling=..., side_effects=False) . The last four param...ting the unique name of the UDF within the connection catalog. function The Python function you wish to register as a UDF. parameters Scalar functions can operate on one or more columns. This parameter takes a list of column types used as input. return_ty...pe Scalar functions return one element per row. This parameter specifies the return type of the function. type (optional): DuckDB supports both native Python types and PyArrow Arrays. B... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- Lambda Functions 7866
- 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
...ilter: if it evaluates to true , the column is retained, and discarded otherwise. COLUMNS -clause lambdas have a mandatory parameter that receives the column name. Optionally, a second parameter may be declared that receives the (1-based) column index. Th...e syntax for a lambda expression is: lambda ⟨parameters⟩ : ⟨expression⟩ ⟨parameters⟩ is a comma-separated list of parameter names. Parameters may be given any name, and their na...me may be referenced in the ⟨expression⟩ . The number of allowed and required parameters depends on the list function to which it is passed. There is always a mandatory parameter that is used by the list functi... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
DuckDB 2.0 Documentation / man.mtool.work