Results of 1 - 6 of about 6 for candidate (0.002 sec.)
- CSV Auto Detection 13161
- 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
...are copying into will be used instead. The type detection works by attempting to convert the values in each column to the candidate types. If the conversion is unsuccessful, the candidate type is removed from the set of candidate types for that column. A...fter all samples have been handled – the remaining candidate type with the highest priority is chosen. The default set of candidate types is given below, in order of priority: Types N...In flights.csv the FlightDate column will be cast to a DATE , while the other columns will be cast to VARCHAR . The set of candidate types that should be considered by the CSV reader can be specified explicitly using the auto_type_candidates option. VARCH... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- CREATE MACRO Statement 8828
- 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
...a default value expression effectively makes the parameter optional: when the macro is called, the DuckDb binder will find candidate signatures based on passed parameters, but backfilled by signatures that specify default values for missing parameters. A...age example: SELECT add(1, 2) AS x; x 3 However, this fails: SELECT add('hello', 3); Binder Error: Could not choose a best candidate function for the function call "add(STRING_LITERAL, INTEGER_LITERAL)". In order to select one, please add explicit type ca...sts. Candidate functions: add(DATE, INTEGER) -> DATE add(INTEGER, INTEGER) -> INTEGER Macros can have default parameters. b is a default... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Vector Similarity Search Extension 8390
- The vss extension is an experimental extension for DuckDB that adds indexing support to accelerate vector similarity search queries using DuckDB's new fixed-size ARRAY type. See the announcement blog post and the “What's New in the Vector S
...hyperparameters of the index construction and search process: Option Default Description ef_construction 128 The number of candidate vertices to consider during the construction of the index. A higher value will result in a more accurate index, but will a...lso increase the time it takes to build the index. ef_search 64 The number of candidate vertices to consider during the search phase of the index. A higher value will result in a more accurate index, but will a... - https://man.mtool.work/duckdb/2.0/core_extensions/vss.html
- Troubleshooting of Extensions 8390
- You might be visiting this page directed via a DuckDB error message, similar to: INSTALL non_existing; HTTP Error: Failed to download extension "non_existing" at URL "http://extensions.duckdb.org/v2.0.0/osx_arm64/non_existing.duckdb_extensi
...on.gz" (HTTP 404) Candidate extensions: "inet", "encodings", "core_functions", "vortex", "odbc_scanner" For more info, visit https://duckdb.org/docs/c... - https://man.mtool.work/duckdb/2.0/extensions/troubleshooting.html
- WITH Clause 8170
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...entically to UNION ALL . DuckDB 2.0.0 gives the two keywords distinct meanings and supports both: UNION ALL forwards every candidate row to the next iteration, while UNION only forwards new or changed keys. See UNION vs. UNION ALL in USING KEY CTEs . The...in USING KEY CTEs Both UNION and UNION ALL update the union table in the same way: all rows produced by an iteration (the candidates) are applied to the union table, i.e., they insert new keys, overwrite payloads or are combined by the payload aggregates.... The two forms differ in which rows are passed to the next iteration: With UNION ALL , every candidate row produced by the recursive term is forwarded to the next iteration, even if it did not change the union table. With UNI... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
- Iceberg Functions 7841
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...ize of the rewritten files. min_file_size_bytes VARCHAR or integer 75% of the target file size Files smaller than this are candidates for rewriting. max_file_size_bytes VARCHAR or integer 180% of the target file size Files larger than this are candidates...for rewriting. min_input_files BIGINT 5 The minimum number of candidate files (per partition) required to perform a rewrite. max_files_to_rewrite BIGINT NULL (no limit) The maximum number of fil... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work