Results of 1 - 10 of about 228 for Example (0.008 sec.)
- Text Functions – DuckDB 9890
- 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
...o a representation using Percent-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 t...ing begin or end arguments are interpreted 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 spec...ifier (see Pattern Matching ). Example 'hello' LIKE '%lo' Result true string SIMILAR TO regex Description Returns true if the string matches the regex (see Patte... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Numeric Functions – DuckDB 9374
- 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
...ions Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5 // 2 2...ncates the number. xor(x, y) Bitwise XOR. @(x) Description Absolute value. Parentheses are optional if x is a column name. Example @(-17.4) Result 17.4 Alias abs abs(x) Description Absolute value. Example abs(-17.4) Result 17.4 Alias @ acos(x) Descripti...on Computes the inverse cosine of x . Example acos(0.5) Result 1.0471975511965976 acosh(x) Description Computes the inverse hyperbolic cosine of x . Example acosh(1.5)... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Utility Functions – DuckDB 8930
- 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
...n() Return the currently active version of DuckDB in this format. alias(column) Description Return the name of the column. Example alias(column1) Result column1 can_cast_implicitly(source_value, target_value) Description Whether or not we can implicitly...cast from the types of the source value to the target value. Example can_cast_implicitly(1::BIGINT, 1::SMALLINT) Result false checkpoint(database) Description Synchronize WAL with file for (o...ptional) database without interrupting transactions. Example checkpoint(my_db) Result success Boolean coalesce(expr, ...) Description Return the first expression that evaluates to a n... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Relational API – DuckDB 8765
- 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
...ation The relations do not hold any data – and nothing is executed – until a method that triggers execution is called. For example, we create a relation, which loads 1 billion rows: import duckdb duckdb_conn = duckdb . connect () rel = duckdb_conn . sql...tion is unknown). By calling an output method, the data is retrieved and stored in the specified format: rel . to_table ( "example_rel" ) # 100% ▕████████████████████████████████████████████████████████████▏ Relation Creation This section contains the d...t from an Arrow object Parameters arrow_object : pyarrow.Table, pyarrow.RecordBatch Arrow object to create a relation from Example import duckdb import pyarrow as pa ids = pa . array ([ 1 ], type = pa . int8 ()) texts = pa . array ([ 'a' ], type = pa .... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- JSON Processing Functions – DuckDB 8734
- 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
..., you need to surround the -> operator with parentheses when expressing operations such as equality comparisons ( = ). For example: SELECT (( JSON '{"field": 42}' ) -> 'field' ) = 42 ; Warning DuckDB's JSON data type uses 0-based indexing . Examples: CR...EATE TABLE example ( j JSON ); INSERT INTO example VALUES ( '{ "family": "anatidae", "species": [ "duck", "goose", "swan", null ] }' ); SELEC...T json_extract ( j , '$.family' ) FROM example ; "anatidae" SELECT j -> '$.family' FROM example ; "anatidae" SELECT j -> '$.species[0]' FROM example ; "duck" SELECT j ->... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Timestamp Functions – DuckDB 8672
- 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
.... Timestamp Operators The table below shows the available mathematical operators for TIMESTAMP types. Operator Description Example Result + addition of an INTERVAL TIMESTAMP '1992-03-22 01:02:03' + INTERVAL 5 DAY 1992-03-27 01:02:03 - subtraction of TIM...L . age(timestamp, timestamp) Description Subtract arguments, resulting in the time difference between the two timestamps. Example age(TIMESTAMP '2001-04-10', TIMESTAMP '1992-09-20') Result 8 years 6 months 20 days age(timestamp) Description Subtract fr...om current_date. Example age(TIMESTAMP '1992-09-20') Result 29 years 1 month 27 days 12:39:00.844 century(timestamp) Description Extracts the centu... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Timestamp with Time Zone Functions – DuckDB 8610
- 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
...) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In the examples below, the current time zone is presumed to be America/Los_Angeles using the Gregorian calendar. Built-In Timestamp with...d time (start of current transaction). current_timestamp Description Current date and time (start of current transaction). Example current_timestamp Result 2022-10-08 12:44:46.122-07 get_current_timestamp() Description Current date and time (start of cu...rrent transaction). Example get_current_timestamp() Result 2022-10-08 12:44:46.122-07 greatest(timestamptz, timestamptz) Description The later of two... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Date Part Functions – DuckDB 8548
- 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
...cified as strings that contain the part name of the field. Below is a full list of all available date part specifiers. The examples are the corresponding parts of the timestamp 2021-08-03 11:59:44.123456 . Part Specifiers Usable as Date Part Specifiers...and in Intervals Specifier Description Synonyms Example century Gregorian century cent , centuries , c 21 day Gregorian day days , d , dayofmonth 3 decade Gregorian decade dec ,...regorian year yr , y , years , yrs 2021 Part Specifiers Only Usable as Date Part Specifiers Specifier Description Synonyms Example dayofweek Day of the week (Sunday = 0, Saturday = 6) weekday , dow 2 dayofyear Day of the year (1-365/366) doy 215 epoch S... - https://man.mtool.work/duckdb/1.3/sql/functions/datepart.html
- List Functions – DuckDB 8486
- 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
...ment. flatten(list_of_lists) Concatenate a list of lists into a single list. This only flattens one level of the list (see examples ). len(list) Return the length of the list. list_aggregate(list, name) Executes the aggregate function name on the elemen...sult. 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 colon is an alias for list_slic...e . Example [4, 5, 6][2:3] Result [5, 6] Alias list_slice list[begin:end:step] Description list_slice in bracket notation with an adde... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Aggregate Functions – DuckDB 8383
- 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
...ions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Aggregate Functions Examples Produce a single row containing the sum of the amount column: SELECT sum ( amount ) FROM sales ; Produce one row per uniq...rst , last , list and string_agg / group_concat / listagg . These can be made deterministic by ordering the arguments. For example: CREATE TABLE tbl AS SELECT s FROM range ( 1 , 4 ) r ( s ); SELECT string_agg ( s , ', ' ORDER BY s DESC ) AS countdown FR...e skipped. any_value(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... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
DuckDB 1.3 Documentation / man.mtool.work