Results of 1 - 10 of about 100 for description (0.008 sec.)
- Relational API – DuckDB 10896
- 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
...█▏ Relation Creation This section contains the details on how a relation is created. The methods are lazy evaluated . Name Description from_arrow Create a relation object from an Arrow object from_csv_auto Create a relation object from the CSV file in 'name...e from_arrow ( self : duckdb . duckdb . DuckDBPyConnection , arrow_object : object ) -> duckdb . duckdb . DuckDBPyRelation Description Create a relation object from an Arrow object Parameters arrow_object : pyarrow.Table, pyarrow.RecordBatch Arrow object to...self : duckdb . duckdb . DuckDBPyConnection , path_or_buffer : object , ** 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, T... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Spatial Functions – DuckDB 10220
- 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
...py Markdown Spatial Functions Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text des...ts using the GDAL library. Scalar Functions DuckDB_PROJ_Compiled_Version Signature VARCHAR DuckDB_PROJ_Compiled_Version () Description Returns a text description of the PROJ library version that that this instance of DuckDB was compiled against. Example SEL...1 , December 1 st , 2022 │ └────────────────────────────────┘ DuckDB_Proj_Version Signature VARCHAR DuckDB_Proj_Version () Description Returns a text description of the PROJ library version that is being used by this instance of DuckDB. Example SELECT duckd... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Text Functions – DuckDB 10103
- 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
...Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Name Description string[index] Extracts a single character using a (1-based) index. string[begin:end] Extracts a string using slice convent...ation using Percent-Encoding . url_encode(string) Encodes a URL to 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] De...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 ). Example 'hello' LIKE '%lo' Result true stri... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Numeric Functions – DuckDB 9882
- 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
...umeric Functions 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...e available for all numeric data types. Numeric Functions The table below shows the available mathematical functions. Name Description @(x) Absolute value. Parentheses are optional if x is a column name. abs(x) Absolute value. acos(x) Computes the inverse c...ract(x, y) Alias for x - y . tan(x) Computes the tangent of x . trunc(x) Truncates 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... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Aggregate Functions – DuckDB 9583
- 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
...string in this case. General Aggregate Functions The table below shows the available general aggregate functions. Function Description any_value(arg) Returns the first non-null value from arg . This function is affected by ordering . arbitrary(arg) Returns...ue is scaled by its corresponding weight . If weight is NULL , the corresponding arg value will be 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) - arbi...trary(arg) Description Returns the first value ( NULL or non- NULL ) from arg . This function is affected by ordering . Example arbitrary(A) Alia... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- Utility Functions – DuckDB 9531
- 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
...tility 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) Whether or not we can implici...d) Extracts UUID version ( 4 or 7 ). version() 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) Descr...he source value to the target value. Example can_cast_implicitly(1::BIGINT, 1::SMALLINT) Result false checkpoint(database) Description Synchronize WAL with file for (optional) database without interrupting transactions. Example checkpoint(my_db) Result succ... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Timestamp Functions – DuckDB 9310
- 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
...Z functions . 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 - subtractio...infinite value. Scalar Timestamp Functions The table below shows the available scalar functions for TIMESTAMP values. Name Description age(timestamp, timestamp) Subtract arguments, resulting in the time difference between the two timestamps. age(timestamp)...eral, if the function needs to examine the parts of the infinite date, the result will be NULL . age(timestamp, timestamp) Description Subtract arguments, resulting in the time difference between the two timestamps. Example age(TIMESTAMP '2001-04-10', TIMES... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Timestamp with Time Zone Functions – DuckDB 9310
- 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
...functions for TIMESTAMPTZ values. Since these functions do not involve binning or display, they are always available. Name Description current_timestamp Current date and time (start of current transaction). get_current_timestamp() Current date and time (sta...timestamp with time zone. transaction_timestamp() Current date and 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_curr...ent_timestamp() Description Current date and time (start of current transaction). Example get_current_timestamp() Result 2022-10-08 12:44:46.122-07 gr... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Date Part Functions – DuckDB 9206
- 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
...ts 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 Gregor..., secs , s 44 year Gregorian 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...support TIMESTAMP WITH TIME ZONE . Part Functions There are dedicated extraction functions to get certain subfields: Name Description century(date) Century. day(date) Day. dayofmonth(date) Day (synonym). dayofweek(date) Numeric weekday (Sunday = 0, Saturda... - https://man.mtool.work/duckdb/1.3/sql/functions/datepart.html
- List Functions – DuckDB 9037
- 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 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...at this is a special function that alters 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] De...otation with colon 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 bracket notation with an added step feature. Example [4, 5, 6][:-:2] Result [4, 6] Alias list_slice array_po... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
DuckDB 1.3 Documentation / man.mtool.work