Results of 1 - 10 of about 11 for implementations (0.002 sec.)
- CREATE MACRO Statement 12945
- 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
...from one another with a comma. Overloading Macros support overloading: A single CREATE MACRO statement can define multiple implementations (sometimes called 'overloads'), each having its own parameter list, AS keyword, and expression. Note that all of the imple...mentations are defined in the same CREATE MACRO statement: it is not possible to add, remove, or alter individual implementations after the macro is created. Multiple implementations are separated from one another by a comma. Each implementation must h...ave a unique parameter-type signature: that is, in one CREATE MACRO statement, all implementations having the same number of parameters must each have a unique sequence of parameter types - regardless of the parameter nam... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Lakehouse Formats 11753
- Lakehouse formats, often referred to as open table formats, are specifications for storing data in object storage while maintaining some guarantees such as ACID transactions or keeping snapshot history. Over time, multiple lakehouse formats
...a lightweight platform for engines to build delta integrations that are as close to native as possible. Tip Why do native implementations matter? Native implementations allow DuckDB to do more performance optimizations such as complex filter pushdowns (with fi... - https://man.mtool.work/duckdb/2.0/lakehouse_formats.html
- Using fsspec Filesystems 9619
- DuckDB support for fsspec filesystems allows querying data in filesystems that DuckDB's httpfs extension does not support. fsspec has a large number of inbuilt filesystems , and there are also many external implementations . This capability
... - https://man.mtool.work/duckdb/2.0/guides/python/filesystems.html
- Numeric Types 8908
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...with N decimal digits requires approximately 0.415 * N + 3 bytes when stored in a BIGNUM . Unlike variable-length integer implementations in other systems, there are limits to BIGNUM : the maximal and minimal representable values are approximately ±4.27e202017...Types The data types FLOAT and DOUBLE precision are variable-precision numeric types. In practice, these types are usually implementations of IEEE Standard 754 for Binary Floating-Point Arithmetic (single and double precision, respectively), to the extent that... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- sqllogictest Introduction 8197
- For testing plain SQL, we use an extended version of the SQL logic test suite, adopted from SQLite . Every test is a single self-contained file located in the test/sql directory. To run tests located outside of the default test directory, s
...cal. Query verification is very useful because it not only discovers bugs in optimizers, but also finds bugs in e.g., join implementations. This is because the unoptimized version will typically run using cross products instead. Because of this, query verificat... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- SQL Quirks 8197
- 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
...ng_agg all return NULL instead of 0 , [] and '' , respectively. This is dictated by the SQL Standard and obeyed by all SQL implementations we know. This behavior is inherited by the list aggregate list_sum , but not by the DuckDB original list_dot_product which... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- Statically Linking Extensions 7948
- This page is for client and binding authors, and for anyone who embeds libduckdb in their own application. It describes how statically linking extensions changed in DuckDB 2.0 and what builders on top of DuckDB need to do. This change is in
...or DuckDB 2.0 and later, most artifacts are distributed as .tar.gz files instead of .zip files ( duckdb#24773 ). Reference Implementations for Clients The following pull requests adapt the official clients to the v2.0 linking model. They provide a path forward... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
- Keywords and Identifiers 7948
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...fiers in DuckDB are always case-insensitive, similarly to PostgreSQL. However, unlike PostgreSQL (and some other major SQL implementations), DuckDB also treats quoted identifiers as case-insensitive. Comparison of identifiers: Case-insensitivity is implemented... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- R-Tree Indexes 7717
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
..., the node will be dissolved and all the entries reinserted from the top of the tree. This is a common operation in R-tree implementations to prevent the tree from becoming too unbalanced. R-Tree Table Functions The rtree_index_dump(VARCHAR) table function can... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Node.js Client (Neo) 7237
- Installation To use the DuckDB Node.js client, visit the Node.js installation page . The latest stable version of the DuckDB Node.js (Neo) client is 2.0.0. An API for using DuckDB in Node.js . The primary package, @duckdb/node-api , is a hi
...zed to JSON, use the JS or Json forms of the above result data methods. Custom converters can be supplied as well. See the implementations of JSDuckDBValueConverter and JsonDuckDBValueConverters for how to do this. Examples (using the Json forms): const reader... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
DuckDB 2.0 Documentation / man.mtool.work