Results of 1 - 9 of about 9 for combinations (0.002 sec.)
- Loops 12942
- Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, suppose we want to fire off 100 queries that check for the presence of the values 0..
...rt(['${partcode}'], i) AS st FROM intervals WHERE p <> st['${partcode}']; ---- endloop foreach also has a number of preset combinations that should be used when required. In this manner, when new combinations are added to the preset, old tests will automatic...ally pick up these new combinations. Preset Expansion ⟨compression⟩ none uncompressed rle bitpacking dictionary fsst chimp patas ⟨signed⟩ tinyint smallint int... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
- PIVOT Statement 11342
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...ut into their own columns. DuckDB will find the distinct values in each ON clause column and create one new column for all combinations of those values (a Cartesian product). In the below example, all combinations of unique countries and unique cities receiv...e their own column. Some combinations may not be present in the underlying data, so those columns are populated with NULL values. PIVOT cities ON country, name...le 2000 1005 NULL NULL NULL 8015 564 2010 1065 NULL NULL NULL 8175 608 2020 1158 NULL NULL NULL 8772 738 To pivot only the combinations of values that are present in the underlying data, use an expression in the ON clause. Multiple expressions and/or columns... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- Relational API on Pandas 9077
- DuckDB offers a relational API that can be used to chain together query operations. These are lazily evaluated so that DuckDB can optimize their execution. These operators can act on Pandas DataFrames, DuckDB tables or views (which can poin
...for clarity output_df = transformed_rel.df() Relational operators can also be used to group rows, aggregate, find distinct combinations of values, join, union and more. They are also able to directly insert results into a DuckDB table or write to a CSV. Plea... - https://man.mtool.work/duckdb/2.0/guides/python/relational_api_pandas.html
- Release Cycle 8628
- This document outlines the DuckDB and core extension release cycle framework. It is intended for developers working on DuckDB extensions to better understand the underlying processes. Overview DuckDB follows Semantic Versioning ( v<MAJOR>.<
...ne workflow. Which version an extension targets depends on the release cycle phase and the branch. We will now go over all combinations Phase: Mid-cycle Type: Single branch Extension main -> DuckDB vx.y.z or main Type: Two branch Extension main -> DuckDB vx....nstable API extension depends on two things: the current release phase and the type of extensions. We will now go over all combinations. Phase: Mid-cycle Type: Single branch if DuckDB target: vx.y.z : PR for vx.y.<z+1> into main 1 PR for vx.<y+1>.0 merges in... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
- Utility Functions 8178
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...stop parameter is inclusive, and the stop and step arguments are optional. See the list variant for the available argument combinations. | | Example | generate_series(2, 5) | | Result | 4 rows: 2, 3, 4, 5 | glob(search_path) | Description | Return filenames...top parameter is exclusive, and the start and step arguments are optional. See the list variant for the available argument combinations. | | Example | range(2, 5) | | Result | 3 rows: 2, 3, 4 | repeat(value, count) | Description | Returns a table with count... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Versioning of Extensions 7711
- Extension Versioning Most software has some sort of version number. Version numbers serve a few important goals: Tie a binary to a specific state of the source code Allow determining the expected feature set Allow determining the state of t
...kDB version. Because of this tight connection, there is a potential risk for a combinatorial explosion. Therefore, not all combinations of nightly extension build and nightly DuckDB build are available. In general, there are 2 ways of using nightly builds: u... - https://man.mtool.work/duckdb/2.0/extensions/versioning_of_extensions.html
- Typecasting 7711
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...match the type of the function but can be cast to the required type. Implicit casts can only be added for a number of type combinations, and is generally only possible when the cast cannot fail. For example, an implicit cast can be added from INTEGER to DOUB... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- GROUPING SETS 7711
- GROUPING SETS , ROLLUP and CUBE can be used in the GROUP BY clause to perform a grouping over multiple dimensions within the same query. Note that this syntax is not compatible with GROUP BY ALL . Examples Compute the average income along t
.... This produces n+1 grouping sets where n is the amount of terms in the ROLLUP clause. CUBE produces grouping sets for all combinations of the inputs, e.g., CUBE (country, city, zip) will produce (country, city, zip), (country, city), (country, zip), (city,... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- CREATE MACRO Statement 7495
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...gs FROM tbl_range(3, 8); The first call returns 3 , the second returns 5 . Syntax Macros allow you to create shortcuts for combinations of expressions. CREATE MACRO add(a) AS a + b; Binder Error: Referenced column "b" not found in FROM clause! This works: CR... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work