Results of 1 - 10 of about 24 for prefix (0.002 sec.)
- Extension Repositories 14328
- New Support for custom extension repositories was introduced in DuckDB 2.0. This feature is currently work-in-progress and the syntax may still change. By default, DuckDB installs extensions from its built-in repositories ( core , core_nigh
...host and sign its own extensions and have them install and load just like the built-in ones. A repository is a name, a URL prefix, and one or more RSA public keys that are trusted to sign the extensions served from it. Enabling Custom Repositories Addi...bidden , or from allowed to forbidden . To opt in: SET allow_extension_repositories = 'allowed'; Creating a Repository The prefix can point at anything DuckDB can read: a local path, https , s3 , and so on. CREATE EXTENSION REPOSITORY my_repo WITH PREF...f band. If you would rather not trust the network, you can pass the key directly: CREATE EXTENSION REPOSITORY my_repo WITH PREFIX 'https://extensions.example.org' USING PUBLIC KEY '-----BEGIN PUBLIC KEY----- ...'; Extensions are signed using 2048-bit R... - https://man.mtool.work/duckdb/2.0/extensions/extension_repositories.html
- Iceberg Options 11442
- 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
...ries 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 catalog. MAX_TABLE_STALENESS INTERVAL NULL Pre...arge catalogs. Eager resolution is needed when a Quack client attaches a server whose catalog still has unresolved tables. PREFIX VARCHAR (empty) Path prefix inserted into REST Catalog request URLs after /v1/ , for example /v1/⟨prefix⟩/namespaces/… . C.../catalog identifier. It is normally discovered from the catalog's configuration response; set it explicitly to override. A prefix containing / is split into path components unless ENCODE_ENTIRE_PREFIX is set. NAMESPACE_SEPARATOR VARCHAR 0x1F Separator... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Friendly CLI 9941
- Along with our Friendly SQL , we provide friendly CLI features. Dark/Light Mode The CLI automatically detects whether the terminal is using a dark or light background and adjusts syntax highlighting colors accordingly. The mode can also be
...Dynamic Prompt The default prompt is the following: {max_length:50}{highlight_element:prompt_connect}{setting:connect_name_prefix}{highlight_element:prompt}{setting:current_database_and_schema}{color:reset} D While the session is connected to a remote...database with CONNECT , {setting:connect_name_prefix} shows the remote database's name (or its URI, e.g., quack:localhost , for CONNECT '⟨uri⟩' and -connect ); otherwise it is... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- Execution Format 9624
- Vector is the container format used to store in-memory data during execution. DataChunk is a collection of Vectors, used for instance to represent a column list in a PhysicalProjection operator. Data Flow DuckDB uses a vectorized query exec
...To efficiently store strings, we make use of our string_t class. struct string_t { union { struct { uint32_t length; char prefix[4]; char *ptr; } pointer; struct { uint32_t length; char inlined[12]; } inlined; } value; }; Short strings ( <= 12 bytes )...th is used throughout the functions to avoid having to call strlen and having to continuously check for null-pointers. The prefix is used for comparisons as an early out (when the prefix does not match, we know the strings are not equal and don't need... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- Literal Types 9474
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...xadecimal or binary literals directly. However, strings or string literals in hexadecimal or binary notation with 0x or 0b prefixes respectively, can be cast to integer types, e.g., '0xFF'::INT = 255 or '0b101'::INT = 5 . Other Numeric Literals Non-int...as follows: Underscores are allowed in integer, decimal, hexadecimal and binary notation. Hexadecimal notation uses the 0x prefix and binary notation uses the 0b prefix, as described in the Integer Literals section ; for example, '0xFF'::INTEGER and '0.... For example, SELECT '''' AS s returns ' . To enable some common escape sequences, such as \n for the newline character, prefix a string literal with e (or E ). SELECT e'Hello\nworld' AS msg; ┌──────────────┐ │ msg │ │ varchar │ ├──────────────┤ │ He... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- ATTACH and DETACH Statements 9174
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...hen TYPE is not specified, DuckDB deduces the type from the path in two steps: If the path begins with a recognized scheme prefix followed by a colon, such as sqlite:file.db , postgres:dbname=postgres , or mysql:db=mysql , the scheme determines the typ...e. The prefix must be at least two characters long and must not be followed by // , so URLs such as https://… are not treated as type pr...to native DuckDB storage and disables the path-based deduction described above. If you attach a path that carries a scheme prefix for another engine but also pass TYPE DUCKDB , the prefix is ignored and the statement does not have the intended effect.... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- Secrets Manager 8573
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...e “secret providers” that specify how the secret is created. Secrets can also have an optional scope, which is a file path prefix that the secret applies to. When fetching a secret for a path, the secret scopes are compared to the path, returning the m...atching secret for the path. In the case of multiple matching secrets, the longest prefix is chosen. Creating a Secret Secrets can be created using the CREATE SECRET SQL statement . Secrets can be temporary or pe... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- Connect 8423
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...isible to Native Image's static analysis. To create a DuckDB connection, call DriverManager with the jdbc:duckdb: JDBC URL prefix, like so: import java.sql.Connection; import java.sql.DriverManager; Connection conn = DriverManager.getConnection("jdbc:d...is rejected. See Database Instances and Instance Caching . JDBC URL Syntax A DuckDB JDBC URL consists of the jdbc:duckdb: prefix, an optional database name, and an optional list of options separated by semicolons: jdbc:duckdb:⟨database⟩;⟨key⟩=⟨value⟩;...e a lake exists, it can be opened as the connection's default database by placing the DuckLake path after the jdbc:duckdb: prefix. Tables are then addressed without a catalog prefix and no USE statement is needed: try (Connection conn = DriverManager.g... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Python 8273
- The DuckDB Python package has its own repository at duckdb/duckdb-python and uses nanobind 3 to create Python bindings with DuckDB. Prerequisites This guide assumes: You have a full clone of the DuckDB Python package source, including its g
...n, Deployment → CMake , create a Debug profile: Name: Debug Build type: Debug Generator: Ninja CMake Options: text -DCMAKE_PREFIX_PATH=$CMakeProjectDir$/.venv;$CMAKE_PREFIX_PATH Python Debug Configuration Create a CMake Application run configuration: N... - https://man.mtool.work/duckdb/2.0/dev/building/python.html
- EXPLAIN: Inspect Query Plans 7973
- EXPLAIN SELECT * FROM tbl; The EXPLAIN statement displays the physical plan, i.e., the query plan that will get executed, and is enabled by prepending the query with EXPLAIN . The physical plan is a tree of operators that are executed in a
...he query is not actually executed – therefore, we can only see the estimated cardinality for each operator (shown with a ~ prefix, e.g., ~3 rows ), which is calculated by using the statistics of the base tables and applying heuristics for each operator... - https://man.mtool.work/duckdb/2.0/guides/meta/explain.html
DuckDB 2.0 Documentation / man.mtool.work