Results of 1 - 10 of about 50 for therefore (0.004 sec.)
- Set Operations – DuckDB 13415
- 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
...possible, the UNION clause throws an error. Vanilla UNION (Set Semantics) The vanilla UNION clause follows set semantics, therefore it performs duplicate elimination, i.e., only unique rows will be included in the result. SELECT * FROM range ( 2 ) t1 ( x...22-10-12 Amsterdam NL NULL NULL Berlin Germany NULL NULL Amsterdam NULL 10 2022-10-14 UNION BY NAME follows set semantics (therefore it performs duplicate elimination), whereas UNION ALL BY NAME follows bag semantics. INTERSECT The INTERSECT clause can be...to select all rows that only occur in the left query. Vanilla EXCEPT (Set Semantics) Vanilla EXCEPT follows set semantics, therefore, it performs duplicate elimination, so only unique rows are returned. SELECT * FROM range ( 5 ) t1 ( x ) EXCEPT SELECT * F... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/setops.html
- PostgreSQL Compatibility – DuckDB 12332
- 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
...; PostgreSQL returns an error: ERROR: UNION types boolean and integer cannot be matched DuckDB performs an enforced cast, therefore, it completes the query and returns the following: x 1 2 Implicit Casting on Equality Checks DuckDB performs implicit cast...ing on equality checks, e.g., converting strings to numeric and boolean values. Therefore, there are several instances, where PostgreSQL throws an error while DuckDB successfully computes the result: Expression P...: CREATE TABLE "PreservedCase" ( x INTEGER ); SELECT * FROM PreservedCase ; ERROR: relation "preservedcase" does not exist Therefore, case-insensitivity in PostgreSQL only works if you never use quoted identifiers with different cases. For DuckDB, this be... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Securing DuckDB – DuckDB 10903
- 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
...SQL queries. The approach to securing DuckDB varies depending on your use case, environment, and potential attack models. Therefore, consider the security-related configuration options carefully, especially when working with confidential data sets. If yo...jection Similarly to other SQL databases, it's recommended to use prepared statements in DuckDB to prevent SQL injection . Therefore, avoid concatenating strings for queries: import duckdb duckdb . execute ( "SELECT * FROM (VALUES (32, 'a'), (42, 'b')) t(...sm, which have the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options for securing extensions . Privileges Avoid running DuckDB as a root user... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/overview.htm...
- ANALYZE Statement – DuckDB 10542
- 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
...uckDB's tables. Usage The statistics recomputed by the ANALYZE statement are only used for join order optimization . It is therefore recommended to recompute these statistics for improved join orders, especially after performing large updates (inserts and...compute Documentation Statements Copy Markdown Statement recomputes DuckDB tables Usage recomputed used order optimization therefore recommended these improved orders especially after performing 関連するページ VACUUM Statement SUMMARIZE Statement File For... - https://man.mtool.work/duckdb/1.3/sql/statements/analyze.html
- Securing Extensions – DuckDB 9474
- 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
...sm, which have the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page and setting them according to your attack models. Du...loading DuckDB extensions from the community extension repository will execute code written by third party developers, and therefore can be dangerous. A malicious developer could create and register a harmless-looking DuckDB extension that steals your cry... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/securing_ext...
- SELECT Clause – DuckDB 9114
- 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
...duplicate rows are filtered out. Queries starting with SELECT DISTINCT run deduplication, which is an expensive operation. Therefore, only use DISTINCT if necessary. DISTINCT ON Clause Select only the highest population city for each country: SELECT DISTI...ot defined and can be any row in the table. When querying large data sets, using DISTINCT on all columns can be expensive. Therefore, consider using DISTINCT ON on a column (or a set of columns) which guaranetees a sufficient degree of uniqueness for your... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- File Formats – DuckDB 8753
- 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
...aps . Thanks to these features, DuckDB can leverage optimizations such as projection and filter pushdown on Parquet files. Therefore, workloads that combine projection, filtering, and aggregation tend to perform quite well when run on Parquet files. Stora...ons: Loading the data from Parquet files will require approximately the same amount of space for the DuckDB database file. Therefore, if the available disk space is constrained, it is worth running the queries directly on Parquet files. Reasons against Qu... - https://man.mtool.work/duckdb/1.3/guides/performance/file_formats.html
- Tuning Workloads – DuckDB 8753
- 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
...vel. A row group in DuckDB's database format consists of max. 122,880 rows. Parallelism starts at the level of row groups, therefore, 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...an cause an out-of-memory exception when run on large data sets. The PIVOT operation internally uses the list() function , therefore it is subject to the same limitation. Profiling If your queries are not performing as well as expected, it's worth studyin... - https://man.mtool.work/duckdb/1.3/guides/performance/how_to_tune_workloads.html
- S3 API Support – DuckDB 8392
- 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
...will search for AWS credentials in the standard AWS credential locations (environment variables, credential files, etc.). Therefore, your R2 credentials must be made available as AWS environment variables ( AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY ) f...will search for AWS credentials in the standard AWS credential locations (environment variables, credential files, etc.). Therefore, your GCS HMAC keys must be made available as AWS environment variables ( AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY ) fo... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api.html
- Numeric Types – DuckDB 8392
- 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
...which is currently 38. Division of fixed-point decimals does not typically produce numbers with finite decimal expansion. Therefore, DuckDB uses approximate floating-point arithmetic for all divisions that involve fixed-point decimals and accordingly ret..., as arithmetic involving the INT128 type is much more expensive than operations involving the INT32 or INT64 types. It is therefore recommended to stick with a WIDTH of 18 or below, unless there is a good reason for why this is insufficient. Floating-Poi... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
DuckDB 1.3 Documentation / man.mtool.work