Results of 1 - 10 of about 23 for definition (0.003 sec.)
- DuckDB_% Metadata Functions 15131
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...ich the constraint is defined. BIGINT constraint_index Indicates the position of the constraint as it appears in its table definition. BIGINT constraint_type Indicates the type of constraint. Applicable values are CHECK , FOREIGN KEY , PRIMARY KEY , NOT NU...LL , UNIQUE . VARCHAR constraint_text The definition of the constraint expressed as a SQL-phrase. (Not necessarily a complete or syntactically valid DDL-statement.) VARCHAR ex...pression If constraint is a check constraint, the definition of the condition being checked, otherwise NULL . VARCHAR constraint_column_indexes An array of table column indexes referr... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- CREATE MACRO Statement 10171
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...followed by the expression that is to be used as default value. The default value expression is in principle evaluated at definition-time - NOT at run-time. (There are a few exceptions, like CURRENT_SCHEMA . But it's best not to rely on that: if you need...ures that specify default values for missing parameters. A parameter that specifies a default value cannot appear before a definition of a parameter that does not have a default value. In other words, parameters without default values have to be defined "i...ther words, any positional parameters must appear "in the front"; while all named parameters must appear "at the back". By definition, positional parameters are passed in the same order as they were declared. But named parameters can appear in any order (p... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Troubleshooting Quack 9685
- DuckDB 2.0 ships a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. If you experience any issues with Quack, try upgrading all your DuckDB clients to the latest version of t
...he quack extension: FORCE INSTALL quack; ATTACH Fails to Bind a Remote Table Definition When a Quack client runs ATTACH 'quack:⟨host⟩' , it loads the server's table definitions up front and binds them locally....A single definition that cannot be bound fails the entire attachment, even when you only intend to query unrelated, ordinary tables on the ser...with TABLE_RESOLUTION 'eager' so that schemas are resolved while tables are enumerated, which lets Quack import their real definitions: {:.codebox-server} -- Server: substitute your own warehouse, URI, and secret. LOAD iceberg; LOAD quack; ATTACH 'warehous... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
- Numeric Functions 9182
- 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
...roduct of the current integer and all integers below it. fdiv(x, y) Performs integer division ( x // y ) using the floored definition and returns a DOUBLE value. floor(x) Rounds the number down. fmod(x, y) Calculates the modulo value using the floored defi...e old behavior, e.g., SELECT (2 * 3)!; . fdiv(x, y) | Description | Performs integer division ( x // y ) using the floored definition and returns a DOUBLE value. | | Example | fdiv(5, 2) | | Result | 2.0 | floor(x) | Description | Rounds the number down. |...| Example | floor(17.4) | | Result | 17 | fmod(x, y) | Description | Calculates the modulo value using the floored definition. Always returns a DOUBLE value. | | Example | fmod(5, 2) | | Result | 1.0 | gamma(x) | Description | Interpolation of the... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Geometry Data Type 9015
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...er Error: Encountered unrecognized coordinate system 'DUCK:1337' when trying to create GEOMETRY type The coordinate system definition may be incomplete or invalid ... This restriction exists because DuckDB needs the complete CRS definition, not just an ide...bed CRS metadata, such as GeoParquet. Without a system catalog entry, there is no way to resolve an identifier to its full definition. You can set the ignore_unknown_crs configuration option to true to simply skip any unknown CRSs and create GEOMETRY colum...2) │ └─────────────┘ Alternatively, if you are trying to define a GEOMETRY column yourself, you can provide a complete CRS definition in WKT or PROJJSON format instead of a shorthand identifier as the CRS parameter. However, as complete CRS definitions are... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Internal Errors 8847
- Internal errors signal an assertion failure within DuckDB. They usually occur due to unexpected conditions or errors in the program's logic. For example, running issue 17002 on DuckDB 1.2.1 results in an internal error. INTERNAL Error: Atte
...abase. The reason DuckDB enters “restricted mode” is because the database is in an undefined state. Internal errors are by definition bugs that should never happen so the code path is never tested. If you encounter an internal error, please consider creati... - https://man.mtool.work/duckdb/2.0/dev/internal_errors.html
- Quack Remote Protocol 8361
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...d-hoc SQL scoped to that attachment: {:.codebox-client} FROM remote_db.query('SELECT 42'); ATTACH binds the remote's table definitions on the client, so a single table definition that cannot be bound fails the whole attachment. If this happens (for example..., with an Iceberg catalog using lazy table resolution), see ATTACH Fails to Bind a Remote Table Definition . Routing a Session with CONNECT Once a remote is attached, the CONNECT statement routes the whole session to it, so that... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Aggregate Functions 8361
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...essel's bias correction. entropy(x) The log-2 entropy of count input-values. kurtosis_pop(x) The excess kurtosis (Fisher's definition) without bias correction. kurtosis(x) The excess kurtosis (Fisher's definition) with bias correction according to the samp...| The log-2 entropy of count input-values. | | Formula | - | kurtosis_pop(x) | Description | The excess kurtosis (Fisher's definition) without bias correction. | | Formula | - | kurtosis(x) | Description | The excess kurtosis (Fisher's definition) with bia... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- WITH Clause 8361
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...er certain conditions, DuckDB can inline the CTE into the main query, which means that the CTE is not materialized and its definition is duplicated in each place it is referenced. Inlining is done using the following heuristics: * The CTE is not referenced...the same CTE three times: WITH t(x) AS (⟨complex_query⟩) SELECT * FROM t AS t1, t AS t2, t AS t3; Inlining duplicates the definition of t for each reference which results in the following query: SELECT * FROM (⟨complex_query⟩) AS t1(x), (⟨complex_query⟩)...ication having already run, so that it is not inlined or executed more than once. Recursive CTEs WITH RECURSIVE allows the definition of CTEs which can refer to themselves. Note that the query must be formulated in a way that ensures termination, otherwise... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
- Replacement Scans 8194
- The replacement scan API can be used to register a callback that is called when a table is read that does not exist in the catalog. For example, when a query such as SELECT * FROM my_table is executed and my_table does not exist, the replac
...n_set_error ( duckdb_replacement_scan_info info , const char * error ); duckdb_add_replacement_scan Add a replacement scan definition to the specified database. Syntax void duckdb_add_replacement_scan ( duckdb_database db , duckdb_replacement_callback_t re... - https://man.mtool.work/duckdb/2.0/clients/c/replacement_scans.html
DuckDB 2.0 Documentation / man.mtool.work