Results of 1 - 10 of about 35 for corresponding (0.006 sec.)
- Aggregate Functions – DuckDB 12905
- 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, boundaries) Returns a MAP of key-value pairs representing the provided upper boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype. A boundary at the largest value of the datatype is automatic.... weighted_avg(arg, weight) Calculates the weighted average all non-null values in arg , where each value 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...ies) Description Returns a MAP of key-value pairs representing the provided upper boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype. A boundary at the largest value of the datatype is automatic... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- Catch C/C++ Tests – DuckDB 12634
- 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
...t. The database is created and queried using the C++ API. Results are checked using either REQUIRE_FAIL / REQUIRE_NO_FAIL (corresponding to statement ok and statement error) or REQUIRE(CHECK_COLUMN(...)) (corresponding to query with a result check). Every tes...t that is created in this way needs to be added to the corresponding CMakeLists.txt . 関連キーワード storage database Query tests using Catch config corresponding make catch hpp auto DeleteDa... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/catch.html
- Regular Expressions – DuckDB 11839
- 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
...ring, pattern, name_list[, options]) If string contains the regexp pattern , returns the capturing groups as a struct with corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. regexp_extract_all(stri...ng, regex[, group = 0][, options]) Finds non-overlapping occurrences of regex in string and returns the corresponding values of group . regexp_full_match(string, regex[, options]) Returns true if the entire string matches the regex . regexp...n, name_list[, options]) Description If string contains the regexp pattern , returns the capturing groups as a struct with corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. A set of optional optio... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Text Functions – DuckDB 11043
- 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
...racters in string . character_length(string) Number of characters in string . chr(code_point) Returns a character which is corresponding the ASCII code value or Unicode code point. concat(value, ...) Concatenates multiple strings, lists, or blobs. NULL inputs...t(string, regex, name_list[, options]) If string contains the regex pattern, returns the capturing groups as a struct with corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. A set of optional regex...xtract_all(string, regex[, group][, options]) Finds non-overlapping occurrences of the regex in the string and returns the corresponding values of the capturing group . A set of optional regex options can be set. regexp_full_match(string, regex[, col2]) Retur... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- C++ API – DuckDB 8370
- 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
...function; udf_func : is a pointer to the UDF function. This method automatically discovers from the template typenames the corresponding LogicalTypes: bool → LogicalType::BOOLEAN int8_t → LogicalType::TINYINT int16_t → LogicalType::SMALLINT int32_t → LogicalT...he function does not accept variable length arguments. This method automatically discovers from the template typenames the corresponding LogicalTypes: bool → LogicalType::BOOLEAN; int8_t → LogicalType::TINYINT; int16_t → LogicalType::SMALLINT int32_t → Logica... - https://man.mtool.work/duckdb/1.3/clients/cpp.html
- Timestamp Types – DuckDB 8370
- 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
...formed in a configured time zone , which defaults to the system time zone and is just UTC+00:00 in the examples above. The corresponding TIMESTAMP WITHOUT TIME ZONE stores the same INT64 , but arithmetic, binning, and string formatting follow the straightforw...ecial cased and are displayed unchanged, whereas the value epoch is simply a notational shorthand that is converted to the corresponding timestamp value when read. SELECT '-infinity' :: TIMESTAMP , 'epoch' :: TIMESTAMP , 'infinity' :: TIMESTAMP ; Negative Epo... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- Date Functions – DuckDB 8370
- 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
...e is infinite, false otherwise. julian(date) Extract the Julian Day number from a date. last_day(date) The last day of the corresponding month in the date. least(date, date) The earlier of two dates. make_date(year, month, day) The date for the given parts. m...Day number from a date. Example julian(DATE '1992-09-20') Result 2448886.0 last_day(date) Description The last day of the corresponding month in the date. Example last_day(DATE '1992-09-20') Result 1992-09-30 least(date, date) Description The earlier of two... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- GROUPING SETS – DuckDB 8370
- 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
...7 In this example, the lowest level of grouping is at the month level, defined by the grouping set (y, q, m) . Result rows corresponding to that level are simply aggregate rows and the GROUPING_ID(y, q, m) function returns 0 for those. The grouping set (y, q)...passed to GROUPING_ID() are expressions that appear some where in the GROUPING SETS -clause, GROUPING_ID() will set a bit corresponding to the position of the expression whenever that expression is rolled up to a super-aggregate. Syntax 関連キーワード groupi... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/grouping_sets.html
- Query – DuckDB 8115
- 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
...rmat. The function returns a dense array which contains the result data. The exact type stored in the array depends on the corresponding duckdb_type (as provided by duckdb_column_type ). For the exact type by which the data should be accessed, see the comment...the nullmask of a specific column of a result in columnar format. The nullmask indicates for every row whether or not the corresponding row is NULL . If a row is NULL , the values present in the array provided by duckdb_column_data are undefined. int32_t * d... - https://man.mtool.work/duckdb/1.3/clients/c/query.html
- Profiling – DuckDB 8115
- 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
...several cumulative metrics that are available in all nodes. In the QUERY_ROOT node, these metrics represent the sum of the corresponding metrics across all operators in the query. The OPERATOR nodes represent the sum of the operator's specific metric and thos...s enabled. The available optimizations can be queried using the duckdb_optimizers () table function . Each optimizer has a corresponding metric that follows the template: OPTIMIZER_ OPTIMIZER_NAME . For example, the OPTIMIZER_JOIN_ORDER metric corresponds to... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
DuckDB 1.3 Documentation / man.mtool.work