Results of 1 - 10 of about 30 for runtime (0.001 sec.)
- Typecasting 12834
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...plicitly (with CAST or :: ); an empty cell marks an unsupported cast. Even where a cast is supported, it may still fail at runtime for a particular value (for example, out of range or unparseable input). Column abbreviations: BOOL (BOOLEAN), I8 (TINYINT...Even though a casting operation is supported based on the source and target data type, a cast operation may still fail at runtime if it would result in an invalid target value, for example due to overflows . Deprecated Prior to version 0.10.0, DuckDB a...s too large to be represented by the TINYINT data type. Therefore, an attempt to cast that value to that type results in a runtime error: SELECT CAST(999 AS TINYINT); Conversion Error: Type INT32 with value 999 can't be cast because the value is out of... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- S3 Express One 12135
- In late 2023, AWS announced the S3 Express One Zone , a high-speed variant of traditional S3 buckets. DuckDB can read S3 Express One buckets using the httpfs extension . Credentials and Configuration The configuration of S3 Express One buck
...F300 Comments creationDate Parquet file (also used in the microbenchmarks of the performance guide ). Experiment File size Runtime Loading only from Parquet 4.1 GB 3.5 s Creating local table from Parquet 4.1 GB 5.1 s The “loading only” variant is runnin...g the load as part of an EXPLAIN ANALYZE statement to measure the runtime without actually creating a local table, while the “creating local table” variant uses CREATE TABLE ... AS SELECT to creat... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
- PEG Parser 10722
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...ser. Further Reading “A Preview of DuckDB v2.0” blog post “DuckDB v2.0: Your Database Deserves a Better Parser” blog post “Runtime-Extensible SQL Parsers Using PEG” blog post “Runtime-Extensible Parsers” (CIDR 2025 paper) by Hannes Mühleisen and Mark Ra... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- Deploy 9682
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...loy it in one of three ways: Bundled together with your application Served from a same-origin (sub-)domain and included at runtime Served from a third-party CDN such as jsDelivr It cannot be served as-is: it requires transpilation, because it needs to k...ndbox. Further Reading Instantiate — how the library, worker, and WebAssembly components served here are wired together at runtime. Load Extensions — how extensions are fetched, signed, and served from a custom repository. Extension Distribution — gener... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- Statically Linking Extensions 9325
- 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
...statically linked extensions before any database can be opened if (duckdb_register_static_extensions() != 0) { throw std::runtime_error("Failed to register the statically linked DuckDB extensions"); } If registration is skipped, the linked extensions (...such as core_functions , icu , json , and parquet ) are not loaded. Queries that depend on them then fail at runtime. For example, SELECT to_minutes(5) reports that the function exists in the core_functions extension, even though that exte... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
- jemalloc 9325
- On supported platforms, DuckDB replaces the system's memory allocator with jemalloc . jemalloc is statically linked into DuckDB and cannot be installed or loaded during runtime. For technical reasons, we used to distribute jemalloc as an ex
... - https://man.mtool.work/duckdb/2.0/internals/jemalloc.html
- PostgreSQL Extension Functions 8984
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...for the specified attached database. It also allows to list the current effective configuration options and the collected runtime statistics of a connection pool. Parameters catalog_name ( VARCHAR ): the name (alias) of the attached Postgres database t...s used to check that the connection is healthy Examples List the current effective configuration options and the collected runtime statistics of all connections pools (for all attached databases): FROM postgres_configure_pool() Change one or more config... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Text Types 8984
- 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
...N zstd); Text Type Values Values of the text type are character strings, also known as string values or simply strings. At runtime, string values are constructed in one of the following ways: referencing columns whose declared or implied type is the tex... - https://man.mtool.work/duckdb/2.0/sql/data_types/text.html
- EXPLAIN ANALYZE: Profile Queries 8626
- Prepending a query with EXPLAIN ANALYZE both pretty-prints the query plan, and executes it, providing run-time performance numbers and the actual cardinality (number of rows produced) for every operator. EXPLAIN ANALYZE SELECT * FROM tbl; N
...ent in it. Scan operators also show the number of row groups scanned and any dynamic filters that were pushed into them at runtime, e.g., by the hash join. See Also For more information, see the ”Profiling” page .... - https://man.mtool.work/duckdb/2.0/guides/meta/explain_analyze.html
- Requirements 8626
- DuckDB is designed to be portable and has very few runtime dependencies. Still, there are a few requirements to be aware of before installing or running DuckDB. Supported Platforms DuckDB officially supports Linux, macOS and Windows on both
... - https://man.mtool.work/duckdb/2.0/operations_manual/installing_duckdb/requiremen...
DuckDB 2.0 Documentation / man.mtool.work