Results of 1 - 10 of about 31 for Aliases (0.003 sec.)
- Friendly SQL 12278
- 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
...pression. UNION BY NAME : perform the UNION operation along the names of columns (instead of relying on positions). Prefix aliases in the SELECT and FROM clauses : write x: 42 instead of 42 AS x for improved readability. Specifying a percentage of the t...single statement. SHOW ⟨setting⟩ : print the value of a configuration setting, e.g., SHOW threads . Query Features Column aliases in WHERE , GROUP BY , and HAVING . (Note that column aliases cannot be used in the ON clause of JOIN clauses .) COLUMNS()...me expression on multiple columns: with regular expressions with EXCLUDE and REPLACE with lambda functions Reusable column aliases (also known as “lateral column aliases”), e.g.: SELECT i + 1 AS j, j + 2 AS k FROM range(0, 3) t(i) Advanced aggregation f... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- List Functions 12052
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...| [2, 5] | length(list) | Description | Returns the length of the list . | | Example | length([1,2,3]) | | Result | 3 | | Aliases | char_length , character_length , len | list_aggregate(list, function_name, ...) | Description | Executes the aggregate f...t . See the List Aggregates section for more details. | | Example | list_aggregate([1, 2, NULL], 'min') | | Result | 1 | | Aliases | aggregate , array_aggr , array_aggregate , list_aggr | list_any_value(list) | Description | Applies aggregate function a...d(list, element) | Description | Appends element to list . | | Example | list_append([2, 3], 4) | | Result | [2, 3, 4] | | Aliases | array_append , array_push_back | list_approx_count_distinct(list) | Description | Applies aggregate function approx_coun... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Numeric Types 10968
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...unsigned numbers. Attempts to store negative numbers or values outside of the allowed range will result in an error. Name Aliases Min Max Size in bytes TINYINT INT1 - 2^7 2^7 - 1 1 SMALLINT INT2 , INT16 , SHORT - 2^15 2^15 - 1 2 INTEGER INT4 , INT32 ,...0 2^128 - 1 16 INT8 is a 64-bit integer, and is not the signed equivalent of UINT8 , an unsigned, 8-bit integer. The type aliases INT1 , INT2 , INT4 and INT8 for signed integers were inherited from PostgreSQL, where digits in these names indicate their...size in bytes , whereas the type aliases for their unsigned equivalents, UINT8 , UINT16 , UINT32 and UINT64 , indicate their size in bits following the C/C++ conve... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Map Functions 10968
- Name Description cardinality(map) Return the size of the map (or the number of entries in the map). element_at(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the ke
...of the map's keys; else, an error is thrown. | | Example | element_at(map([100, 5], [42, 43]), 100) | | Result | [42] | | Aliases | map_extract(map, key) | map_concat(maps...) | Description | Returns a map created from merging the input maps . On key c...of the map's keys else an error is returned. | | Example | map_extract(map([100, 5], [42, 43]), 100) | | Result | [42] | | Aliases | element_at(map, key) | map_extract_value(map, key) | Description | Returns the value for a given key or NULL if the key...e map's keys; else, an error is thrown. | | Example | map_extract_value(map([100, 5], [42, 43]), 100); | | Result | 42 | | Aliases | map[key] | map_from_entries(STRUCT(k, v)[]) | Description | Returns a map created from the entries of the array. | | Exa... - https://man.mtool.work/duckdb/2.0/sql/functions/map.html
- Data Types 10321
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...standard and hence might not be accepted by other database engines. Name Aliases Description BIGINT INT8 , LONG Signed eight-byte integer BIT BITSTRING String of 1s and 0s BLOB BYTEA , BINARY , VARBINARY... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Lambda Functions 9027
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...s the input list's. See list_filter examples . | | Example | list_filter([3, 4, 5], lambda x : x > 4) | | Result | [5] | | Aliases | array_filter , filter | list_reduce(list, lambda(x,y)[, initial_value]) | Description | Reduces all elements of the inpu...al_value argument. See list_reduce examples . | | Example | list_reduce([1, 2, 3], lambda x, y : x + y) | | Result | 6 | | Aliases | array_reduce , reduce | list_transform(list, lambda(x)) | Description | Returns a list that is the result of applying th...nction. See list_transform examples . | | Example | list_transform([1, 2, 3], lambda x : x + 1) | | Result | [2, 3, 4] | | Aliases | apply , array_apply , array_transform , list_apply | Nesting Lambda Functions All scalar functions can be arbitrarily ne... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- Relational API 8379
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...format is dateformat , timestamp_format is timestampformat , lineterminator is new_line and decimal is decimal_separator . Aliases : from_csv_auto Parameters path_or_buffer : str, list[str], file-like object Path to the file, a glob pattern, a list of p...or file-like object(s) in 'path_or_buffer'. Each option is the option of the same name of the SQL read_parquet function . Aliases : from_parquet Parameters path_or_buffer : str, list[str], file-like object Path to the Parquet file, a glob pattern, a li...ther statement runs once, now, and gives a relation over what it returned. Statements before the last one run immediately. Aliases : from_query , query Parameters query : str The SQL text; when it holds several statements, the ones before the last run a... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Bitstring Type 8379
- Name Aliases Description BITSTRING BIT Variable-length strings of 1s and 0s Bitstrings are strings of 1s and 0s. The bit type data is of variable length. A bitstring value requires 1 byte for each group of 8 bits, plus a fixed amount to sto
... - https://man.mtool.work/duckdb/2.0/sql/data_types/bitstring.html
- Date Types 8379
- 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
... - https://man.mtool.work/duckdb/2.0/sql/data_types/date.html
- Profiling Queries 8379
- DuckDB supports profiling queries via the EXPLAIN and EXPLAIN ANALYZE statements. EXPLAIN To see the query plan of a query without executing it, run: EXPLAIN ⟨query⟩; The output of EXPLAIN contains the estimated cardinalities for each opera
...rated query preserves the result column names, column order, and logical types, but the exact formatting and any generated aliases are not a stable interface. EXPLAIN (SQL) does not execute the query, supports only SELECT , VALUES , WITH , INSERT , UPDA... - https://man.mtool.work/duckdb/2.0/sql/statements/profiling.html
DuckDB 2.0 Documentation / man.mtool.work