Results of 1 - 10 of about 11 for thus (0.006 sec.)
- Union Type – DuckDB 13567
- 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
...ple “alternative” values, much like the union in C. The main difference being that these UNION types are tagged unions and thus always carry a discriminator “tag” which signals which alternative it is currently holding, even if the inner value itself...is null. UNION types are thus more similar to C++17's std::variant , Rust's Enum or the “sum type” present in most functional languages. UNION types mus...om being completely “transparent”, while still allowing UNION types to have a “supertype” relationship with their members. Thus UNION types can't be implicitly cast to any of their member types in general, since the information in the other members n... - https://man.mtool.work/duckdb/1.3/sql/data_types/union.html
- SQL Introduction – DuckDB 11184
- 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
...nt results by using DISTINCT and ORDER BY together: SELECT DISTINCT city FROM weather ORDER BY city ; Joins between Tables Thus far, our queries have only accessed one table at a time. Queries can access multiple tables at once, or access the same ta...so that the query won't fail if a duplicate column name is later added to one of the tables. Join queries of the kind seen thus far can also be written in this alternative form: SELECT * FROM weather INNER JOIN cities ON weather.city = cities.name ;...ndamental difference between WHERE and HAVING is this: WHERE selects input rows before groups and aggregates are computed (thus, it controls which rows go into the aggregate computation), whereas HAVING selects group rows after groups and aggregates... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- Timestamp Types – DuckDB 9157
- 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
...ZONE semantics, e.g., Parquet timestamp columns with isAdjustedToUTC=true , are converted to TIMESTAMP WITH TIME ZONE and thus lose precision when read using DuckDB. SELECT TIMESTAMP_NS '1992-09-20 11:30:00.123456789' ; 1992-09-20 11:30:00.123456789...ation. Instead, it only stores the INT64 number of non-leap microseconds since the Unix epoch 1970-01-01 00:00:00+00 , and thus unambiguously identifies a point in absolute time, or instant . The reason for the labels time zone aware and WITH TIME ZO... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- Profiling – DuckDB 8819
- 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
...em. The EXPLAIN ANALYZE statement enables obtaining these, as it pretty-prints the query plan and also executes the query. Thus, it provides the actual run-time performance numbers. The FORMAT Option The EXPLAIN [ANALYZE] statement allows exporting t...asures the cumulative operator timings. It does not include time spent in other stages, like parsing, query planning, etc. Thus, for some queries, the LATENCY in the QUERY_ROOT can be greater than the CPU_TIME . Detailed Profiling When the profiling_... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- DROP Statement – DuckDB 8144
- 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
...schema ; CREATE TABLE myschema.t1 ( i INTEGER ); DROP SCHEMA myschema CASCADE ; The following dependencies are tracked and thus will raise an error if the user tries to drop the depending object without the CASCADE modifier. Depending object type Dep... - https://man.mtool.work/duckdb/1.3/sql/statements/drop.html
- Environment – DuckDB 7806
- 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
...on the memory requirement. Workloads containing large joins over many-to-many tables yield large intermediate datasets and thus require more memory for their evaluation to fully fit into the memory. As an approximation, aggregation-heavy workloads re... - https://man.mtool.work/duckdb/1.3/guides/performance/environment.html
- Indexing – DuckDB 7806
- 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
...ex buffers are not yet buffer-managed. That means DuckDB does not yet destroy 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-i... - https://man.mtool.work/duckdb/1.3/guides/performance/indexing.html
- Crashes – DuckDB 7806
- 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
...mple, many Linux distributions run an OOM reaper or OOM killer process , which kills processes to free up their memory and thus prevents the operating system from running out of memory. If your DuckDB session is killed by the OOM reaper, consult the... - https://man.mtool.work/duckdb/1.3/guides/troubleshooting/crashes.html
- Map Type – DuckDB 7806
- 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
...at they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies per row. MAP s must have a single type for all... - https://man.mtool.work/duckdb/1.3/sql/data_types/map.html
- Subqueries – DuckDB 7806
- 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
...FROM grades ) AS excellent ; returns excellent false because 8 is not greater than or equal to the subquery result 7. And thus, because not all comparisons evaluate true , >= ALL as a whole evaluates to false . ANY The ANY quantifier specifies that... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
DuckDB 1.3 Documentation / man.mtool.work