Results of 1 - 10 of about 17 for shorthand (0.002 sec.)
- SET VARIABLE and RESET VARIABLE Statements 14466
- DuckDB supports the definition of SQL-level variables using the SET VARIABLE and RESET VARIABLE statements. Variable Scopes DuckDB supports two levels of variable scopes: Scope Description SESSION Variables with a SESSION scope are local to
...g the getvariable call: SET VARIABLE my_var = 30; SELECT 20 + getvariable('my_var') AS total; total 50 New The $⟨variable⟩ shorthand was introduced in DuckDB 2.0. As a shorthand for getvariable , a variable can be referenced directly with the $⟨variable⟩...4 AS col1, 56 AS col2; SELECT COLUMNS(lambda c: c != getvariable('column_to_exclude')) FROM tbl; col0 col2 12 56 The $name Shorthand New Referencing a variable with the $name shorthand was introduced in DuckDB 2.0. As a shorthand for getvariable , you can... - https://man.mtool.work/duckdb/2.0/sql/statements/set_variable.html
- Friendly SQL 9966
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...ROUP BY ALL : omit the group-by columns by inferring them from the list of attributes in the SELECT clause. ORDER BY ALL : shorthand to order on all columns (e.g., to ensure deterministic results). SELECT * EXCLUDE : the EXCLUDE option allows excluding sp...de tables. UNPIVOT to turn wide tables to long tables. Defining SQL-level variables: SET VARIABLE RESET VARIABLE The $name shorthand for reading variables : write $x instead of getvariable('x') . Organizing the catalog: Nested schemas : create schemas wit...tion features for analytical (OLAP) queries: FILTER clause GROUPING SETS , GROUP BY CUBE , GROUP BY ROLLUP clauses count() shorthand for count(*) IN operator for lists and maps Specifying column names for common table expressions ( WITH ) Data-modifying C... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- Logging 9586
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...ng to File CALL enable_logging(storage = 'file', storage_config = {'path': 'path/to/store/logs'}); or using the equivalent shorthand: CALL enable_logging(storage_path = 'path/to/store/logs'); Advanced Usage Normalized vs. Denormalized Logging DuckDB's log...nfigured as follows: CALL enable_logging(storage = 'memory', storage_config = {'buffer_size': 0}); or using the equivalent shorthand: CALL enable_logging(storage = 'memory', storage_buffer_size = 0); Note that the default buffer size is different for diff...al: -- regular invocation CALL enable_logging(storage = 'file', storage_config = {'path': 'path/to/store/logs'}); -- using shorthand for common path storage config param CALL enable_logging(storage = 'file', storage_path = 'path/to/store/logs'); -- omitti... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- MotherDuck Extension 9414
- The motherduck extension allows connecting to MotherDuck , a cloud data warehouse built on DuckDB. Installing and Loading The motherduck extension will be transparently autoinstalled and autoloaded on first use from the official extension r
...epository. If you would like to install and load it manually, you can use the motherduck extension name or the md shorthand: INSTALL AND LOAD md; Usage You can connect to MotherDuck by executing the following command: ATTACH 'md:'; Platforms The... - https://man.mtool.work/duckdb/2.0/core_extensions/motherduck.html
- Spatial Functions 9414
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...Macro Functions Function Summary ST_Rotate Alias of ST_RotateZ ST_RotateX Rotates a geometry around the X axis. This is a shorthand macro for calling ST_Affine. ST_RotateY Rotates a geometry around the Y axis. This is a shorthand macro for calling ST_Aff...ine. ST_RotateZ Rotates a geometry around the Z axis. This is a shorthand macro for calling ST_Affine. ST_Scale ST_TransScale Translates and then scales a geometry in X and Y direction. This is a...Signature GEOMETRY ST_RotateX (geom GEOMETRY, radians double) Description Rotates a geometry around the X axis. This is a shorthand macro for calling ST_Affine. Example -- Rotate a 3D point 90 degrees (π/2 radians) around the X-axis SELECT ST_RotateX(ST_... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Date Types 8845
- Name Aliases Description DATE Calendar date (year, month, day) A date specifies a combination of year, month and day. DuckDB follows the SQL standard's lead by counting dates exclusively in the Gregorian calendar, even for years before that
...nd -infinity are specially represented inside the system and will be displayed unchanged; but epoch is simply a notational shorthand that will be converted to the date value when read. SELECT '-infinity'::DATE AS negative, 'epoch'::DATE AS epoch, 'infinit... - https://man.mtool.work/duckdb/2.0/sql/data_types/date.html
- Unnesting 8466
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
..., and the member value becomes a column value. Values of a STRUCT -type may also be unnested using dot-star ( ⟨struct⟩.* ) shorthand syntax , but the unnest() function offers some additional functionality. For a TUPLE (unnamed struct), the unnesting opera...name is generated based on the (1-based) ordinal position of the member, prefixed by element . The dot-star ( ⟨struct⟩.* ) shorthand syntax is not available for tuples: tuples can only be unnested using the unnest() function. Calling unnest() The LIST or... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- CREATE TABLE Statement 8466
- The CREATE TABLE statement creates a table in the catalog. Examples Create a table with two integer columns ( i and j ): CREATE TABLE t1 (i INTEGER, j INTEGER); Create a table with a primary key: CREATE TABLE t1 (id INTEGER PRIMARY KEY, j V
...TE OR REPLACE syntax allows a new table to be created or for an existing table to be overwritten by the new table. This is shorthand for dropping the existing table and then creating the new one. Create a table with two integer columns (i and j) even if t...AS”: CREATE TABLE nums AS SELECT i FROM range(0, 3) t(i); This syntax can be used in combination with the CSV reader , the shorthand to read directly from CSV files without specifying a function, the FROM -first syntax , and the HTTP(S) support , yielding... - https://man.mtool.work/duckdb/2.0/sql/statements/create_table.html
- IN Operator 8276
- The IN operator checks containment of the left expression inside the collection on the right hand side (RHS). Supported collections on the RHS are tuples, lists, and maps, as well as subqueries that return a single column. The single-column
...42, 52]) AS x, 'a' AS y); Binder Error: Subquery returns 2 columns - expected 1 IN String The IN operator can be used as a shorthand for the contains string function . For example: SELECT 'Hello' IN 'Hello World'; true NOT IN NOT IN can be used to check i... - https://man.mtool.work/duckdb/2.0/sql/expressions/in.html
- Casting 8086
- Casting refers to the operation of converting a value in a particular data type to the corresponding value in another data type. Casting can occur either implicitly or explicitly. The syntax described here performs an explicit cast. More in
...g is CAST(expr AS TYPENAME) , where TYPENAME is a name (or alias) of one of DuckDB's data types . DuckDB also supports the shorthand expr::TYPENAME , which is also present in PostgreSQL. SELECT CAST(i AS VARCHAR) AS i FROM generate_series(1, 3) tbl(i); i... - https://man.mtool.work/duckdb/2.0/sql/expressions/cast.html
DuckDB 2.0 Documentation / man.mtool.work