Results of 1 - 10 of about 53 for alias (0.006 sec.)
- Aggregate Functions – DuckDB 14035
- 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
...arg) Description Returns the first non- NULL value from arg . This function is affected by ordering . Example any_value(A) Alias(es) - arbitrary(arg) Description Returns the first value ( NULL or non- NULL ) from arg . This function is affected by ord...ering . Example arbitrary(A) Alias(es) first(A) arg_max(arg, val) Description Finds the row with the maximum val and calculates the arg expression at that ro...the value of the arg or val expression is NULL are ignored. This function is affected by ordering . Example arg_max(A, B) Alias(es) argmax(arg, val) , max_by(arg, val) arg_max(arg, val, n) Description The generalized case of arg_max for n values: ret... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- List Functions – DuckDB 11371
- 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
...mo Documentation / SQL / Functions Copy Markdown List Functions Name Description list[index] Bracket notation serves as an alias for list_extract . list[begin:end] Bracket notation with colon is an alias for list_slice . list[begin:end:step] list_slic...the cardinality of the result. See the unnest page for more details. list[index] Description Bracket notation serves as an alias for list_extract . Example [4, 5, 6][3] Result 6 Alias list_extract list[begin:end] Description Bracket notation with colo...n is an alias for list_slice . Example [4, 5, 6][2:3] Result [5, 6] Alias list_slice list[begin:end:step] Description list_slice in brac... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Numeric Functions – DuckDB 10716
- 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
...ion 2 * 3 6 / Float division 5 / 2 2.5 // Division 5 // 2 2 % Modulo (remainder) 5 % 4 1 ** Exponent 3 ** 4 81 ^ Exponent (alias for ** ) 3 ^ 4 81 & Bitwise AND 91 & 15 11 | Bitwise OR 32 | 3 35 << Bitwise shift left 1 << 4 16 >> Bitwise shift right 8...bsolute value. acos(x) Computes the inverse cosine of x . acosh(x) Computes the inverse hyperbolic cosine of x . add(x, y) Alias for x + y . asin(x) Computes the inverse sine of x . asinh(x) Computes the inverse hyperbolic sine of x . atan(x) Computes...that are set. cbrt(x) Returns the cube root of the number. ceil(x) Rounds the number up. ceiling(x) Rounds the number up. Alias of ceil . cos(x) Computes the cosine of x . cot(x) Computes the cotangent of x . degrees(x) Converts radians to degrees. d... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Text Functions – DuckDB 10329
- 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
...ent-Encoding . string[index] Description Extracts a single character using a (1-based) index. Example 'DuckDB'[4] Result k Alias array_extract string[begin:end] Description Extracts a string using slice conventions similar to Python. Missing begin or...terpreted as the beginning or end of the list respectively. Negative values are accepted. Example 'DuckDB'[:4] Result Duck Alias array_slice string LIKE target Description Returns true if the string matches the like specifier (see Pattern Matching )....ription Returns true if the string matches the regex (see Pattern Matching ). Example 'hello' SIMILAR TO 'l+' Result false Alias regexp_full_match string ^@ search_string Description Returns true if string begins with search_string . Example 'abc' ^@... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Time Functions – DuckDB 8975
- 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
...date_sub(part, starttime, endtime) The number of complete partitions between the times. datediff(part, starttime, endtime) Alias of date_diff . The number of partition boundaries between the times. datepart(part, time) Alias of date_part. Get subfield...(equivalent to extract ). datesub(part, starttime, endtime) Alias of date_sub. The number of complete partitions between the times. extract(part FROM time) Get subfield from a time. get_cu...local time zone. Note that parentheses should be omitted from the function call. Example current_time Result 10:31:58.578 Alias get_current_time() date_diff(part, starttime, endtime) Description The number of partition boundaries between the times. E... - https://man.mtool.work/duckdb/1.3/sql/functions/time.html
- Relational API – DuckDB 8751
- 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
...bject , ** kwargs ) -> duckdb . duckdb . DuckDBPyRelation Description Create a relation object from the CSV file in 'name' Aliases : read_csv Parameters path_or_buffer : Union[str, StringIO, TextIOBase] Path to the CSV file or buffer to read from. hea...Create a relation object from the Parquet files in file_globs Description Create a relation object from the Parquet files Aliases : read_parquet Parameters file_glob : str File path or glob pattern pointing to Parquet files to be read. binary_as_stri...│ └──────┴─────────┘ from_query Signature from_query ( self : duckdb . duckdb . DuckDBPyConnection , query : object , * , alias : str = '' , params : object = None ) -> duckdb . duckdb . DuckDBPyRelation Description Run a SQL query. If it is a SELECT... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Blob Functions – DuckDB 8692
- 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
...Result \xAA\xBB base64(blob) Description Converts a blob to a base64 encoded string. Example base64('A'::BLOB) Result QQ== Alias to_base64 concat(value, ...) Description Concatenates multiple strings, lists, or blobs. NULL inputs are skipped. See also...m_binary(value) Description Converts a value from binary representation to a blob. Example from_binary('0110') Result \x06 Alias unbin from_hex(value) Description Converts a value from hexadecimal representation to a blob. Example from_hex('2A') Resul...t * Alias unhex hex(blob) Description Converts blob to VARCHAR using hexadecimal encoding. Example hex('\xAA\xBB'::BLOB) Result AABB... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- Types – DuckDB 8364
- 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
...Logical Type Interface duckdb_logical_type duckdb_create_logical_type ( duckdb_type type ); char * duckdb_logical_type_get_alias ( duckdb_logical_type type ); void duckdb_logical_type_set_alias ( duckdb_logical_type type , const char * alias ); duckdb...duckdb_type type ); Parameters type : The primitive type to create. Return Value The logical type. duckdb_logical_type_get_alias Returns the alias of a duckdb_logical_type, if set, else nullptr . The result must be destroyed with duckdb_free . Syntax...char * duckdb_logical_type_get_alias ( duckdb_logical_type type ); Parameters type : The logical type Return Value The alias or nullptr duckdb_logical_type_set... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Timestamp Functions – DuckDB 8364
- 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
...s between the timestamps. date_trunc(part, timestamp) Truncate to specified precision . datediff(part, startdate, enddate) Alias of date_diff . The number of partition boundaries between the timestamps. datepart([part, ...], timestamp) Alias of date_p...art . Get the listed subfields as a struct . The list must be constant. datepart(part, timestamp) Alias of date_part . Get subfield (equivalent to extract ). datesub(part, startdate, enddate) Alias of date_sub . The number of...complete partitions between the timestamps. datetrunc(part, timestamp) Alias of date_trunc . Truncate to specified precision . dayname(timestamp) The (English) name of the weekday. epoch_ms(ms) Conve... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- ATTACH and DETACH Statements – DuckDB 8364
- 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
...ACH Statements DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db' ; Attach the database file.db with an explicit alias ( file_db ): ATTACH...more information): ATTACH 'sqlite_file.db' AS sqlite_db ( TYPE sqlite ); Attach the database file.db if inferred database alias file does not yet exist: ATTACH IF NOT EXISTS 'file.db' ; Attach the database file.db if explicit database alias file_db d...oes not yet exist: ATTACH IF NOT EXISTS 'file.db' AS file_db ; Attach the database file2.db as alias file_db detaching and replacing the existing alias if it exists: ATTACH OR REPLACE 'file2.db' AS file_db ; Create a table... - https://man.mtool.work/duckdb/1.3/sql/statements/attach.html
DuckDB 1.3 Documentation / man.mtool.work