⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 10 of about 12 for Fallback (0.002 sec.)
Backup Extension Repositories 13690
The core and community extension repositories have backup servers (see duckdb-backup.org ): Repository Primary server Backup server core http://extensions.duckdb.org http://extensions.duckdb-backup.org community http://community-extensions. ... tensions.duckdb-backup.org The backup servers serve byte-identical binaries, so signature checks are unaffected. Automatic Fallback Fallback is automatic: if the primary server is unreachable or returns a 5xx error, INSTALL retries the download from the ... on is needed. A 4xx error (e.g., a non-existent extension) is reported directly, without contacting the backup server. The fallback only applies to the built-in core and community repositories. Repositories set via custom_extension_repository or INSTALL ...
https://man.mtool.work/duckdb/2.0/operations_manual/backup_extension_repositorie...
VACUUM Statement 10683
The VACUUM statement only has basic support in DuckDB and is mostly provided for PostgreSQL-compatibility. Some variants of it, such as when calling for a given column, recompute the distinct statistics (the number of distinct entities) if ... indexes are skipped by checkpoint vacuuming. For such databases, the deprecated vacuum_rebuild_indexes setting provides a fallback: it specifies a maximum table row count up to which the indexes are rebuilt after vacuuming (the default, 0 , disables the ... fallback). It can only be set before the database is started or per database as an ATTACH option. Reclaiming Space The VACUUM state ...
https://man.mtool.work/duckdb/2.0/sql/statements/vacuum.html
Prepared Statements 9675
DuckDB supports prepared statements where parameters are substituted when the query is executed. This can improve readability and is useful for preventing SQL injections . Syntax There are three syntaxes for denoting parameters in prepared ... 0 * 42 : EXECUTE compute; result 420 Supplying an argument overrides the matching variable, while omitted parameters still fall back to theirs: EXECUTE compute(multiplier := 3); result 126 Because the fallback is resolved at execution time, re-executing ... tatement after changing a variable picks up the new value: SET VARIABLE multiplier = 100; EXECUTE compute; result 4200 The fallback applies to named parameters only. Auto-incremented ( ? ) and positional ( $1 ) parameters are matched by position and are ...
https://man.mtool.work/duckdb/2.0/sql/query_syntax/prepared_statements.html
Deploy as Native Image 9498
Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits ... inimal build, with the driver JAR in the current directory: javac -cp duckdb_jdbc-⟨version⟩.jar App.java native-image --no-fallback --enable-native-access=ALL-UNNAMED \ -cp duckdb_jdbc-⟨version⟩.jar:. -o app App --no-fallback makes the build fail outrigh ...
https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
CSV Auto Detection 8507
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 ... n be cast to VARCHAR , therefore, this type has the lowest priority meaning that all columns are converted to VARCHAR as a fallback if they cannot be cast to anything else. In flights.csv the FlightDate column will be cast to a DATE , while the other col ... t should be considered by the CSV reader can be specified explicitly using the auto_type_candidates option. VARCHAR as the fallback type will always be considered as a candidate type whether you specify it or not. Here are all additional candidate types ...
https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
Troubleshoot 8171
Overview This page collects common issues encountered when using the DuckDB Rust client, together with their workarounds. If you run into a problem that is not covered here, search the client's issue tracker on GitHub. Linking against a Sys ... x-universal.tar.gz -C libduckdb export DUCKDB_LIB_DIR=$PWD/libduckdb export DUCKDB_INCLUDE_DIR=$DUCKDB_LIB_DIR export DYLD_FALLBACK_LIBRARY_PATH=$DUCKDB_LIB_DIR # LD_LIBRARY_PATH on Linux cargo build On Linux, use the matching duckdb-shared-libs-linux-am ...
https://man.mtool.work/duckdb/2.0/clients/rust/troubleshoot.html
Configuration 7835
DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi ... t. Skipping writing to the WAL means concurrent commits are blocked while the checkpoint is happening. UBIGINT 100000 auto_fallback_to_full_download Allows automatically falling back to full file downloads when possible. BOOLEAN true autoinstall_extensio ... table row count for rebuilding bound ART indexes when checkpoint vacuum cannot remap their row IDs. 0 disables the rebuild fallback but does not disable index remapping on v2.0 storage. The 'vacuum_rebuild_indexes' ATTACH option overrides this default pe ...
https://man.mtool.work/duckdb/2.0/configuration/overview.html
PostgreSQL Extension and the Secret Manager 7835
User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos ... R PORT DBNAME USER PASSWORD PASSFILE REQUIRE_AUTH CHANNEL_BINDING CONNECT_TIMEOUT CLIENT_ENCODING OPTIONS APPLICATION_NAME FALLBACK_APPLICATION_NAME KEEPALIVES KEEPALIVES_IDLE KEEPALIVES_INTERVAL KEEPALIVES_COUNT TCP_USER_TIMEOUT REPLICATION GSSENCMODE S ...
https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
Reference 7658
This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s ... whoami_meta VARCHAR {} Provider-specific metadata as JSON. quack_loaded_at_us BIGINT Epoch microseconds at extension load Fallback uptime anchor when whoami_started_at is empty. Logging Two log types are registered by the extension. Enable them to debug ...
https://man.mtool.work/duckdb/2.0/quack/reference.html
Dot Commands 7499
Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac ... INUE⟩ Replace the standard prompts .quit Exit this program .read ⟨FILE⟩ Read input from FILE .read_line_version ⟨linenoise/fallback⟩ Set the library used for processing interactive input .render_completion ⟨on/off⟩ Toggle displaying of completion prompts ...
https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
PREV 1 2 NEXT
DuckDB 2.0 Documentation / man.mtool.work