Results of 1 - 10 of about 54 for defined (0.003 sec.)
- DuckDB_% Metadata Functions – DuckDB 14967
- 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
...comment A comment created by the COMMENT ON statement . VARCHAR internal true if this column built-in, false if it is user-defined. BOOLEAN column_default The default value of the column (expressed in SQL) VARCHAR is_nullable true if the column can hold...contains the constraint. BIGINT schema_name The SQL name of the schema that contains the table on which the constraint is defined. VARCHAR schema_oid Internal identifier of the schema object that contains the table on which the constraint is defined. B...IGINT table_name The SQL name of the table on which the constraint is defined. VARCHAR table_oid Internal identifier (name) of the table object on which the constraint is defined. BIGINT constraint_in... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- QUALIFY Clause – DuckDB 11822
- 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
...DER BY . Examples Each of the following examples produce the same output, located below. Filter based on a window function defined in the QUALIFY clause: SELECT schema_name , function_name , -- In this example the function_rank column in the select clau...() QUALIFY row_number () OVER ( PARTITION BY schema_name ORDER BY function_name ) < 3 ; Filter based on a window function defined in the SELECT clause: SELECT schema_name , function_name , row_number () OVER ( PARTITION BY schema_name ORDER BY function..._name ) AS function_rank FROM duckdb_functions () QUALIFY function_rank < 3 ; Filter based on a window function defined in the QUALIFY clause, but using the WINDOW clause: SELECT schema_name , function_name , -- In this example the function_r... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/qualify.html
- TPC-H Extension – DuckDB 10264
- 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
...used) sf DOUBLE Scale factor step UINTEGER Defines the partition to be generated, indexed from 0 to children - 1. Must be defined when the children arguments is defined suffix VARCHAR Append the suffix to table names Pre-Generated Data Sets Pre-generat...dbgen ( sf = 300 , children = 10 , step = 9 ); Limitation The tpch ( query_id ) function runs a fixed TPC-H query with pre-defined bind parameters (a.k.a. substitution parameters). It is not possible to change the query parameters using the tpch extensi...キーワード tpch dbgen query step children queries scale factor parameters table minutes extension DuckDB Generating generate defined amount memory generator benchmark Usage existing tables running Listing 関連するページ Summarize TPC Crashes Prepared Stat... - https://man.mtool.work/duckdb/1.3/core_extensions/tpch.html
- Constraints – DuckDB 9093
- 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
...nforce this property efficiently, an ART index is automatically created for every primary key or unique constraint that is defined in the table. Primary key constraints and unique constraints are identical except for two points: A table can only have on...e primary key constraint defined, but many unique constraints A primary key constraint also enforces the keys to not be NULL . CREATE TABLE students ( id I...order to enforce this property efficiently, an ART index is automatically created for every foreign key constraint that is defined in the table. Warning Indexes have certain limitations that might result in constraints being evaluated too eagerly, leadi... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
- Indexes – DuckDB 9093
- 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
...p Live Demo Documentation / SQL Copy Markdown Indexes Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically cre...emory during index creation. Avoid creating ART indexes if the index does not fit in memory during index creation. Indexes Defined by Extensions DuckDB supports R-trees for spatial indexing via the spatial extension. Persistence Both min-max indexes and...e Code of Conduct Trademark Use Blog In this article Index Types Min-Max Index (Zonemap) Adaptive Radix Tree (ART) Indexes Defined by Extensions Persistence CREATE INDEX and DROP INDEX Statements Limitations of ART Indexes Constraint Checking in UPDATE... - https://man.mtool.work/duckdb/1.3/sql/indexes.html
- Information Schema – DuckDB 9093
- 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 that are used in the check expression. For a not-null constraint, this view identifies the column that the constraint is defined on. For a foreign key constraint, this view identifies the columns that the foreign key references. For a unique or primar...not available in DuckDB. VARCHAR NULL reference_generation Applies to a feature not available in DuckDB. VARCHAR NULL user_defined_type_catalog If the table is a typed table, the name of the database that contains the underlying data type (always the cu...rrent database), else NULL . Currently unimplemented. VARCHAR NULL user_defined_type_schema If the table is a typed table, the name of the schema that contains the underlying data type, else NULL . Curr... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Node.js API – DuckDB 8885
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...ance method of Connection Param Type sql …params \* connection.register_udf(name, return_type, fun) ⇒ void Register a User Defined Function Kind : instance method of Connection Note : this follows the wasm udfs somewhat but is simpler because we can pas...ection Param Type sql …params \* callback connection.register_udf_bulk(name, return_type, callback) ⇒ void Register a User Defined Function Kind : instance method of Connection Param name return_type callback connection.unregister_udf(name, return_type,...callback) ⇒ void Unregister a User Defined Function Kind : instance method of Connection Param name return_type callback connection.register_buffer(name, array, forc... - https://man.mtool.work/duckdb/1.3/clients/nodejs/reference.html
- Bitstring Functions – DuckDB 8885
- 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
...d on all bitstrings in a given expression. bitstring_agg(arg) Returns a bitstring with bits set for each distinct position defined in arg . bitstring_agg(arg, min, max) Returns a bitstring with bits set for each distinct position defined in arg . All po...ty and dense values. bitstring_agg(arg, min, max) Description Returns a bitstring with bits set for each distinct position defined in arg . All positions must be within the range [ min , max ] or an Out of Range Error will be thrown. Example bitstring_a... - https://man.mtool.work/duckdb/1.3/sql/functions/bitstring.html
- Utility 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
...expression. For PostgreSQL compatibility. query( query_string_literal ) Table function that parses and executes the query defined in query_string_literal . Only literal strings are allowed. Warning: this function allows invoking arbitrary queries, pote...pg_typeof('abc') Result varchar query(query_string_literal) Description Table function that parses and executes the query defined in query_string_literal . Only literal strings are allowed. Warning: this function allows invoking arbitrary queries, pote...lob pattern matching syntax . repeat_row(varargs, num_rows) Returns a table with num_rows rows, each containing the fields defined in varargs . glob(search_path) Description Return filenames found at the location indicated by the search_path in a single... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- SELECT Clause – DuckDB 7906
- 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
...ities ORDER BY population DESC ; The DISTINCT ON clause returns only one row per unique value in the set of expressions as defined in the ON clause. If an ORDER BY clause is present, the row that is returned is the first row that is encountered as per t...he ORDER BY criteria. If an ORDER BY clause is not present, the first row that is encountered is not defined and can be any row in the table. When querying large data sets, using DISTINCT on all columns can be expensive. Therefore,... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
DuckDB 1.3 Documentation / man.mtool.work