Results of 1 - 10 of about 48 for cases (0.004 sec.)
- Keywords and Identifiers – DuckDB 13556
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...character, e.g., to create an identifier named IDENTIFIER "X" , use "IDENTIFIER ""X""" . Deduplicating Identifiers In some cases, duplicate identifiers can occur, e.g., column names may conflict when unnesting a nested data structure. In these cases,...em. SELECT col_A FROM ( SELECT 'x' AS col_a ); -- succeeds SELECT col_ á FROM ( SELECT 'x' AS col_a ); -- fails Preserving cases: While DuckDB treats identifiers in a case-insensitive manner, it preservers the cases of these identifiers. That is, each...character's case (uppercase/lowercase) is maintained as originally specified by the user even if a query uses different cases when referring to the identifier. For example: CREATE TABLE tbl AS SELECT cos ( pi ()) AS CosineOfPi ; SELECT cosineofpi F... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- Text Functions – DuckDB 12420
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...(insertions, deletions, substitutions or transpositions) required to change one string to another. Characters of different cases (e.g., a and A ) are considered different. editdist3(s1, s2) The minimum number of single-character edits (insertions, del...etions or substitutions) required to change one string to the other. Characters of different cases (e.g., a and A ) are considered different. hamming(s1, s2) The Hamming distance between to strings, i.e., the number of po...itions with different characters for two strings of equal length. Strings must be of equal length. Characters of different cases (e.g., a and A ) are considered different. jaccard(s1, s2) The Jaccard similarity between two strings. Characters of diffe... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Non-Deterministic Behavior – DuckDB 11117
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rent compilers, operating systems, and hardware architectures, can also cause changes in ordering. This page documents the cases where non-determinism is an expected behavior . If you would like to make your queries determinisic, see the “Working Arou...all numbers ( 0 <= z < 10e-16 ) due to floating-point inaccuracies. Working Around Non-Determinism For the majority of use cases, non-determinism is not causing any issues. However, there are some cases where deterministic results are desirable. In th...ese cases, try the following workarounds: Limit the number of threads to prevent non-determinism introduced by multi-threading. SET... - https://man.mtool.work/duckdb/1.3/operations_manual/non-deterministic_behavior.h...
- Tuning Workloads – DuckDB 10950
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...memory, an out of memory error may occur: Out of Memory Error: failed to allocate data of size ... (.../... used) In these cases, consider setting the preserve_insertion_order configuration option to false : SET preserve_insertion_order = false ; This...refore, for a query to run on k threads, it needs to scan at least k * 122,880 rows. Too Many Threads Note that in certain cases DuckDB may launch too many threads (e.g., due to HyperThreading), which can lead to slowdowns. In these cases, it's worth...does attempt to parallelize as much as possible within each individual query, but it is not possible to parallelize in all cases. Making multiple connections can process more operations concurrently. This can be more helpful if DuckDB is not CPU limit... - https://man.mtool.work/duckdb/1.3/guides/performance/how_to_tune_workloads.html
- Caveats – DuckDB 9496
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Caveats Equality Comparison Warning Currently, equality comparison of JSON files can differ based on the context. In some cases, it is based on raw text comparison, while in other cases, it uses logical content comparison. The following query returns...(c[0] = d[0]) (a = c[0]) (b != c[0]) true true true true true 関連キーワード content comparison equal space Equality based cases logical fields physical empty list Documentation Import Files Copy Markdown Caveats Comparison Warning Currently equality... - https://man.mtool.work/duckdb/1.3/data/json/caveats.html
- HTTP(S) Support – DuckDB 9178
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...LECT * FROM 'https://domain.tld/file.extension' ; Partial Reading For CSV files, files will be downloaded entirely in most cases, due to the row-based nature of the format. For Parquet files, DuckDB supports partial reading , i.e., it can use a combin...he Parquet metadata and the data for the column_a column: SELECT column_a FROM 'https://domain.tld/file.parquet' ; In some cases, no actual data needs to be read at all as they only require reading the metadata: SELECT count ( * ) FROM 'https://domain...files https domain tld parquet httpfs extension read query DuckDB Parquet metadata column username password over supported cases supports reading following Scanning using 関連するページ HTTP Parquet Import Configuration httpfs Extension for HTTP and S... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/https.html
- Writing Tests – DuckDB 8845
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...is crucial that any new features that get added have correct tests that not only test the “happy path”, but also test edge cases and incorrect usage of the feature. In this section, we describe how DuckDB tests are structured and how to make new tests...d) be expressed in pure SQL. There are certain exceptions to this, which we will discuss in Catch Tests . However, in most cases you should write your tests in plain SQL. Frameworks SQL tests should be written using the sqllogictest framework . C++ te...ード vector tests types struct DuckDB table integer Tests also unittest written client columns type flat Development Testing cases located build release debug testing components Catch 関連するページ sqllogictest Introduction Debugging Data Chunks Overvi... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/writing_tests.html
- Overview – DuckDB 8527
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rview DuckDB's SQL dialect is based on PostgreSQL. DuckDB tries to closely match PostgreSQL's semantics, however, some use cases require slightly different behavior. For example, interchangeability with data frame libraries necessitates order preserva...ーワード DuckDB PostgreSQL Documentation Dialect Copy Markdown Overview dialect based tries closely match semantics however cases require slightly different behavior example interchangeability frame libraries necessitates order 関連するページ SQL Quirk... - https://man.mtool.work/duckdb/1.3/sql/dialect/overview.html
- Embedding DuckDB – DuckDB 8360
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...g DuckDB Copy Markdown Embedding DuckDB CLI Client The Command Line Interface (CLI) client is intended for interactive use cases and not for embedding. As a result, it has more features that could be abused by a malicious actor. For example, the CLI c...s recommended Documentation Operations Securing Copy Markdown Embedding Client Command Line Interface intended interactive cases more features abused malicious actor 関連するページ DuckDB Repositories CLI Client DuckDB Wasm Installing the Python Clien... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/embedding_du...
- Versioning of Extensions – DuckDB 7558
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ly DuckDB build and using a stable DuckDB build. Let's go over the differences between the two: From Stable DuckDB In most cases, user's will be interested in a nightly build of a specific extension, but don't necessarily want to switch to using the n...this means is that, for example, an extension binary compiled for version 0.10.3 does not work for version 1.0.0. In most cases, this will not cause any issues and is fully transparent; DuckDB will automatically ensure it installs the correct binary... - https://man.mtool.work/duckdb/1.3/extensions/versioning_of_extensions.html
DuckDB 1.3 Documentation / man.mtool.work