Results of 1 - 10 of about 61 for Parameter (0.005 sec.)
- DuckLake – DuckDB 13756
- 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
...───────┴──────────────────────────┘ 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/1.3/core_extensions/ducklake.html
- Table Functions – DuckDB 12103
- 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
...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/1.3/clients/c/table_functions.html
- Prepared Statements – DuckDB 11654
- 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
...Format Pivot Sitemap Live Demo Documentation / Client APIs / C Copy Markdown Prepared Statements 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 execu...ted many times. Prepared statements are useful to: Easily supply parameters to functions while avoiding string concatenation/SQL injection attacks. Speeding up queries that will be executed many ti... - https://man.mtool.work/duckdb/1.3/clients/c/prepared.html
- Replacement Scans – DuckDB 10059
- 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
...ECT * FROM my_table is executed and my_table does not exist, the replacement 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/1.3/clients/c/replacement_scans.html
- Complete API – DuckDB 9030
- 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
...statement prepared_statement ); idx_t duckdb_nparams ( duckdb_prepared_statement prepared_statement ); const char * duckdb_parameter_name ( duckdb_prepared_statement prepared_statement , idx_t index ); duckdb_type duckdb_param_type ( duckdb_prepared_state...bind_value ( duckdb_prepared_statement prepared_statement , idx_t param_idx , duckdb_value val ); duckdb_state duckdb_bind_parameter_index ( duckdb_prepared_statement prepared_statement , idx_t * param_idx_out , const char * name ); duckdb_state duckdb_bi...on ); void duckdb_scalar_function_set_volatile ( duckdb_scalar_function scalar_function ); void duckdb_scalar_function_add_parameter ( duckdb_scalar_function scalar_function , duckdb_logical_type type ); void duckdb_scalar_function_set_return_type ( duckd... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Map Functions – DuckDB 8798
- 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
...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_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/1.3/sql/functions/map.html
- Python Function API – DuckDB 8581
- 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
...on 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. Here is an example using a Python function that calls a third-party library. import duckdb from duckdb.typing impor...a DuckDB connection. Here is the syntax: import duckdb con = duckdb . connect () con . create_function ( name , function , parameters , return_type ) The create_function method takes the following parameters: name A string representing 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... - https://man.mtool.work/duckdb/1.3/clients/python/function.html
- Reading Multiple Files – DuckDB 8349
- 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
...is only works if the Parquet files have the same schema. You can specify which Parquet files you want to read using a list parameter, glob pattern matching syntax, or a combination of both. List Parameter The read_parquet function can accept a list of fil...enames as the input parameter. Read three Parquet files and treat them as a single table: SELECT * FROM read_parquet ([ 'file1.parquet' , 'file2.parquet...match the glob pattern: SELECT * FROM read_parquet ( 'test/*.parquet' ); List of Globs The glob syntax and the list input parameter can be combined to scan files that meet one of multiple patterns. Read all Parquet files from 2 specific folders. SELECT *... - https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html
- Excel Import – DuckDB 8291
- 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 able to pass options to control the import behavior, you should use the read_xlsx function. One such option is the sheet parameter, which allows specifying the name of the Excel worksheet: SELECT * FROM read_xlsx ( 'test_excel.xlsx' , sheet = 'Sheet1' )...st sheet is loaded if no sheet is specified. Importing a Specific Range To select a specific range of cells, use the range parameter with a string in the format A1:B2 , where A1 is the top-left cell and B2 is the bottom-right cell: SELECT * FROM read_xlsx..., range = 'A5:Z' ); Or skip the first 5 columns SELECT * FROM read_xlsx ( 'test_excel.xlsx' , range = 'E:Z' ); If no range parameter is provided, the range is automatically inferred as the rectangular region of cells between the first row of consecutive n... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_import.html
- Loading JSON – DuckDB 8233
- 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
...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 compression The compression type for the fil...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/1.3/data/json/loading_json.html
DuckDB 1.3 Documentation / man.mtool.work