Results of 1 - 10 of about 19 for compared (0.001 sec.)
- List Type 12021
- A LIST column encodes lists of values. Fields in the column can have values with different lengths, but they must all have the same underlying type. LIST s are typically used to store arrays of numbers, but can contain any uniform data type
...'b', 'c'][-2:] ['b', 'c'] SELECT list_slice(['a', 'b', 'c'], 2, 3) ['b', 'c'] Comparison and Ordering The LIST type can be compared using all the comparison operators . These comparisons can be used in logical expressions such as WHERE and HAVING clauses...l2[i] : If l1[i] < l2[i] , l1 is less than l2 . If all values are equal, then the longer list sorts last. NULL values are compared following PostgreSQL's semantics: At the top level, comparisons to NULL yield NULL ; At lower nesting levels NULL s are gr... - https://man.mtool.work/duckdb/2.0/sql/data_types/list.html
- Union Type 11098
- A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “alternative” values, much like the union in C. The main difference is that these UNION types are tagged unions and thus alwa
...Select the currently active tag from the UNION as an ENUM . SELECT union_tag(u) AS t FROM tbl1; t num str str Union Casts Compared to other nested types, UNION s allow a set of implicit casts to facilitate unintrusive and natural usage when working with...same semantics as STRUCT s . The “tag” is always stored as the first struct entry, which ensures that the UNION types are compared and ordered by “tag” first. Functions See Union Functions .... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Collations 10654
- Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules for how text should be ordered are different for different languages or for different countries
...rming sorting and comparison operations. By default, the BINARY collation is used. That means that strings are ordered and compared based only on their binary contents. This makes sense for standard ASCII characters (i.e., the letters A-Z and numbers 0-9... - https://man.mtool.work/duckdb/2.0/sql/expressions/collations.html
- Subqueries 10654
- Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery
...ll_grades [7, 9, 8] Subquery Comparisons: ALL , ANY and SOME In the section on scalar subqueries , a scalar expression was compared directly to a subquery using the equality comparison operator ( = ). Such direct comparisons only make sense with scalar s...ubqueries. Scalar expressions can still be compared to single-column subqueries returning multiple rows by specifying a quantifier. Available quantifiers are ALL , ANY and SO... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- Out of Memory Errors 9732
- DuckDB has a state of the art out-of-core query engine that can spill to disk for larger-than-memory processing. We continuously strive to improve DuckDB's scalability and prevent out of memory errors whenever possible. That said, you may s
...egate functions (such as string_agg() or aggregates with an ORDER BY clause ), or if you have very little available memory compared to the dataset size. Types of “Out of Memory” Errors Out of memory errors mainly occur in two forms: OutOfMemoryException... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/oom_errors.html
- Tuning Workloads 9271
- 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
...tables. In some cases, this can result in counter-intuitive performance results where queries are faster on on-disk tables compared to in-memory ones. Let's take Q1 of the TPC-H workload for example on the SF30 dataset: CALL dbgen(sf = 30); .timer on PRA...5 s Persistent DB (compressed) duckdb tpch-sf30.db 0.56 s We can observe that the compressed databases are about 8× faster compared to the uncompressed in-memory database.... - https://man.mtool.work/duckdb/2.0/guides/performance/how_to_tune_workloads.html
- CREATE INDEX Statement 9271
- CREATE INDEX The CREATE INDEX statement constructs an index on the specified column(s) of the specified table. Examples Create a unique index films_id_idx on the column id of table films : CREATE UNIQUE INDEX films_id_idx ON films (id); Cre
...to create the index and only check its existence before committing it to storage. Therefore, it may run for a longer time compared to other IF NOT EXISTS statements, which terminate early. Create compound index gy_idx on genre and year columns: CREATE I... - https://man.mtool.work/duckdb/2.0/sql/statements/create_index.html
- Struct Data Type 8810
- Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced by name using strings. This document refers to those entry names as keys. Each row in the STRUCT column must have the same keys.
...ck instead: SELECT struct_pack(y := a.x) AS b FROM (SELECT {'x': 42} AS a); Comparison and Ordering The STRUCT type can be compared using all the comparison operators . These comparisons can be used in logical expressions such as WHERE and HAVING clauses...lexicographical order over the entries, following PostgreSQL's IS NOT DISTINCT FROM semantics : corresponding entries are compared position by position, and two NULL entries in the same position are considered equal (not distinct) so the comparison move... - https://man.mtool.work/duckdb/2.0/sql/data_types/struct.html
- Map Type 8366
- MAP s are similar to STRUCT s in that 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 p
...2': 43}, 'key1'); [5] SELECT map_extract(MAP {'key1': 5, 'key2': 43}, 'key3'); [] Comparison Operators Nested types can be compared using all the comparison operators . These comparisons can be used in logical expressions for both WHERE and HAVING clause... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Secrets Manager 7905
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...al scope, which is a file path prefix that the secret applies to. When fetching a secret for a path, the secret scopes are compared to the path, returning the matching secret for the path. In the case of multiple matching secrets, the longest prefix is c... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
DuckDB 2.0 Documentation / man.mtool.work