Results of 1 - 10 of about 42 for Compatibility (0.002 sec.)
- Storage Versions and Format 15855
- Compatibility Backward Compatibility Backward compatibility refers to the ability of a newer DuckDB version to read storage files created by an older DuckDB version. Version 0.10 is the first release of DuckDB that supports backward compatibility
...without having to worry about which version the file was written with or having to convert files between versions. Forward Compatibility Forward compatibility refers to the ability of an older DuckDB version to read storage files produced by a newer DuckDB ve...is partially forward compatible with DuckDB 0.10 . Certain files created by DuckDB 0.10 can be read by DuckDB 0.9. Forward compatibility is provided on a best effort basis. While stability of the storage format is important – there are still many improvements...and innovations that we want to make to the storage format in the future. As such, forward compatibility may be (partially) broken on occasion. Warning DuckDB versions before 2.0 cannot read database files that use the v2.0.0 s... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- Extension Distribution 10854
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...example, for the Python client, see the Loading and Installing Extensions section in the Python API documentation . Binary Compatibility To avoid binary compatibility issues, the binary extensions distributed by DuckDB are tied both to a specific DuckDB versi...on and a platform . This means that DuckDB can automatically detect binary compatibility between it and a loadable extension. When trying to load an extension that was compiled for a different version or platfor...m, DuckDB will throw an error and refuse to load the extension. DuckDB stores this compatibility information in a metadata footer appended to the end of the extension binary. Warning Do not run strip on an extension bin... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Configuration 10358
- 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
...NSACTION delim_join_as_cte Rewrite delim joins to materialized CTEs during dependent join flattening. BOOLEAN true dialect_compatibility_mode Enable SQL dialect compatibility for a certain engine, e.g., SET dialect_compatibility_mode='spark' . VARCHAR NONE di...of row group metadata on a column-level when checkpointing on older storage versions 6 and 7. This breaks storage backward-compatibility with older DuckDB versions. BOOLEAN false force_compression Forces the usage of a specific compression method. VARCHAR aut...p open before flushing to disk when writing using PARTITION_BY . UBIGINT 100 password The password to use. Kept for legacy compatibility. VARCHAR perfect_ht_threshold Threshold in bytes for when to use a perfect hash table. UBIGINT 12 pin_threads Whether to p... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Text Types 9104
- In DuckDB, strings can be stored in the VARCHAR field. The field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Name Aliases Description VARCHAR CHAR , BPCHAR , STRING , TEXT Variable-length character string
...HAR(n) , STRING(n) , TEXT(n) Variable-length character string. The maximum length n has no effect and is only provided for compatibility Specifying a Length Limit Specifying the length for the VARCHAR , STRING and TEXT types is not required and has no effect...ngth will not improve performance or reduce storage space of the strings in the database. These variants are supported for compatibility with other systems that do require a length to be specified for strings. If you wish to restrict the number of characters... - https://man.mtool.work/duckdb/2.0/sql/data_types/text.html
- List Type 8345
- A LIST column encodes lists of values. Fields in the column can have values with different lengths, but they must all have the same underlying type. LIST s are typically used to store arrays of numbers, but can contain any uniform data type
...imilar to PostgreSQL's ARRAY type. DuckDB uses the LIST terminology, but some array_ functions are provided for PostgreSQL compatibility. See the data types overview for a comparison between nested data types. For storing fixed-length lists, DuckDB uses the A...slicing notation, or through list functions like list_extract . Multiple equivalent functions are provided as aliases for compatibility with systems that refer to lists as arrays. For example, the function array_slice . Example Result SELECT ['a', 'b', 'c'][... - https://man.mtool.work/duckdb/2.0/sql/data_types/list.html
- DuckLake 8221
- 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
...le_name , files_processed and files_created . Parameter name Parameter type Named parameter Description catalog VARCHAR no Compatibility Matrix The DuckLake specification and the ducklake DuckDB extension are currently released together. See the Compatibility... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- Cloudflare R2 Import 8221
- Prerequisites For Cloudflare R2, the S3 Compatibility API allows you to use DuckDB's S3 support to read and write from R2 buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only needs to
... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/cloudflare_r2_imp...
- SQL Quirks 8221
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...fically to PostgreSQL's dialect (see the “PostgreSQL Compatibility” page for exceptions). The rest may simply come down to different preferences, or we may even agree on what should be done...INT8 corresponds to BIGINT (8 bytes). Expressions Results That May Surprise You Expression Result Note -2^2 4.0 PostgreSQL compatibility means the unary minus has higher precedence than the exponentiation operator. Use additional parentheses, e.g., -(2^2) or... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- PREPARE, EXECUTE, and DEALLOCATE Statements 8221
- The PREPARE statement creates a prepared statement for later execution. The EXECUTE statement runs it with optional arguments. The DEALLOCATE statement removes it. For details about auto-incremented, positional, and named parameters, see Pr
...x DEALLOCATE Remove a prepared statement: DEALLOCATE query_person; The optional PREPARE keyword is accepted for PostgreSQL compatibility: DEALLOCATE PREPARE add_values; Syntax... - https://man.mtool.work/duckdb/2.0/sql/statements/prepare.html
- List Tables 7974
- The SHOW TABLES command can be used to obtain a list of all tables within the selected schema. CREATE TABLE tbl (i INTEGER); SHOW TABLES; name tbl SHOW or SHOW ALL TABLES can be used to obtain a list of all tables within all attached databa
...mation_schema views are also defined. Moreover, DuckDB defines sqlite_master and many PostgreSQL system catalog tables for compatibility with SQLite and PostgreSQL respectively.... - https://man.mtool.work/duckdb/2.0/guides/meta/list_tables.html
DuckDB 2.0 Documentation / man.mtool.work