Results of 1 - 10 of about 11 for potentially (0.002 sec.)
- Crashes 12393
- DuckDB is thoroughly tested via an extensive test suite. However, bugs can still occur and these can sometimes lead to crashes. This page contains practical information on how to troubleshoot DuckDB crashes. Types of Crashes There are a few
...lse already reported the bug that causes the crash. Please search in the GitHub issue tracker for the error message to see potentially related issues. DuckDB has a large community and there may be some suggestions for a workaround. Disabling the Query Optim...ve which step reintroduces the error. In both cases, you will have a better understanding of what is causing the issue and potentially also a workaround that you can use right away. In any case, please consider submitting an issue with your findings. Submit... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/crashes.html
- Gitignore for DuckDB 12393
- If you work in a Git repository, you may want to configure your Gitignore to disable tracking files created by DuckDB . These potentially include the DuckDB database, write-ahead log, and temporary files. Sample Gitignore Files In the follo
... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/gitignor...
- Indexing 8837
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...any index buffers if it has to evict memory. Thus, indexes can take up a significant portion of DuckDB's available memory, potentially affecting the performance of memory-intensive queries. Re-attaching ( DETACH + ATTACH ) the database containing indexes ca... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- Execution Format 8837
- 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
...ore the same logical data with a different physical representation . This allows for a more compressed representation, and potentially allows for compressed execution throughout the system. Below the list of supported vector formats is shown. Flat Vectors F... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- Utility Functions 8837
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...ery defined in query_string . Only constant strings are allowed. Warning: this function allows invoking arbitrary queries, potentially altering the database state. query_table( tbl_name ) Table function that returns the table given in tbl_name . query_table...ery defined in query_string . Only constant strings are allowed. Warning: this function allows invoking arbitrary queries, potentially altering the database state. | | Example | query('SELECT 42 AS x') | | Result | 42 | query_table(tbl_name) | Description |... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Indexes 8837
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...e to fetch the result of DELETE ... RETURNING ... . Then, you can use that result in a subsequent INSERT ... statement, or potentially make use of DuckDB's Appender (if available in the client). Over-Eager Constraint Checking in Foreign Keys This limitation... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- R-Tree Indexes 7823
- 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
...cally rebalance itself and perform a somewhat costly splitting operation when a node reaches max capacity after an insert, potentially causing additional splits to cascade up the tree. However, when the R-tree index is created on an already populated table,... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Tuning Workloads 7823
- DuckDB aims to perform well out of the box, so most workloads do not require any tuning. When tuning is worthwhile, there is no single configuration or magic number that is optimal for every workload: the right settings depend on what you a
...SET preserve_insertion_order = false; This allows the system to re-order any results that do not contain ORDER BY clauses, potentially reducing memory usage. For details on which operations preserve row order and which do not, see the Order Preservation pag... - https://man.mtool.work/duckdb/2.0/guides/performance/how_to_tune_workloads.html
- Typecasting 7823
- 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
...fields of the resulting struct are the superset of all fields of the input structs. This logic also applies recursively to potentially nested structs. SELECT {'outer1': {'inner1': 42, 'inner2': 42}} AS c UNION SELECT {'outer1': {'inner2': 'hello', 'inner3':... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Iceberg Options 7308
- 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
...cally largest when sorting the filenames. Collations are not considered. This behavior is not enabled by default as it may potentially violate ACID constraints. It can be enabled by setting unsafe_enable_version_guessing to true . When this is set, iceberg... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
DuckDB 2.0 Documentation / man.mtool.work