Results of 1 - 10 of about 72 for however (0.003 sec.)
- Collations – DuckDB 13804
- 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
...ies. These orderings are often incompatible with one another. For example, in English the letter y comes between x and z . However, in Lithuanian the letter y comes between the i and j . For that reason, different collations are supported. The user must...ers (i.e., the letters A-Z and numbers 0-9), but generally does not make much sense for special unicode characters. It is, however, by far the fastest method of performing ordering and comparisons. Hence it is recommended to stick with the BINARY collat...SELECT 'hello' COLLATE NOACCENT = 'hëllo' ; true Collations can be combined by chaining them using the dot operator. Note, however, that not all collations can be combined together. In general, the NOCASE collation can be combined with any other collato... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- Excel Extension – DuckDB 9894
- 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
...wrapping the i18npool library , but as of DuckDB 1.2 also provides functionality to read and write Excel ( .xlsx ) files. However, .xls files are not supported. Previously, reading and writing Excel files was handled through the spatial extension , whi...ng a .xlsx file is as simple as just SELECT ing from it immediately, e.g.: SELECT * FROM 'test.xlsx' ; a b 1.0 2.0 3.0 4.0 However, if you want to set additional options to control the import process, you can use the read_xlsx function instead. The foll....g., it contains empty cells) in which case the ignore_errors or empty_as_varchar options can be used to work around this. However, when the COPY TO ... FROM '⟨file⟩.xlsx' syntax is used, no type inference is done and the types of the resulting columns... - https://man.mtool.work/duckdb/1.3/core_extensions/excel.html
- Overview – DuckDB 9894
- 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
...DB to be easy to deploy and operate. We believe that most users do not need to consult the pages of the operations manual. However, there are certain setups – e.g., when DuckDB is running in mission-critical infrastructure – where we would like to offer...ns also Documentation Operations Copy Markdown Overview designed easy deploy operate believe most users need consult pages However there certain setups running mission 関連するページ Relational API on Pandas Connect Overview Statements Overview Troubles... - https://man.mtool.work/duckdb/1.3/operations_manual/overview.html
- Overview – DuckDB 9894
- 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
...Copy Markdown Overview 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 necessitate...関連キーワード 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... - https://man.mtool.work/duckdb/1.3/sql/dialect/overview.html
- Numeric Types – DuckDB 9530
- 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
...or casts from other datatypes to floating-point types stores inputs that cannot be represented exactly as approximations. However, it can be harder to predict what inputs are affected by this. For example, it is not surprising that 1.3::DECIMAL(1, 0) -...xact, these operations are only approximate on floating-point binary data types. For more complex mathematical operations, however, floating-point arithmetic is used internally and more precise results can be obtained if intermediate steps are not cast...alias instead. If you want to do fast or complicated calculations, the floating-point data types may be more appropriate. However, if you use the results for anything important, you should evaluate your implementation carefully for corner cases (ranges... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- R-Tree Indexes – DuckDB 8829
- 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
...ration does not scale very well to large datasets as it always requires a full table scan to check every row in the table. However, by indexing a table with an R-tree, it is possible to accelerate these types of queries significantly. How Do R-Tree Inde...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, a special bottom up "bulk loading algorithm" (Sort-Tile-R...the entire index, the entire index will be loaded into memory and stay there for the duration of the database connection. However, all memory used by the R-tree index (even during bulk-loading) is tracked by DuckDB, and will count towards the memory li... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
- Parquet Tips – DuckDB 8829
- 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
...me file and uses predicate pushdown to only scan the row groups whose metadata ranges match the WHERE clause of the query. However there is some overhead associated with reading the metadata in each group. A good approach would be to ensure that within...exceed the specified number of row groups to limit the amount of locking – similarly to the behaviour of FILE_SIZE_BYTES . However, if PER_THREAD_OUTPUT is set, only one thread writes to each file, and it becomes accurate again. See the Performance Guid... - https://man.mtool.work/duckdb/1.3/data/parquet/tips.html
- Non-Deterministic Behavior – DuckDB 8829
- 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
...tbl GROUP BY s ORDER BY s ; The expected standard deviations and correlations from this query are 0 for all values of s . However, when executed on multiple threads, the query may return small numbers ( 0 <= z < 10e-16 ) due to floating-point inaccurac...ies. 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 these cases, try the following workarounds: Limit the... - https://man.mtool.work/duckdb/1.3/operations_manual/non-deterministic_behavior.h...
- Excel Import – DuckDB 8464
- 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
...emap Live Demo Documentation / Guides / File Formats Copy Markdown Excel Import DuckDB supports reading Excel .xlsx files, however, .xls files are not supported. Importing Excel Sheets Use the read_xlsx function in the FROM clause of a query: SELECT * F...atively, you can omit the read_xlsx function and let DuckDB infer it from the extension: SELECT * FROM 'test_excel.xlsx' ; However, if you want to be able to pass options to control the import behavior, you should use the read_xlsx function. One such op... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_import.html
- Environment – DuckDB 8464
- 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
...nly and read-write workloads. Network-attached storage. Network-attached storage can serve DuckDB for read-only workloads. However, it is not recommended to run DuckDB in read-write mode on network-attached storage (NAS). These setups include NFS , netw...on Ubuntu workers. glibc vs. musl libc DuckDB can be built with both glibc (default) and musl libc (see the build guide ). However, note that DuckDB binaries built with musl libc have lower performance. In practice, this can lead to a slowdown of more t... - https://man.mtool.work/duckdb/1.3/guides/performance/environment.html
DuckDB 1.3 Documentation / man.mtool.work