Results of 1 - 10 of about 370 for Union (0.005 sec.)
- Union Type – DuckDB 13118
- 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB...erview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Union Type A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “a... - https://man.mtool.work/duckdb/1.3/sql/data_types/union.html
- Union Functions – DuckDB 11277
- 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB...verview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Union Functions Name Description union.tag Dot notation serves as an alias for union_extract . union_extract(union, 'tag') Extra... - https://man.mtool.work/duckdb/1.3/sql/functions/union.html
- Set Operations – DuckDB 10255
- 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB...Operations Set operations allow queries to be combined according to set operation semantics . Set operations refer to the UNION [ALL] , INTERSECT [ALL] and EXCEPT [ALL] clauses. The vanilla variants use set semantics, i.e., they eliminate duplicates,... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/setops.html
- Data Types – DuckDB 8528
- 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB...sting page for details. Nested / Composite Types DuckDB supports five nested data types: ARRAY , LIST , MAP , STRUCT , and UNION . Each supports different use cases and has a different structure. Name Description Rules when used in a column Build from... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- Types API – DuckDB 8370
- 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB...type objects map to a LIST type of the child type. Which can also be arbitrarily nested. import duckdb from typing import Union duckdb . typing . DuckDBPyType ( list [ dict [ Union [ str , int ], str ]]) MAP(UNION(u1 VARCHAR, u2 BIGINT), VARCHAR)[] d... - https://man.mtool.work/duckdb/1.3/clients/python/types.html
- WITH Clause – DuckDB 8370
- 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB...pth , FibonacciNumber , NextNumber ) AS ( -- Base case SELECT 0 AS RecursionDepth , 0 AS FibonacciNumber , 1 AS NextNumber UNION ALL -- Recursive step SELECT fib.RecursionDepth + 1 AS RecursionDepth , fib.NextNumber AS FibonacciNumber , fib.FibonacciN... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/with.html
- Combining Schemas – DuckDB 8273
- 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB...read_csv ( 'flights*.csv' ); Read a set of CSV files combining columns by name: SELECT * FROM read_csv ( 'flights*.csv' , union_by_name = true ); Combining Schemas When reading from multiple files, we have to combine schemas from those files. That is... - https://man.mtool.work/duckdb/1.3/data/multiple_files/combining_schemas.html
- Types – 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB..._LIST = 24 , DUCKDB_TYPE_STRUCT = 25 , DUCKDB_TYPE_MAP = 26 , DUCKDB_TYPE_ARRAY = 33 , DUCKDB_TYPE_UUID = 27 , DUCKDB_TYPE_UNION = 28 , DUCKDB_TYPE_BIT = 29 , DUCKDB_TYPE_TIME_TZ = 30 , DUCKDB_TYPE_TIMESTAMP_TZ = 31 , } duckdb_type ; Functions The enu... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Avro Extension – DuckDB 6889
- 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB...ke other systems, Avro does not treat NULL as a possible value in a range of e.g. INTEGER but instead represents NULL as a union of the actual type with a special NULL type. This is different to DuckDB, where any value can be NULL . Of course DuckDB a... - https://man.mtool.work/duckdb/1.3/core_extensions/avro.html
- Complete API – DuckDB 6325
- 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
...Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Express...Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB...ckdb_logical_type map_type , duckdb_value * keys , duckdb_value * values , idx_t entry_count ); duckdb_value duckdb_create_union_value ( duckdb_logical_type union_type , idx_t tag_index , duckdb_value value ); idx_t duckdb_get_map_size ( duckdb_value... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
DuckDB 1.3 Documentation / man.mtool.work